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”
Tag Archives: Data Governance
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”