Thursday, November 28, 2024 →

Skyline or Pareto Front using SQL | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

Getting Foreign Keys on Tables in Snowflake | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

Sessionization, or solving the Gaps-and-Islands Problem using conditional_true_event | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

Sessionization, or solving the Gaps-and-Islands Problem using RANGE_SESSIONIZE in Google BigQuery | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

Calculating percentages using RATIO_TO_REPORT | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

RATIO_TO_REPORT in Snowflake | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

Effectivity Satellite | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

Data Metric Function in Snowflake | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

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

Thursday, November 28, 2024 →

Identifying expensive queries in Snowflake using credits_attributed_compute metric in query_attribution_history View | Query Optimization in Snowflake (QOSF)

Thursday, November 28, 2024 →

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