AWS_SET_CONFIG

The AWS library is deprecated.

Sets the values of AWS library S3-Compatible user-defined session parameters for the current session. This function is designed to be used with a table that contains those values, rather than by setting values explicitly in the function call.

Syntax

AWS_SET_CONFIG( 'parameter' , 'value')

Parameters

aws_id
The 20-character AWS access key used to authenticate your account.
aws_secret
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
Specifies the region where your AWS bucket is located. See the AWS Documentation for the full list of values.

You can configure aws_region with only one region. To access buckets in multiple regions, reset the parameter each time you change regions.

Default: us-east-1

aws_ca_path
The path Vertica uses to look up SSL server certificates.

Default: System-dependent

aws_ca_bundle
The path Vertica uses to look up an SSL server certificate bundle.

Default: System-dependent

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.

Default: false

aws_max_send_speed
The maximum transfer speed for sending data to AWS S3, in bytes per second.

Default: unlimited

aws_max_recv_speed
The maximum transfer speed when receiving data to AWS S3, in bytes per second.

Default: unlimited

Examples

Configure session parameters for an AWS access key and secret access key with credentials in the keychain table:

=> SELECT AWS_SET_CONFIG('aws_id', accesskey),
          AWS_SET_CONFIG('aws_secret', secretaccesskey)
   FROM keychain;
 AWS_SET_CONFIG | AWS_SET_CONFIG
----------------+----------------
 aws_id         | aws_secret
(1 row)

See also