RATIO_TO_REPORT in Snowflake | Query Optimization in Snowflake (QOSF)

What’s eating up your Snowflake Virtual Warehouse? Using Skyline Query to identify badly written queries. | Query Optimization in Snowflake (QOSF)

Perform joins on timeseries data using ASOF JOIN in Snowflake | Query Optimization in Snowflake (QOSF)

Null-safe comparison in Snowflake | Query Optimization in Snowflake (QOSF)

MAX_BY Analytical Function in Snowflake | Query Optimization in Snowflake (QOSF)

MAX_BY() and MIN_BY() with Window Function | Query Optimization in Snowflake (QOSF)

Association Rule Mining using MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

How to Predict Customer Churn Using SQL Pattern Detection - MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

Finding a Gap in Timeseries data and / or Gaps-and-Islands using SQL | Query Optimization in Snowflake (QOSF)

DECODE Function in Snowflake | Query Optimization in Snowflake (QOSF)

Find the latest reported values with ease using MAX_BY and MIN_BY aggregations | Query Optimization in Snowflake (QOSF)

Effectivity Satellite | Query Optimization in Snowflake (QOSF)

CREATE OR ALTER TABLE syntax in Snowflake | Query Optimization in Snowflake (QOSF)

Correlated pattern definitions and Snowflake’s MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

Color Schemes for Surface Plots | Query Optimization in Snowflake (QOSF)

Conditional True Event | Query Optimization in Snowflake (QOSF)

Calculating Geometric Mean of values in a column using SQL | Query Optimization in Snowflake (QOSF)

Better than Average: Calculating Geometric Means Using SQL | Query Optimization in Snowflake (QOSF)

User Defined Aggregate Functions (UDAF) in Google Bigquery | Query Optimization in Snowflake (QOSF)

RATIO_TO_REPORT with Aggregate Functions | Query Optimization in Snowflake (QOSF)