This post concludes recent work and commentary on exporting masked data from one AWS Aurora PostgreSQL environment to another: PostgreSQL Masking Functions AWS RDS Aurora PostgreSQL Query Export to S3 Stub AWS RDS Aurora PostgreSQL Table Import from S3 Stub We were able to export masked data successfully and import it without issue. The export is significantly slower than the import, at least in our case where we needed many of the exports to have joins in order to restrict what data was expo...| renaghan.com
Protecting your data is important, both from people who want to get it, and more importantly from your own staff who are only-human, and thus subject to making mistakes. Using Production data can be very useful for all kinds of debugging and testing. But you don’t want to expose confidential production data to staff that do not need to see it. Masking is useful as you export data from Production and load it into your test/debug environment.| renaghan.com