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: data
Streamline Snowflake Queries: Filter Columns with ILIKE Patterns
The post discusses the challenges of querying large data tables, particularly with similarly named columns. It introduces the ILIKE keyword in Snowflake for case-insensitive searches to simplify SQL queries. The author provides a practical SQL example using weather data, highlighting the efficiency of ILIKE in reducing query costs by targeting specific column patterns.
Dynamic Pivot Queries in Snowflake: A Practical Example and Benefits
This post explores dynamic pivoting in Snowflake, showcasing its query example for simplifying data manipulation and reporting. It explains the step-by-step breakdown of a query that filters sales data by region and dynamically generates pivot columns based on unique nation names, enhancing adaptability, scalability, and efficiency in reporting.
Eric Heilman 