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')

aws_id aws_secret aws_region aws_ca_path aws_ca_bundle aws_proxy aws_verbose aws_max_send_speed aws_max_recv_speed
Parameters
aws_id
|
Specifies the 20-character AWS access key used to authenticate your account. |
|
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 Default value: |
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)