By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

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

  • Ashish_P
    2 years ago

    Q-1: What do you mean by encrypted S3 bucket and encrypted MySQL RDS ? Are both encrypted with AWS managed keys / Custom Key ? Q-2: In subject line you have mentioned MySQL RDS but in actual question you have mentioned PostgreSQL, can you please clarify ?

Topics
ServerlessComputeMigration & ModernizationAnalyticsDatabaseStorage
Tags
AWS LambdaAmazon Relational Database ServiceAWS GlueAurora MySQLS3 Select
Language
English
rePost-User-8320546
asked 2 years ago650 views
1 Answer
0

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.

Amir_C
answered 2 years ago
AWS
SUPPORT ENGINEER
AWS_SamM
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content