Connecting Google Data Studio to Amazon Redshift

It’s now possible to connect Data Studion To Amazon Redshift.

Google and Amazon both have complete suites of analytics tools that seamlessly connect within their own ecosystems, but getting them to work with each other can be a pain.

Amazon’s data warehouse solution – Redshift – is widely used and works brilliantly with Amazon Quicksight, but in my opinion at least Google Data Studio is a better data vis tool, and it’s free.

I already used Redshift to power various reports in Tableau but we needed a way to share a few basic KPIs without having to pay for a load of extra Tableau licences. Data Studio isn’t even close to be as full featured and powerful as Tableau yet but it’s improving constantly.

Amazon changed the Redshift Postgress connector recently, so now it’s possible to connect Data Studio to a Redshift database using the standard Data Studio PostgreSQL connector (Redshift is based on Postgres).

It’s really simple to set up, provided you remember 2 things:

  1. Your Redshift cluster must be publicly accessible
  2. The username and password you enter in to Data Studio need to be for an IAM user with full access to the Redshift cluster

Here’s a screenshot of my Data Studio configuration:

Data Studio setup Redshift

And here’s one of my Redshift cluster setup:

Redshift set up Data Studio

Once you’ve got them connected Redshift functions like any other data source in Data Studio.

One Reply to “Connecting Google Data Studio to Amazon Redshift”

  1. Re: “The username and password you enter in to Data Studio need to be for an IAM user with full access to the Redshift cluster”

    We found this resulted in Access Denied errors.

    Google Studio appears to want to be supplied with the Master Username and Password, since they are the creds to the underlying PostgreSQL instance. Connection then works fine.

Leave a Reply

Your email address will not be published. Required fields are marked *