Stock Analysis using MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

Searching for objects across Databases in Snowflake | Query Optimization in Snowflake (QOSF)

Split a column value into multiple columns based on delimiter using PIVOT | Query Optimization in Snowflake (QOSF)

Support for ANY keyword in the Snowflake’s PIVOT IN list | Query Optimization in Snowflake (QOSF)

Skyline Query to identify problematic queries in Snowflake | Query Optimization in Snowflake (QOSF)

Skyline Query | Query Optimization in Snowflake (QOSF)

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

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

MATCH_RECOGNIZE and Data Vault Effectivity Satellite - Part II | Query Optimization in Snowflake (QOSF)

MATCH_RECOGNIZE and Data Vault Effectivity Satellite | Query Optimization in Snowflake (QOSF)

Using conditional_true_event to get a subset of data from timeseries data based on an event | Query Optimization in Snowflake (QOSF)

DECODE in SQL JOIN predicate | Query Optimization in Snowflake (QOSF)

Using TRANSFORM function in Snowflake to extract values from a JSON array | Query Optimization in Snowflake (QOSF)

What’s eating up your Snowflake Virtual Warehouse - Part II featuring MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

Data Wrangling in Snowflake using Python Anoymous Procedures | Query Optimization in Snowflake (QOSF)

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

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

Retrieving first instance of change event using conditional_change_event | Query Optimization in Snowflake (QOSF)

Retrieving first instance of change event using conditional_change_event | Query Optimization in Snowflake (QOSF)

RATIO_TO_REPORT in Snowflake | Query Optimization in Snowflake (QOSF)