Comments (1)
entechlog
commented on July 21, 2024
@robscriva , Sorry it took so long to get back to you on this one
- Just was testing this out and unapply works in post/pre-hooks
- Here are the steps I followed, added post-hook
post-hook:
- "{{ dbt_snow_mask.unapply_masking_policy('models') }}"
- Executed the models by
dbt runand it ran fine removing the policy
00:17:54 Running with dbt=1.0.1
00:17:54 Unable to do partial parsing because a project config has changed
00:18:00 Found 1 model, 0 tests, 0 snapshots, 0 analyses, 404 macros, 0 operations, 1 seed file, 1 source, 0 exposures, 0 metrics
00:18:00
00:18:04 Concurrency: 10 threads (target='dev')
00:18:04
00:18:04 1 of 1 START view model staging.stg_customer.................................... [RUN]
00:18:05 00:18:05 | creating masking policy : DEMO_DB.STAGING.MP_ENCRYPT_PII
00:18:06 00:18:06 | unapplying masking policy to model : DEMO_DB.STAGING.MP_ENCRYPT_PII on DEMO_DB.staging.stg_customer.email
00:18:07 1 of 1 OK created view model staging.stg_customer............................... [SUCCESS 1 in 2.52s]
00:18:07
00:18:07 Finished running 1 view model in 7.09s.
00:18:07
00:18:07 Completed successfully
00:18:07
00:18:07 Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1
- Did I miss something in understanding your request ?
from dbt-snow-mask.
Related Issues (20)
- Improvement: include sourcename or modelname in posthook to minimise overhead on run model tasks HOT 2
- Masking policy is not applied HOT 8
- apply policy to all models HOT 6
- Apply masking policy with FORCE keyword HOT 5
- Ability to update existing masking functions HOT 2
- Improvement: Allow for default dbt schema name generation HOT 2
- Improvement/bug: alert or warn when a masking policy specified does not exist
- dbt snow mask versioning HOT 2
- Feature Request: Make log optional
- Hyperlink to dbt's meta documetation HOT 1
- Post-hook executed as a pre-hook HOT 2
- Feature Request: Conditional Masking Policy HOT 3
- Applying policy on tables
- Masking policy does not apply for models or snapshots HOT 4
- Conditional Masking Policy does not need `{{masked_column}}` in its body
- Insufficient privilege to create a masking policy
- Unapply policies should handle if the materialization exists or not
- on-run-start with 'models' parameter failed HOT 1
- Abillity to use macro on dynamic talbe
- Ability to pass in node and custom_schema_name HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt-snow-mask.