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

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년 전
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 ?

주제

서버리스 컴퓨팅 마이그레이션 및 현대화 분석 데이터베이스 스토리지

태그

AWS Lambda 아마존 Relational Database Service AWS Glue 오로라 MySQL S3 선택

언어

English

rePost-User-8320546

질문됨 2년 전662회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

Amir_C

답변함 2년 전

지원 엔지니어

AWS_SamM

검토됨 2년 전

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

관련 콘텐츠