Home icon

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
Go to article

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
Author data integration jobs with an interactive data preparation experience with AWS Glue visual ETL
Jul 28
2026
Automated PII redaction for Amazon RDS for PostgreSQL audit logs
Jul 2
2026
Data masking in Amazon RDS for Oracle
Apr 11
2024
Migrate Microsoft Azure SQL Database to Amazon RDS for SQL Server using Smart Bulk Copy

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.