AWS RDS and Aurora database services have a very useful enhancement, aws_s3.query_export_to_s3, to the native PostgreSQL COPY command, that lets you export from RDS/Aurora directly to AWS S3 storage. This can be very useful for moving data around, including exporting from Production with masking functions to land in test/debugging environments. There are currently some limitations around cross-account exporting, like you can’t. But simple workarounds to post-process the files to either reke...
