0

I'm working with Dynamic Tables in Snowflake and trying to apply masking policies to hide sensitive data. However, when I create the dynamic table, I get the following error:

The masking policies are using current_user() and current_role() and are sort to the tables used in the dynamic table..

Error: context function

I would like to know:

  1. Is it possible to use masking policies with Dynamic Tables in Snowflake in incremental mode?
  2. How can I resolve the "context function" error?

I tried to use a masking policy with a context function

1
  • 2
    Yes, you can create masking policies on a dynamic table. Please update your question to show the DDL for the masking policy and the DDL for how you are applying it to a column in a table
    – NickW
    Commented Jul 8 at 15:54
Related questions
1
Snowflake tags and tag based masking policies
1
Snowflake Dynamic Table support for`UNION ALL`
0
Snowflake dynamic masking masks underlying table: the derivative tables are not masked and views become empty?
Load 5 more related questions Show fewer related questions

0

Reset to default