During a recent build of a Snowflake data environment, I encountered a challenge while translating my SQL Server code to Snowflake. As any seasoned database developer knows, dealing with staging tables and SCD (Type-2 slowly changing dimension) tables is par for the course in data warehousing. In the realm of table creation, there’s the classicContinue reading “Snowflake: Creative Create Table Tactics”
Category Archives: Snowflake
Python Byte: Loading Data to Snowflake from SQL Server
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”
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”
Eric Heilman 