Big Data, ETL, Data Warehouse Intern

Uli Bethke February 27, 2018

Big Data, ETL, Data Warehouse Intern Interested in Big Data, Data Warehouses, ETL, Business Intelligence, Data Analytics? Sonra Intelligence is looking for a computer science intern to join our team based in our office (Dublin 7 Grangegorman DIT campus) or remotely. Duration Starting asap The position is either full time or part time. Working remotely ...

Read More

Successfully Transitioning your Team from Data Warehousing to Big Data

Uli Bethke November 8, 2017

You are planning to complement your traditional data warehouse architecture with big data technologies. Now what? Should you upskill your existing data warehouse team? Or do Big Data technologies require a completely different set of skills? Let me first clarify that I am not advocating to drop your relational data warehouse and replace it with ...

Read More

Comparing Window Function Features by Database Vendors

Jiří Mauritz September 15, 2017

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 or feature. Some also add extra window functions or features beyond standard ANSI SQL. One of the most powerful features is user-defined aggregate functions (UDAF), ...

Read More

Window Function ROWS and RANGE on Redshift and BigQuery

Jiří Mauritz August 22, 2017

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 definitions of a frame. We described the syntax in the first post on Window functions and demonstrated some basic use cases in the post on ...

Read More
1 2 3 4 5 8