sqlyt
Market Basket Analysis using SQL
RATIO_TO_REPORT
CONDITIONAL_TRUE_EVENT
MATCH_RECOGNIZE
Stock Analysis using MATCH_RECOGNIZE
Sessionization using CONDITONAL_TRUE_EVENT
A/B analysis on streaming data using MATCH_RECOGNIZE
DECODE
MAX_BY
MIN_BY
Using DECODE in SQL JOIN Predicate
Correlated Pattern Definition and Snowflake’s MATCH_RECOGNIZE
Top sales by amount for each sales associate using MAX_BY() aggregate function
Applied overview of MATCH_RECOGNIZE clause
Data Vault Effectivity Satellite
Using MATCH_RECOGNIZE to analyze data in a Data Vault Effectivity Satellite
NULL-safe comparison in Snowflake SQL
Using MATCH_RECOGNIZE to analyze data in a Data Vault Effectivity Satellite - Part II
RATIO_TO_REPORT with Aggregate Functions
MAX_BY() and MIN_BY() with Window Function
SHOW IMPORTED KEYS
SHOW EXPORTED KEYS
Getting Foreign Keys on Tables in Snowflakes
How to find column names in a FK constraint?
How to get the column names for a foreign key constraint?
List Foreign Keys in Snowflake
Skyline query to identify problematic queries in Snowflake
Maximum Vector Problem as a solution to identifying problematic queries in Snowflake
Skyline Query
Pareto Front
Pareto Set
Pareto Frontier
Color Schemes for Surface Plots
Wrangle data in Snowflake using Python
Data Metric Function in Snowflake
What’s eating up your Snowflake Virtual Warehouse - Part I?
What’s eating up your Snowflake Virtual Warehouse - Part II?
system$ngram_search
Searching for objects across Databases in Snowflake
How to Predict Customer Churn Using SQL Pattern Detection
Snowflake ASOF join
ASOF join Snowflake
ASOF join
Perform joins on timeseries data using ASOF JOIN in Snowflake