I have been creating a new RDS table every day that sometimes reaches about 10 GB in that day. My goal is to dump this table to S3 more efficiently.
My current method of doing this is:
SELECT * FROM table;
Dump those rows to a CSV
Upload that CSV to S3
Delete the CSV file
Is there a way that I am able to dump the RDS table to S3 directly instead of generating that CSV locally and then dumping that to S3?