Row Access Policy on Snowflake

ALTR deploys a Row Access Policy to Snowflake as a native Snowflake Row Access Policy object. Snowflake evaluates the policy natively at query time — there is no external function call.

Deployment

When you create a Row Access Policy, ALTR translates its reference column and rule statements into a native Snowflake Row Access Policy object and deploys it to your Snowflake account. The policy takes effect on the next query against the target table; no external function or additional Snowflake configuration is required.

Note

A table can have one Row Access Policy, and the reference column must already exist on the table before the policy is created.

Policy Size Limits

A Row Access Policy can be up to 10,000 characters, which limits how many role-and-value rule statements a single policy can hold. Role names longer than 257 characters can’t be used in a Row Access Policy.

Delete a Row Access Policy

Deleting a Row Access Policy stops filtering rows for the roles it covered. ALTR removes the policy from both ALTR and your Snowflake account.

To delete a Row Access Policy:

1. Select Policy in the navigation menu.
2. Expand the policy to delete.
3. Click Edit Policy.
4. Click Delete Policy; a confirmation modal displays.
5. Click Delete Policy to confirm.

Force Delete a Row Access Policy

Danger

Consult ALTR Support before force deleting a Row Access Policy. Force deleting can have a negative effect on your Snowflake account if you don’t fully understand the policy and its data. This action cannot be undone.

If a standard delete doesn’t complete, a Trouble deleting? option lets you force delete the policy instead. Force delete removes the policy from ALTR even if it can’t be removed from Snowflake; use it as a last resort.

To force delete a Row Access Policy:

1. Select Policy in the navigation menu.
2. Click the Row Access Policy to delete.
3. Click Edit Policy.
4. Click Delete Policy; a confirmation modal displays.
5. Click Trouble deleting?.
6. Click Force Delete Policy.
7. Review your Snowflake account and clean up any objects left behind.