Previously, I walked through loading NOAA Weather Station location data from NOAA’s public S3 bucket into Snowflake, but what now? We have a list of hundreds of weather stations with coordinates, but what can we do with them? What if we plotted them on a map, but only showed those stations within a certain distanceContinue reading “Exploring NOAA Weather Stations: Mapping Locations Within Snowflake Using Streamlit”
Category Archives: streamlit
Streamlit in Snowflake: Navigating Role-Based Row Access Complexity
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”
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 