Redshift Window Functions Advanced Use Cases

Jiří Mauritz August 3, 2017

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 now be familiar with the most common functions that can be used in the OVER clause and how to apply them to your data. Today, ...

Read More

Data Exploration with Window Functions on Redshift

Jiří Mauritz July 26, 2017

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 and aim our focus on analytical use cases. The dataset we will work with consists of information about phone calls and internet usage of two ...

Read More

Introduction to Window Functions on Redshift

Jiří Mauritz July 11, 2017

Benefits of Window Functions Window functions on Redshift provide new scope for traditional aggregate functions and make complex aggregations faster to perform and simpler to write. Window functions also allow the SQL developer to look across rows and perform inter-row calculations. The main benefits are: Possibility of summarization over dynamically shifting view (sequence of rows ...

Read More
1 2