awslabs / awslabs/amazon-redshift-utils

Generate DDL for Data Masking Schemas when selecting tables from awslabs view v_generate_tbl_ddl

Open
#683 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.