Facing issue while exporting data from Vertica to S3 using s3export

user_2664210 0
Viewed 682

I am exporting data from Vertica to S3 using s3export. It is giving below exception:

[Vertica][VJDBC](5861) ERROR: Error calling processPartition() in User Function s3export at [src/S3.cpp:471], error code: 0, message: Client Error: The request signature we calculated does not match the signature you provided. Check your key and signing method.

how to resolve this issue?

Thanks in advance!

vertica amazon-s3
1 Answers

This could be because of the incorrect AWS credentials provided. Alter the vertica session to include the aws credentials for awslib. Something as -

ALTER SESSION SET UDPARAMETER FOR awslib aws_id='*****'

ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='*****'

ALTER SESSION SET UDPARAMETER FOR awslib aws_session_token='****' (If using temp credentials)
user_129515690
Related