SQL

• 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?
• system$ngram_search
• Searching for objects across Databases in Snowflake