Unable to set session params for awslib
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:
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.