In a previous article, I showed how to set a row access policy on a view to limit the rows returned by a query dependent upon the user’s role in Snowflake. The row access policy had the roles I cared about hard coded into the policy code; however, in a real-world scenario, that isn’t manageableContinue reading “Snowflake: Table-Driven Row Access Policies”
Category Archives: Snowflake
Streamlit: Application of Snowflake Row Access Policies
In my last post, I showed how to set up hierarchical roles in Snowflake and then apply a row access policy based on those roles. In this article, I’ll show an application of those policies using a Streamlit app. An important note is that this is not a native Streamlit app in Snowflake. As of the writing ofContinue reading “Streamlit: Application of Snowflake Row Access Policies”
Snowflake: Row Access Policy with Hierarchical Roles
“Row Access Policy with Hierarchical Roles” is a mouthful! What in the world am I talking about? I’ll start with hierarchical roles since most organizations have some hierarchical people reporting structure. Next, I’ll discuss Snowflake’s row access policy and how it applies to hierarchical roles. Hierarchical Roles Snowflake uses role-based access control (RBAC) for objectContinue reading “Snowflake: Row Access Policy with Hierarchical Roles”
Eric Heilman 