SnowStat is a single-page Streamlit app designed to enhance the Snowflake status page’s accessibility, particularly for colorblind users. It features icon-first indicators, a consistent layout, and auto-refresh capabilities, providing quick access to operational health data. This tool improves efficiency by simplifying the status information for better scanning.
Tag Archives: streamlit
Streamlit in Snowflake: Building a Dynamic Pivot Query App with Selectable Criteria
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.
Snowflake Cortex: Vectorizing Text and Customer Record Matching
The post discusses the challenges of managing customer information, with a focus on using Snowflake Cortex to integrate and compare customer data. It highlights the addition of VECTOR data types and LLM functions to assist in text vectorization, as well as methods for scoring customer name similarity. The creation of a Streamlit app for demonstration and the use of various models for vectorizing data are also covered. The author emphasizes the need for careful monitoring and tuning of scoring thresholds to ensure accurate customer identification.
Eric Heilman 