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: cloud
Late Arriving or Out-Of-Order Data Loads with Snowflake Dynamic Tables
The article discusses challenges data engineers face with late or out-of-order data affecting dimensional models. It introduces Snowflake’s Dynamic Tables, which streamline the management of such data issues without requiring complex resets. The author shares a practical demo using JSON records from a CRM to illustrate the effectiveness of Dynamic Tables in processing evolving customer 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.
Eric Heilman 