intermix Blog

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

Amazon Redshift Best Practices for Designing Queries

7 min READ
February 16th 2021
As a data warehouse, Amazon Redshift makes analyzing petabytes of data quick, streamlined, and cost-effective no matter how far out your data is spread. With Amazon Redshift, you can enjoy over 10x the performance of other data warehouses thanks to the combination of massively parallel processing (MPP), mac […]
Mark Smallcombe Mark Smallcombe

Best Practices for Amazon Redshift Database Security Management

5 min READ
December 10th 2020
Sometimes people could neglect the security aspect of their IT resources. You might put more emphasis on the implementation and performance since they can have a more visible impact immediately. However, you shouldn’t forget that security is one of the pillars that support the success of any IT project. Tha […]
Mark Smallcombe Mark Smallcombe

SQL commands Best Practices - Amazon Redshift

4 min READ
November 17th 2020
Amazon Redshift is a fully managed, cost-effective petabyte-scale cloud-based data warehouse service - allowing businesses to store and analyze large scale data sets and perform massive database migrations. Redshift was born out of PostgreSQL 8.0.2 and is a column-oriented database management system, enabli […]
Mark Smallcombe Mark Smallcombe

15 Examples of Data Pipelines Built with Amazon Redshift

15 min READ
November 4th 2020
At, we work with companies that build data pipelines. Some start cloud-native on platforms like Amazon Redshift, while others migrate from on-premise or hybrid solutions. What they all have in common is the one question they ask us at the very beginning:"How do other companies build their da […]
Mark Smallcombe Mark Smallcombe

How We Use AWS IAM to Generate Temporary Amazon Redshift Passwords

6 min READ
November 3rd 2020
At, we run a fleet of over ten Amazon Redshift clusters. In this post, I’ll describe how we use AWS IAM authentication for our database users. AWS access is managed by configuring policies and connecting them to IAM identities (users, groups of users, or roles) or AWS resources. A polic […]
Mark Smallcombe Mark Smallcombe