entechlog / dbt-snow-mask

This repository contains source code for dbt package dbt_snow_mask.
https://hub.getdbt.com/entechlog/dbt_snow_mask/latest/
GNU General Public License v3.0
60 stars 25 forks source link

changes to add flag to control common masking policy db #25

Closed entechlog closed 2 years ago

entechlog commented 2 years ago

changes to add flag to control common masking policy

How to configure database and schema for the masking policy ?

By default this process creates the masking policies in same directory as the database objects. You can change this default behavior by using following parameters in your dbt_project.yml

Test result with config enabled

vars:
  use_common_masking_policy_db: "True"
  common_masking_policy_db: "DEMO_DB"
  common_masking_policy_schema: "GDPR"

image

Test result without config in project image

Data in snowflake image