Can I Import .sql files from Encrypted s3 bucket into Encrypted MySQL RDS instance?

Question

An offshore team is dumping daily raw data from a SQL instance (.sql.gz zipped files) into an s3 bucket in my org. Task at hand is to import this data into a MySQL RDS instance, query the instance, transform the data then load it into a Postgresql instance. I can't seem to find a way to do this with Lambda or Glue or any third party application

Answer

Hello, Thank you for your question. There are some limitations on importing files from s3 to Amazon RDS. You can't import .sql files from an encrypted backup in an s3 bucket to RDS. 
* Here's the official document on limitations and recommendations for importing files from s3 to Amazon RDS: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html#MySQL.Procedural.Importing.Limitations

Can I Import .sql files from Encrypted s3 bucket into Encrypted MySQL RDS instance?

相關內容