Vertica Analytics Platform Version 9.2.x Documentation

AWS_GET_CONFIG

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