Recent Articles

Learn Window Functions on Snowflake. Become a cloud data warehouse superhero.

In a recent post we compared Window Function Features by Database Vendors. In this post we will give you an overview on the support for various window function features on…

Dorian Beganovic January 31, 2018

Data Warehouse,

Comparing Window Function Features by Database Vendors

We will round off the series on window functions with comparison of what database vendors offer. There are various mutations of window functions and every vendor supports a different subset…

Jiří Mauritz September 15, 2017

Data Warehouse,

Window Function ROWS and RANGE on Redshift and BigQuery

Frames in window functions allow us to operate on subsets of the partitions by breaking the partition into even smaller sequences of rows. SQL provides syntax to express very flexible…

Jiří Mauritz August 22, 2017

Data Warehouse,

Redshift Window Functions Advanced Use Cases

Merging time-based events into periods Thanks to our previous posts about the window functions, Introduction to Window functions on Redshift and Data exploration with Window functions on Redshift, you should…

Jiří Mauritz August 3, 2017

Data Warehouse,

Data Exploration with Window Functions on Redshift

We have already introduced the main concept, syntax and simple examples of window functions applied to practical problems. In this post, we will go through some more advanced window functions…

Jiří Mauritz July 26, 2017