intermix Blog

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

Redshift's Automatic WLM with Query Priority: A First Look at Performance

5 min READ
October 11th 2019
IntroductionThe AWS team recently released a new feature of their Automatic WLM that we're really excited about: Query Priorities. This feature aims to address the main limitation of Auto WLM head-on, i.e. it allows you to prioritize some queries over other queries. This is a crucial performance enhance […]
Stefan Gromoll Stefan Gromoll

How Mode and intermix.io Deliver Fast Queries on Amazon Redshift

3 min READ
October 8th 2019
The New Data StackIn the past few years, we’ve seen a rapid shift to a “new” or “modern” analytics stack, built around cloud warehouses like Amazon Redshift, BigQuery and Snowflake. This stack has three layers:A data integration layer that ingests raw data from the source into a staging area in the […]
Lars Kamp Lars Kamp

How to Optimize Data Pipelines Using Talend and intermix.io on Amazon Redshift

5 min READ
October 1st 2019
Cloud Data Warehouse TrendsIn the past few years, we’ve seen rapid adoption of a new data analytics stack, based on cloud warehouses like Amazon Redshift, Google BigQuery and Snowflake. This stack has three layers:Data Integration. Ingests raw data from the source into a staging area in the warehous […]
Paul Lappas Paul Lappas

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
1 2 3 4 10