Archive

November 2024

UNPIVOT multiple columns in Snowflake | Query Optimization in Snowflake (QOSF)

UNPIVOT multiple columns in Snowflake | Query Optimization in Snowflake (QOSF)

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

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

MAX_BY() aggregate function in Snowflake | Query Optimization in Snowflake (QOSF)

UNPIVOT multiple columns in Snowflake | Query Optimization in Snowflake (QOSF)

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

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

UNPIVOT multiple columns in Snowflake | Query Optimization in Snowflake (QOSF)

UNPIVOT multiple columns 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)

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)

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