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!

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html

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

https://stackoverflow.com/questions/58616005/import-postgres-data-into-rds-using-s3-and-aws-s3

It just throws a permission error

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