What type of SQL Statments can I use ROW Access Policies with?
SELECT statements and UPDATE, DELETE, and MERGE statements. Interestingl, you can actually use UPDATE, DELETE, and MERGE statements AGAINST rows selected with a Row Access Policy.
Copyright 2023 IT Strategists, Inc. All Rights Reserved. Community site to educate and connect Snowflake users, not part of Snowflake Inc.
We share extensive Snowflake Solutions we have synthesized over 6 years of Snowflake Experience and Snowflake Data Superheroes for your Learning Efficiency. Sign up to receive a copy of Frank’s Snowflake Best Practices Blueprint and join 3,000+ others in receiving bi-weekly emails on data, automation and Snowflake optimization from 4x Snowflake Data Superhero.
By Frank Bell and ITS – Snowflake Solutions – Over 3000 subscribers
