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.
Category Archives: Tech Stuff
Hiding Download Button in Snowsight: A Step-by-Step Guide
The content discusses managing the visibility of the Download results button in Snowsight through the DISABLE_UI_DOWNLOAD_BUTTON setting. It details a Python stored procedure to apply this setting to users by role, enabling organizations to control data export privileges. Verification steps and operational notes for effective management are included.
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.
Eric Heilman 