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:
- Your Redshift cluster must be publicly accessible
- 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:
And here’s one of my Redshift cluster setup:
Once you’ve got them connected Redshift functions like any other data source in Data Studio.