Unable to set session params for awslib

bdoucet

I'm trying to export a table in parquet format to S3 using S3EXPORT() and am receiving an error I cannot resolve when trying to set the session params.

I'm following the instructions outlined in this support article:

https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/configuringVerticaAWSLibrary.htm

I've generated my session params using SAML and when issuing the first command on Step 2 I receive an error:

ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='<my_aws_secret_access_key';

An error occurred when executing the SQL command:
ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='<my_aws_secret_access_key'

SQLValidation failure: mismatched input 'FOR' expecting '=' line: 1 position: 31
1 statement failed

I cannot figure outhow to edit that command to commit it successfully.

I am running Vertica Analytic Database v10.1.1-6.

I also could not determine if there is any other initial setup required to initiate awslib on the database.

SruthiA

@bdoucet : Could you please try the using AWS_SET_CONFIG once?

https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/AWS_SET_CONFIG.htm

bdoucet

Thanks for the quick reply @SruthiA

I tried that command and received the following error:

[Vertica][VJDBC](4566) ERROR: Relation "keychain" does not exist; [Vertica][VJDBC](4566) ERROR: Relation "keychain" does not exist

bdoucet

@SruthiA in order to use the AWS Lib does our Vertica database need to be hosted on AWS? We used Vertica through GoodData which is our BI Vendor and Vertica serves as the backend.

bdoucet

@SruthiA in order to use the AWS Lib does our Vertica database need to be hosted on AWS? We used Vertica through GoodData which is our BI Vendor and Vertica serves as the backend.

SruthiA

@bdoucet : please set it as follows

SELECT AWS_SET_CONFIG('aws_id', 'accesskey');
SELECT AWS_SET_CONFIG('aws_secret', 'secretaccesskey')

bdoucet

Thank you @SruthiA that actually worked and got me further along. Now i'm encountering an error stating that export to S3 is not allowed. Do I need to grant those privileges to the user?

Data export to S3 is not allowed. ProxyException(connectionId:f01301a6-f892-44ac-8974-050e781ded86, exceptionId:6a69caeb-eb6e-4ab0-8827-8fee7e5c1556, message:Data export to S3 is not allowed.)

SruthiA

@bdoucet : This error doesnt look like a vertica error.. if it was a permissions issue, then it would generally display a different message. Could you please check if there are any network issues?