Start Now Login

intermix Blog

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

4 Simple Steps To Set-up Your WLM in Amazon Redshift For Better Workload Scalability

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 workload […]
Lars Kamp Lars Kamp

A Quick Guide to Using Short Query Acceleration and WLM for Amazon Redshift for Faster Queries

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, an […]
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
Since Amazon Redshift launched in 2013, customer keep asking us  "what are some of the uses cases for Amazon Redshift?". It's 2017, and with the four years since launch, that's a long time in technology. Key things that have changed since then:new Amazon Redshift features: more to do with […]
Lars Kamp Lars Kamp
1 5 6 7 8