Understanding Row Level Access Control | Snowflake Tutorial
#snowflakedatawarehouse #snowflaketutorial #snowflakedatabase
Snowflake supports row-level security through the use of row access policies to determine which rows to return in the query result.
The row access policy can be relatively simple to allow one particular role to view rows, or be more complex to include a mapping table in the policy definition to determine access to rows in the query result.
A row access policy is a schema-level object that determines whether a given row in a table or view can be viewed.
In this video I walk you through a demo which includes a common use case which can be addressed using row access policies.
❄️Want to SUPERCHARGE your career and become an EXPERT in Snowflake??❄️
Mastering Snowflake is accepting applications now to work with us in a small group. Serious inquiries only pls. Book a call with us here:
https://apply.masteringsnowflake.com/...
❄️Get my Free SnowPro core guide HERE: ❄️
https://program.masteringsnowflake.co...
❄️Become a student on my course: ❄️
Snowflake Practice Questions - SnowPro Core Certified Udemy Course https://www.udemy.com/course/snowflak...
❄️Connect with me on Linkedin:❄️
/ adammorton121
Contents:
0:00 - Intro
0:41 - Row Access Policies
2:05 - Example Scenario
2:54 - Hands on demo
3:24 - Loading data
4:38 - Creating the row access policy
6:30 - Creating roles and granting privileges
7:18 - Testing out the different roles
8:44 - Adding the mapping table