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

Is there a way to copy RDS table without sensitive information?

0

Is there a special feature or service that can be used to copy RDS postgresql table from a DB to another without sensitive data like(emails, passwords, phone numbers....)

Topics
Database
Tags
RDS Custom for SQL ServerPostgreSQL
Language
English
asked 3 years ago1.5K views
2 Answers
2
Accepted Answer

A dynamic data masking solution can be used in this case. You could leverage AWS DMS here is a link for more information: https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/ I would suggest that you use PostgreSQL Anonymizer but unfortunately it is not supported by RDS anymore.

AWS
answered 3 years ago
EXPERT
reviewed 2 years ago
AWS
EXPERT
reviewed 3 years ago
0

Hi, I would suggest to go one step further if you don't know where all your sensitive info is located: dump your db to S3 and run its content through MaCie Check out https://aws.amazon.com/macie/

EXPERT
answered 3 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.

Relevant content