For aws_s3.query_export_to_s3, is it possible to export to a S3 bucket in another account?

Question

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export-functions.html
As title says, I am trying to export the data directly to another account.
The input to the function is a bit limited. I am just wondering if it is possible if setting up IAM for cross account access maybe?
Or maybe there is a different way?

Any help would be appreciated. Thank you!

Riku_Kobayashi · Accepted Answer

Hello.

As far as I know, as of December 2024, when outputting data from RDS to S3 using the aws_s3 function, it is not possible to output to S3 of another account.  
This should not be possible for both Aurora PostgreSQL and RDS PostgreSQL as well.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.html  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html  
> Cross-account export to Amazon S3 isn't supported.

Therefore, I think it is necessary to create a mechanism to copy the file to S3 of another account once it is created.

For aws_s3.query_export_to_s3, is it possible to export to a S3 bucket in another account?

Add your answer

Relevant content