This article describes how to create a Streamlit app within Snowflake that builds on a previous dynamic pivot query tutorial. It covers creating a view from a Common Table Expression, setting up select boxes for user input, and executing a dynamic SQL query to display results in a data frame for easy visualization.
Tag Archives: data-science
Efficiently Load Excel Files to Snowflake Without ETL Tools
Data professionals often face challenges when transferring data from Excel to database systems. However, leveraging Python libraries pre-loaded into Snowflake enables efficient loading of Excel files with a few simple steps, bypassing traditional ETL complexity. This process involves confirming file location, capturing sheet names, reading Excel data, and writing it to Snowflake.
Eric Heilman 