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