Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Can I simulate how a row access policy will work to make sure its working correctly with different scenarios and roles?

0

Can I simulate how a row access policy will work to make sure its working correctly with different scenarios and roles?

Frank Bell Answered question July 19, 2022
0

Next, define a policy with one or more conditions to query the mapping table with a subquery. At query runtime, Snowflake determines whether the user executing the query matches the sales region specified in the mapping table. If a match occurs, the user can see those rows in the query result. Based on the mapping table, the expected query results are as follows:

Frank Bell Answered question July 19, 2022

Maximize Your Data Potential With ITS

Feedback on Q&A