intermix Blog

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

Amazon Redshift vs Redshift Spectrum vs Amazon Aurora

5 min READ
October 1st 2019
In this blog post, we are going to cover the difference between Amazon Redshift vs Amazon Redshift Spectrum vs Amazon Athena vs Amazon Aurora (you probably guessed that one…) along with a practical example of when you would use each of these technologies.We'll also give a high-level overview of database […]
Lars Kamp Lars Kamp

Feature Preview: Query Execution Graph

1 min READ
September 26th 2019
Earlier this year we launched an update showing query recommendations on how to improve SQL queries to enhance performance. In most cases, improving query performance requires re-writing the SQL and re-submitting the query. We got a lot of great feedback from teams that used the recommendations to […]
Paul Lappas Paul Lappas

3 Steps to Set up Automatic WLM with Query Priority in Amazon Redshift

4 min READ
September 25th 2019
IntroductionWith the release of Query Priorities and Automatic WLM, the AWS team has given Amazon Redshift administrators a powerful new way to define and prioritize data workloads. Without using Workload Management (WLM), each query gets equal priority. The result is that some workloads may end up usin […]
Stefan Gromoll Stefan Gromoll

Customer Success Story: Fuze improves query performance by 10x

5 min READ
September 23rd 2019
Fuze is a cloud-based communications and collaboration platform provider. Fuze drives workplace transformation for its customers with data from 2.5 million meetings, 20 million calls, and 33 million messages each year.At Fuze, data drives product, finance, sales and support. Our users are blocked if que […]
Lars Kamp Lars Kamp

Is AutoWLM the best choice for your Amazon Redshift cluster?

9 min READ
August 21st 2019
What is Workload Management (WLM)?BackgroundUpdate 09/10/2019: AWS released Priority Queuing this week as part of their Redshift Auto WLM feature. We’re in the process of testing this new feature and will update this post with our results soon.Today’s post is a bit long, but for good reason: the Am […]
Stefan Gromoll Stefan Gromoll
1 2 3 4 5 6 11