Start Now Login

intermix Blog

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

Modern ETL Tools for Amazon Redshift

6 min READ
November 13th 2019
Amazon Redshift was introduced in 2012 as the first Cloud Data Warehouse. It quickly became the fastest-growing service among Amazon Web Services. Amazon Redshift and these ETL tools forever changed the methods of working with analytical data. The focus shifted from the classical ETL approach to ELT. Let's […]
Igor Bobriakov Igor Bobriakov

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