Recent Articles

  • Seeing Status Clearly: Icon-Based Snowflake Status

    Seeing Status Clearly: Icon-Based Snowflake Status

    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. Read more

  • Hiding Download Button in Snowsight: A Step-by-Step Guide

    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. Read more

  • Late Arriving or Out-Of-Order Data Loads with Snowflake Dynamic Tables

    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… Read more

  • Streamline Snowflake Queries: Filter Columns with ILIKE Patterns

    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. Read more

  • Streamlit in Snowflake: Building a Dynamic Pivot Query App with Selectable Criteria

    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. Read more

  • Dynamic Pivot Queries in Snowflake: A Practical Example and Benefits

    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. Read more