Copy and mask PII between Amazon RDS databases using visual ETL jobs in AWS Glue Studio
Big Data Blog
This article explains how to copy data from one Amazon RDS PostgreSQL database to another while automatically masking personally identifiable information (PII) using AWS Glue Studio, a low-code visual editor for building ETL pipelines.
Specifically, the article covers:
- Solution overview and prerequisites
- Enabling connectivity between the AWS accounts hosting the source, target, and AWS Glue resources
- Creating AWS Glue components like connections and crawlers to access the databases
- Building a visual ETL job in AWS Glue Studio with steps for data extraction, PII detection and masking, data transformation, and loading to the target database
- Running the ETL job and verifying the results
- Cleaning up the resources created
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Jul 10
2024
2024
Author data integration jobs with an interactive data preparation experience with AWS Glue visual ETL
Apr 11
2024
2024
Migrate Microsoft Azure SQL Database to Amazon RDS for SQL Server using Smart Bulk Copy
Apr 21
2025
2025
Migrate SQL Server user databases from Amazon EC2 to Amazon RDS Custom using Amazon EBS snapshots
Feb 19
2024
2024
Migrate tables from Microsoft Access to Amazon RDS for MySQL
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.