AWS_GET_CONFIG

The AWS library is deprecated.

Returns the current Amazon Web Services (AWS) credentials set by AWS_SET_CONFIG or ALTER SESSION.

Syntax

AWS_GET_CONFIG( 'parameter' )

Parameters

aws_id
Retrieves the value for the 20-character AWS access key used to authenticate your account
aws_secret
Retrieves the value for the 40-character AWS secret access key used to authenticate your account
aws_session_token
The AWS temporary security token generated by running the AWS STS command get-session-token. This AWS STS command generates temporary credentials you can use to implement multi-factor authentication for security purposes. For more information on get-session-token, see the AWS documentation.
aws_region
Retrieves the region where your AWS bucket is located. See the AWS Documentation for the full list of values.

Default: us-east-1

aws_ca_path
Retrieves the path Vertica uses to look up SSL server certificates..
aws_ca_bundle
Retrieves the path Vertica uses to look up an SSL server certificate bundle.
aws_proxy
A string value that lets you set an HTTP/HTTPS proxy for the AWS library.
aws_verbose
When enabled, logs libcurl debug messages to dbLog.
aws_max_send_speed
Retrieves the value for the maximum transfer speed when sending data to AWS S3, in bytes per second.
aws_max_recv_speed
Retrieves the value for the maximum transfer speed for receiving data to AWS S3, in bytes per second.

Examples

This example retrieves a stored AWS access key in a session.

=> SELECT AWS_GET_CONFIG('aws_id');
   aws_get_config
----------------------
 AKABCOEXAMPLEPKPXYZQ
(1 row)

See also