At intermix.io, 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...

Data drives most companies decisions nowadays. Businesses and Executives are making smarter decisions on the direction they should be moving in based on trends and analytics they get from, you...

Many of our customers have a variety of data sets with different data types coming from different sources. Here at Integrate.io, we replicate your data from Amazon RDS to Amazon...

So how does Redshift work, and what’s been driving its adoption? There are two basic components you need to understand about Amazon Redshift:

We dive into what an MPP Database is, how it works, and the strengths and weaknesses of Massively Parallel Processing.

We break down what these two databases are, why should you be using them, and how to sync your data from Amazon Aurora to Redshift quickly and easily and keep...

First up, we break down how to use the Redshift Create Table command as quickly and succinctly as possible, leaving out all the extra stuff you probably don’t need to...

In order to list or show all of the tables in a Redshift database, you'll need to query the PG_TABLE_DEF systems table. An interesting thing to note is the PG_...

Redshift’s UNLOAD command is a great little tool that complements Redshift’s COPY command, by doing the exact reverse function. While COPY grabs data from an Amazon s3 bucket and puts...