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

Spark and Hadoop in Risk Line of Business at Bank of America

Do you want to gain knowledge about Big Data? Do you want to dig into the field of Risk Line of Business at Bank of America? Come join us to…
Anvesh Gali August 18, 2017

Query Offload with Redshift Spectrum. Use Cases and Limitations

Update: An earlier version of this article claimed that Spectrum runs Presto under the hood. This is incorrect. Spectrum uses its own query layer.Query offload from relational data warehouses to…
Jiří Mauritz August 17, 2017

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 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

Mapping AWS, Google Cloud, Azure Services to Big Data Warehouse Architecture

The Reference Big Data Warehouse Architecture Below is a representation of the big data warehouse architecture. I won’t go into the details of the features and components. If you want…
Uli Bethke June 28, 2017
spinner