intermix Blog

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

How to Fix Disk-based Queries and High Disk Usage in Amazon Redshift

4 min READ
August 13th 2019
Properly managing storage utilization is critical to performance and optimizing the cost of your Amazon Redshift cluster. We've talked before about how important it is to keep an eye on your disk-based queries, and in this post we'll discuss in more detail the ways in which Amazon Redshift uses the disk […]
Stefan Gromoll Stefan Gromoll

Announcing Cluster Recommendations - Measure & Improve Data SLAs

2 min READ
August 5th 2019
One of the things we hear most often from our customers is that data is becoming more and more critical to their business necessitating Data SLAs.Take for example one customer who builds hardware devices for consumers. They use their Amazon Redshift cluster to monitor and provide support for custome […]
Paul Lappas Paul Lappas

11 BI Tools Pricing and Capabilities - Analysis of Legacy & Modern Business Intelligence Tools

13 min READ
July 15th 2019
Introduction to BI ToolsIn recent months, there’s been a wave of acquisitions and fundings in the business intelligence (“BI tools”) and analytics space:AcquisitionsSiSense acquired Periscope Data on 5/14/19 for an undisclosed amount.Qlik acquired Attunity on 2/21/19 for $560MGoogle acquired Loo […]
Igor Bobriakov Igor Bobriakov

How to Amortize Cloud Spend and Reserved Instances with Amazon Redshift - Intuit's Transformational Use Case

5 min READ
July 15th 2019
This is a guest blog post by our visiting expert Dieter Matzion. Dieter is a Business Systems Analyst at Intuit. In the post, Dieter explains how his team has built a KPI dashboard to track cloud spend on top of Amazon Redshift. With the dashboard, over 5,000 Intuit employees gain self-service visibilit […]
Dieter Matzion Dieter Matzion

Query Optimization: How to efficiently compare two rows in a SQL query

3 min READ
July 12th 2019
Query optimization that dramatically reduces runtime for queries which use window functions.The Simplified ProblemA common problem we see our customers solving in SQL is how to compare two rows per group in a dataset.  For example, say you have the following data in the product_prices table […]
Stefan Gromoll Stefan Gromoll