AWS_SET_CONFIG

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 value: us-east-1

aws_ca_path

The path Vertica uses to look up SSL server certificates.

Default value: System-dependent
aws_ca_bundle

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

Default value: 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 value: false
aws_max_send_speed

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

Default value: unlimited
aws_max_recv_speed

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

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