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: