intermix Blog

Best practices and lessons learned for cloud ETL and data engineering.

Query Optimization: How to efficiently compare two rows in a SQL query

3 min READ
July 12th 2019
Query optimization that dramatically reduces runtime for queries which use window functions.The Simplified ProblemA common problem we see our customers solving in SQL is how to compare two rows per group in a dataset.  For example, say you have the following data in the product_prices table […]
Stefan Gromoll Stefan Gromoll

What is Amazon Redshift? A Deep Dive Into Pricing and Technology

11 min READ
June 21st 2019
Data is valuable resource powering up analytics, predictive models and decision making. For a company to make data-driven decisions, it first must go through building its data infrastructure. And a data warehouse plays a central role in such an infrastructure.Data warehouses are data storage and pr […]
Lars Kamp Lars Kamp

What is the worst part of data engineering?

4 min READ
June 13th 2019
In data engineering teams the list is long and depends on your personal role. But my general pick is “Poor SQL statements by end data scientists and data analysts”.Probably not an obvious answer, so let me explain.Let’s look at this from a perspective of what three major areas of work are for da […]
Lars Kamp Lars Kamp

Intuit’s Journey to Cloud Analytics

13 min READ
June 11th 2019
How to Use Amazon Redshift For a New Generation of Data ServicesIn 2014 Intuit's then-CTO Tayloe Sainsbury went all in on the cloud and started migrating Intuit’s legacy on-premise IT infrastructure to Amazon AWS. By February 2018, Intuit had sold its largest data center and processed 100% of 2018 […]
Lars Kamp Lars Kamp

The Data Sources & Uses within United Airlines

0 min READ
June 6th 2019
The 5 Type of Data Sources that Every Enterprise Should Think AboutIn broad terms, we see five major categories of data sources:Production data: Data coming from core web and mobile apps and / or the line of business apps, and their underlying production databases that contain user data and pr […]
Lars Kamp Lars Kamp
1 3 4 5 6 7 11