awslabs / awslabs/amazon-redshift-utils
Generate DDL for Data Masking Schemas when selecting tables from awslabs view v_generate_tbl_ddl
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
We make use of the AWS Labs supplied view called, v_generate_tbl_ddl.
This view generates the DDL code from the objects that exist in one environment, so we can drop and re-create them in another environment.
If in future the new “Data Masking Schemas” will be created and applied to the tables, then we would like to request
that this view be maintained to export the applicable “Data Masking Schemas” for the specified tables or other objects as well, please.
Preferably when selecting tables from the view we would like the DDL to include the “Data Masking Schemas” that are applicable as well so we can recreate the tables in another environment along with the “Data Masking Schemas”.
Contributor guide
Research direction
Start by locating the definition of the AWS Labs view v_generate_tbl_ddl and reviewing how it identifies the selected tables and other objects. Determine how Redshift Data Masking Schemas are represented and associated with those objects. Done means the view's generated DDL includes the applicable masking schemas when tables are selected, with coverage verified against representative objects.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, security
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100