Vertica Library for Amazon Web Services Parameters

Use these parameters to configure the VerticaLibrary for Amazon Web Services (AWS). All parameters listed are case sensitive.

Parameter Description
aws_id

Your AWS access key ID.

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_id='<YOUR AWS ID>';
aws_secret

Your AWS secret access key.

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='<YOUR AWS KEY>';
aws_region

The region your S3 bucket is located. aws_region can only be configured with one region at a time. If you need to access buckets in multiple regions, you must re-set the parameter each time you change regions.

Default value: us-east-1

You can find more information about AWS regions in the Amazon Documentation.

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_region='<REGION IDENTIFIER>';
aws_ca_path

The path which Vertica will use when looking for SSL server certificates.

Default value: system dependent

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_ca_path= /home/user/ssl_folder;
aws_ca_bundle

The path which Vertica will use when looking for a SSL server certificate bundle.

Default value: system dependent

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_ca_bundle= /home/user/ssl_folder/ca_bundle;
aws_proxy

A string value which allows you to set an HTTP/HTTPS proxy for the AWS library.

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_proxy='192.168.1.1:8080;
aws_verbose

When enabled, logs libcurl debug messages to dbLog.

Default value: false

Example:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_verbose= 1;
aws_max_send_speed

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

Example:

The following example sets a maximum send speed of 1KB/S:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_max_send_speed= 1024;
aws_max_recv_speed

Sets the maximum transfer speed when receiving data to AWS S3 in bytes per second.

Example:

The following example sets a maximum receive speed of 100KB/S:

=> ALTER SESSION SET UDPARAMETER FOR awslib aws_max_recv_speed= 102400;

For more information, see the following topics in the Administrator's Guide: