By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
PostgreSQLRDS Custom for SQL Server
Language
English
Robert Deschamps
asked a year ago1248 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
Othnajid
answered a year ago
profile picture
EXPERT
Oleksii Bebych
reviewed 5 months ago
profile pictureAWS
EXPERT
kentrad
reviewed a year 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/

profile pictureAWS
EXPERT
Didier_Durand
answered a year 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