Import and Export to S3 from Amazon Aurora with PostgreSQL compatibility subfolder gotcha

UPDATE – I was prefacing the file with a forward slash… once removed it works fine!

SELECT aws_commons.create_s3_uri( ‘aurora-pg-sample-loaddata’, ‘testfolder/Final/apg2s3_tableFinal’,’eu-central-1′) AS s3_uri_1 \gset

This is a pretty cool feature!

One gotcha though! It looks like you can only import from the root of an S3 bucket!

It just throws a permission error

ERROR: HTTP 403. Permission denied. Check bucket or provided credentials as they may no longer be valid.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s