AWS_SET_CONFIG

Gets the values from a table with your Amazon Web Services (AWS) credentials and passes them to session parameters.

Syntax

AWS_SET_CONFIG( 'parameter' = 'value')

Parameters

aws_id

Specifies the 20-character AWS access key used to authenticate your account.

aws_secret

Specifies the 40-character AWS secret access key used to authenticate your account.

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 valueus-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

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

Default value: unlimited

aws_max_recv_speed

Sets 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 table keychain:

=> 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