Query Optimization in Snowflake (QOSF)
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
)
Retrieving first instance of change event using 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
JSON
Using TRANSFORM function in Snowflake to extract values from a JSON array