Skyline Query to identify problematic queries in Snowflake | Query Optimization in Snowflake (QOSF) Selecting the correct Warehouse size in Snowflake can be tricky. If your queries are spilling over to the Remote Storage then you either need to re-write the query or increase the Warehouse size. But …

Skyline Query | Query Optimization in Snowflake (QOSF) Skyline, also known as Pareto Frontier or Pareto Set in Business Management or Maxima in Computional Geometry, is a useful technique in multi-criteria analysis and decision support. Skyline aims to identify points in n-dimensions that are not …

Skyline or Pareto Front using SQL | Query Optimization in Snowflake (QOSF) Skyline computation is an essential database operation that has many applications in multi-criteria decision making scenarios such as recommender systems. As such, Skyline queries have emerged as an increasingly popular tool …

Skyline or Pareto Front using SQL | Query Optimization in Snowflake (QOSF) Skyline computation is an essential database operation that has many applications in multi-criteria decision making scenarios such as recommender systems. As such, Skyline queries have emerged as an increasingly popular tool …

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

Sessionization, or solving the Gaps-and-Islands Problem using conditional_true_event | Query Optimization in Snowflake (QOSF) Sessionization or conventionally Gaps and Islands in Time-series Analysis are terms referring to the same problem of having to reset all parameters of a predictive or …

Sessionization, or solving the Gaps-and-Islands Problem using RANGE_SESSIONIZE in Google BigQuery | Query Optimization in Snowflake (QOSF) Google recently added a new Table Function called RANGE_SESSIONIZE to Google BigQuery. RANGE_SESSIONIZE allows you to sessionize temporal data. Timestamps from …

Calculating percentages using RATIO_TO_REPORT | Query Optimization in Snowflake (QOSF) RATIO_TO_REPORT SQL analytic function can be used to calculate percentage of the entire dataset or partitioned data. RATIO_TO_REPORT returns a value between 0 and 1 which indicates the weight of a numerical value …

RATIO_TO_REPORT in Snowflake | Query Optimization in Snowflake (QOSF) RATIO_TO_REPORT is a powerful Snowflake Window function that lets you calculate the ratio of a value to the sum of the values in a window. The following query uses the RATIO_TO_REPORT function to calculate the percentage of the …

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)

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

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

Effectivity Satellite | Query Optimization in Snowflake (QOSF)

Effectivity Satellite | Query Optimization in Snowflake (QOSF)

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

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

CREATE OR ALTER TABLE syntax in Snowflake | 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)

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

Color Schemes for Surface Plots | 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)

Applied overview of MATCH_RECOGNIZE clause | 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)

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

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

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

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

ASOF JOIN | Query Optimization in Snowflake (QOSF)

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

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

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

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

A/B Analysis on Streaming Data using MATCH_RECOGNIZE | 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)

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)