AWS_GET_CONFIG

The AWS library is deprecated. To export delimited data to S3 or any other destination, use EXPORT TO DELIMITED.

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 value: 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