Output more than 6 Million rows and 10 columns

Question

What is the best option to write more than 6 Million records to Table in Aurora?

fmvizcaino · Answer

Hi @Puru ,

I know for a fact that we can use a S3 bucket to bulk loading data into AWS Redshift but I think we can't do that automatically for Aurora.

https://help.alteryx.com/2020.1/DataSources/Redshift.htm?tocpath=Data%20Sources%7CSupported%20Data%20Sources%20and%20File%20Formats%7C_____5

For Aurora, maybe you can do that manually by configuring the S3 bucket itself but that is something I have never done.

http://cloudiqtech.com/bulk-load-data-files-into-aurora-rds-from-s3-bucket/

Best,

Fernando Vizcaino