In a recent article, I showed a local Streamlit app that enforces role-based row access policies based on the Snowflake role used in the session variable. The selectbox in the app simulated how the app would act as users in different roles executed the app. Are native Streamlit apps capable of using RBAC for RowContinue reading “Streamlit in Snowflake: Navigating Role-Based Row Access Complexity”
Category Archives: Tech Stuff
Snowflake: Table-Driven Row Access Policies
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”
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”
Eric Heilman 