• 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
• Sessionization using RANGE_SESSIONIZE in Google Big Query
• User Defined Aggregate Functions (UDAF) in Google BigQuery
• Calculating Geometric Mean of values in a column using SQL
• NULL-safe GREATEST and LEAST now available in Snowflake