For a recent proof of concept, I needed to transfer data from five or six relatively small tables from SQL Server to Snowflake. Normally, I would go through all the steps to set up an ingestion pipeline in Snowflake; however, for a POC, that all seemed like overkill. I simply needed to copy the dataContinue reading “Python Byte: Loading Data to Snowflake from SQL Server”
Tag Archives: Python
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”
Snowflake Demo Repo
In the last few months, I’ve posted quite a few articles showing demos in Snowflake. My personal goal was to post one article per week covering a single topic in Snowflake, SQL Server or technical leadership. I accomplished that goal by spending the early morning hours before my family woke up by reading, testing andContinue reading “Snowflake Demo Repo”
Eric Heilman 