Google Data Studio on Redshift

Google Data Studio on Redshift

Panoply documentation is moving! Click here to view the new site!  __________________________________________________________________________________________________________________

To determine whether your data warehouse is built on BigQuery or Redshift, see the BI Connect Page on the Panoply platform.

Panoply on Redshift

To connect Google Data Studio to Redshift:

  1. Log into Google Data Studio.
  2. Click Data Sources.
  3. Create a new data source by clicking the blue + button in the lower right hand corner.
  4. Type PostgreSQL into the search bar, and then select the PostgreSQL connector.
  5. Enter the server and database connection details, which are found on the Connect page in Panoply. Exception: set the Port to 5432.
  6. Click Authenticate.
  7. Select your tables, and then click Connect in the upper right hand corner.
    You have successfully connected Google Data Studio to your Panoply data warehouse.
Getting started is easy! Get all your data in one place in minutes.
Try Panoply Free