search

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

Ability to update existing masking functions #48

Closed brianschillaci closed 2 years ago

brianschillaci commented 2 years ago

Hello!

My team has started using this package for masking and it's been working awesome. But one thing we ran into is having to manually update the masking functions (alter function statements) if for example we needed to add an additional role to the masking targets.

Is the only way to do this currently through dbt to unapply all masking, drop the functions, recreate functions and reapply them? Ideally we wouldn't want to do this because it would expose sensitive data for a short period of time. I might be missing some functionality that already exists?

Thanks!

entechlog commented 2 years ago

Thank You for the feedback and the future request. Can you check the recent release candidate and see if this helps to fix the issue ?

brianschillaci commented 2 years ago

Yep, that's what we were looking for as well. Thank you!