Advance SQL Analytical Functions
MATCH_RECOGNIZE
- A/B Analysis on Streaming Data using MATCH_RECOGNIZE
- Applied overview of MATCH_RECOGNIZE clause
- Correlated pattern definitions and Snowflake’s MATCH_RECOGNIZE
- How to Predict Customer Churn Using SQL Pattern Detection - MATCH_RECOGNIZE
- Association Rule Mining using MATCH_RECOGNIZE
- MATCH_RECOGNIZE
- Stock Analysis using MATCH_RECOGNIZE
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite - Part II
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite
- What’s eating up your Snowflake Virtual Warehouse - Part II featuring MATCH_RECOGNIZE
ASOF JOIN
- SQL ASOF join in Snowflake
- ASOF join in Snowflake
- ASOF Join — The “Do What I Mean” of the Database World
- ASOF JOIN
- Perform joins on timeseries data using ASOF JOIN in Snowflake
Skyline Query
- What’s eating up your Snowflake Virtual Warehouse? Using Skyline Query to identify badly written queries.
- Skyline or Pareto Front using SQL
- Skyline Query
- Skyline Query to identify problematic queries in Snowflake
Dynamic PIVOT
- Support for ANY keyword in the Snowflake’s PIVOT IN list
- Split a column value into multiple columns based on delimiter using PIVOT
- UNPIVOT multiple columns in Snowflake
Conditional True Event (conditional_true_event)
- Conditional True Event
- Sessionization, or solving the Gaps-and-Islands Problem using RANGE_SESSIONIZE in Google BigQuery
- Sessionization, or solving the Gaps-and-Islands Problem using conditional_true_event
- Using conditional_true_event to get a subset of data from timeseries data based on an event
Conditional Change Event (conditional_change_event)
Ratio to Report (ratio_to_report)
- RATIO_TO_REPORT with Aggregate Functions
- RATIO_TO_REPORT in Snowflake
- Calculating percentages using RATIO_TO_REPORT