- Advance SQL Analytical Functions
- A/B Analysis on Streaming Data using MATCH_RECOGNIZE
- SQL ASOF join in Snowflake
- ASOF join in Snowflake
- ASOF JOIN
- NULL-safe GREATEST and LEAST now available in Snowflake
- User Defined Aggregate Functions (UDAF) in Google Bigquery
- Applied overview of MATCH_RECOGNIZE clause
- Calculating Geometric Mean of values in a column using SQL
- Color Schemes for Surface Plots
- Correlated pattern definitions and Snowflake’s MATCH_RECOGNIZE
- Data Metric Function in Snowflake
- Effectivity Satellite
- How to Predict Customer Churn Using SQL Pattern Detection
- Association Rule Mining using MATCH_RECOGNIZE
- MAX_BY() and MIN_BY() with Window Function
- Null-safe comparison in Snowflake
- Perform joins on timeseries data using ASOF JOIN in Snowflake
- What’s eating up your Snowflake Virtual Warehouse? Using Skyline Query to identify badly written queries.
- Sessionization using RANGE_SESSIONIZE in Google BigQuery
- Getting Foreign Keys on Tables in Snowflake
- Skyline Query
- Skyline Query to identify problematic queries in Snowflake
- Support for ANY keyword in the Snowflake’s PIVOT IN list
- Split a column value into multiple columns based on delimiter using PIVOT
- Stock Analysis using MATCH_RECOGNIZE
- Searching for objects across Databases in Snowflake
- MAX_BY() aggregate function in Snowflake
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite - Part II
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite
- DECODE in SQL JOIN predicate
- What’s eating up your Snowflake Virtual Warehouse - Part II featuring MATCH_RECOGNIZE
- Data Wrangling in Snowflake using Python Anoymous Procedures