AWS_GET_CONFIG
Returns the current Amazon Web Services (AWS) credentials set by AWS_SET_CONFIG
or ALTER SESSION
.
Syntax
AWS_GET_CONFIG( 'parameter' )
aws_id aws_secret aws_session_token aws_region aws_ca_path aws_ca_bundle aws_proxy aws_verbose aws_max_send_speed aws_max_recv_speed
Parameters
aws_id
|
Retrieves the value for the 20-character AWS access key used to authenticate your account |
|
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 value: |
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)