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.
Category Archives: Snowflake
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.
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 