Translytical Databases
Unified databases that can handle both transactional and analytical workloads in real time
Friday, November 22, 2024
Tuesday, May 31, 2022
Wednesday, November 22, 2017
Tuesday, February 1, 2011
Thursday, November 22, 2007
Advance SQL Analytical Functions
MATCH_RECOGNIZE
- A/B Analysis on Streaming Data using MATCH_RECOGNIZE
- Applied overview of MATCH_RECOGNIZE clause
- Correlated pattern definitions and Snowflake’s MATCH_RECOGNIZE
- How to Predict Customer Churn Using SQL Pattern Detection - MATCH_RECOGNIZE
- Association Rule Mining using MATCH_RECOGNIZE
- MATCH_RECOGNIZE
- Stock Analysis using MATCH_RECOGNIZE
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite - Part II
- MATCH_RECOGNIZE and Data Vault Effectivity Satellite
- What’s eating up your Snowflake Virtual Warehouse - Part II featuring MATCH_RECOGNIZE
ASOF JOIN
- SQL ASOF join in Snowflake
- ASOF join in Snowflake
- ASOF Join — The “Do What I Mean” of the Database World
- ASOF JOIN
- Perform joins on timeseries data using ASOF JOIN in Snowflake
Skyline Query
- What’s eating up your Snowflake Virtual Warehouse? Using Skyline Query to identify badly written queries.
- Skyline or Pareto Front using SQL
- Skyline Query
- Skyline Query to identify problematic queries in Snowflake
Dynamic PIVOT
- Support for ANY keyword in the Snowflake’s PIVOT IN list
- Split a column value into multiple columns based on delimiter using PIVOT
- UNPIVOT multiple columns in Snowflake
Conditional True Event (conditional_true_event)
- Conditional True Event
- Sessionization, or solving the Gaps-and-Islands Problem using RANGE_SESSIONIZE in Google BigQuery
- Sessionization, or solving the Gaps-and-Islands Problem using conditional_true_event
- Using conditional_true_event to get a subset of data from timeseries data based on an event
Ratio to Report (ratio_to_report)
- RATIO_TO_REPORT with Aggregate Functions
- RATIO_TO_REPORT in Snowflake
- Calculating percentages using RATIO_TO_REPORT