intermix Blog

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

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

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