Output more than 6 Million rows and 10 columns

[Puru]

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

[fmvizcaino]

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%2...

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