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

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

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

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

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

Advance SQL Analytical Functions | Query Optimization in Snowflake (QOSF)

A/B Analysis on Streaming Data using MATCH_RECOGNIZE | Query Optimization in Snowflake (QOSF)

SQL ASOF join in Snowflake | Query Optimization in Snowflake (QOSF)

ASOF join in Snowflake | Query Optimization in Snowflake (QOSF)

ASOF Join — The “Do What I Mean” of the Database World | Query Optimization in Snowflake (QOSF)

ASOF JOIN | Query Optimization in Snowflake (QOSF)

NULL-safe GREATEST and LEAST now available in Snowflake | Query Optimization in Snowflake (QOSF)

RANGE Framing in Snowflake: Practical Examples | Query Optimization in Snowflake (QOSF)

RANGE Clause in Window Functions: Practical Examples | Query Optimization in Snowflake (QOSF)

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

Applied overview of MATCH_RECOGNIZE clause | Query Optimization in Snowflake (QOSF)

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

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

November 12, 2024 — Dynamic tables: Support for reading from Snowflake-managed Iceberg tables and creating dynamic Apache Iceberg™ tables –— General Availability | Snowflake Documentation

Conditional True Event | Query Optimization in Snowflake (QOSF)

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

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

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

Effectivity Satellite | Query Optimization in Snowflake (QOSF)

Data Metric Function in Snowflake | 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)

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

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

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

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

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

Perform joins on timeseries data using ASOF JOIN 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)

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

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

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

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

Skyline Query | Query Optimization in Snowflake (QOSF)

Skyline Query to identify problematic queries 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)

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)

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)

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)