How do I know my row access policy is working? Can I audit it somehow?
Snowflake provides this functionality to check on your row access policies: \n*standard SHOW command. This produces a list of row access policies you have. \n*POLICY_REFERENCES table function – shows references. it is within information_schema. See here: \n*SNOWFLAKE.ACCOUNT_USAGE.POLICY_REFERENCES view shows the associations of the policy. [oh, also realize if you have a standard account or you have an ACCOUNT where row access policies are not enabled… this doesn’t exist. ]\n*SNOWFLAKE.ACCOUNT_USAGE.ROW_ACCESS_POLICIES View provides similar information as the SHOW ROW ACCESS POLICIES COMMAND.