intermix Blog

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

Boost your Workload Scalability with Smarter Amazon Redshift WLM Set Up

7 min READ
June 25th 2018
One of the major propositions of Amazon Redshift is simplicity. It only takes minutes to spin up a cluster. The time-to-first-report, i.e. the time it takes to go from creating a cluster to seeing the results of their first query, can be less than 15 minutes. That’s true even for petabyte-scale workloads.[…]
Lars Kamp Lars Kamp

A Quick Guide to Using Short Query Acceleration (SQA) for Faster Queries on Amazon Redshift

5 min READ
April 24th 2018
In November 2017, AWS introduced Short Query Acceleration (SQA) for Amazon Redshift. The promise of SQA is to speed up execution of short running queries, with better predictability of query execution times. That, of course, sounds amazing. So in this post, we'll cover what SQA is, how you enable it, and wh […]
Lars Kamp Lars Kamp

What Causes "Serializable Isolation Violation Errors" in Amazon Redshift?

5 min READ
April 10th 2018
As an Amazon Redshift administrator, you may have come across an error in your logs that looks like this:ERROR: 1023 DETAIL: Serializable isolation violation on table - 15464033, transactions forming the cycle are: 44753006, 44753010 (pid:22973)This post will work through how to understand the r […]
Stefan Gromoll Stefan Gromoll

Amazon Redshift Spectrum: Diving into the Data Lake!

5 min READ
January 5th 2018
Amazon’s Simple Storage Service S3 has been around since 2006. Enterprises have been pumping their data into this data lake at a furious rate. Within 10 years of its birth, S3 stored over 2 trillion objects, each up to 5 terabytes in size. Enterprises know their data is valuable and worth pres […]
Lars Kamp Lars Kamp

4 Real World Amazon Redshift Use Cases

5 min READ
November 11th 2017
Here at, we spend all day helping our customers optimize their performance on Amazon Redshift, so we get a front-row view of all the ways that Redshift can be used to help businesses manage their data. Redshift is a versatile product that can help businesses aggregate, store, analyze, and sh […]
Lars Kamp Lars Kamp
1 8 9 10 11