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.