When you query a table with a row access policy, how does the policy impact the query? How is it processed?

4.02K viewsSecurity in SnowflakeRow Access Policies
0

When you query a table with a row access policy, how does the policy impact the query? How is it processed?

Frank Bell Answered question February 9, 2022
0

such as a row access policy on a table and a row access policy on a view for the same table. At query runtime, Snowflake evaluates all row access policies that are relevant to a given query in the following sequence:\n\nThe row access policy that is applicable to the table is always executed first.\nThe policy for the view is executed after evaluating the policy for the table.\nIf nested views exist (e.g. Table 1 -> View 1 -> View 2 -> … View n), the policies are applied in sequential order from left to right.\nThis pattern continues for however many row access policies exist with respect to the data in the query. The following diagram illustrates the relationship between a query operator, tables, views, and policies.

Frank Bell Answered question February 9, 2022