Google Data Studio

Panoply on BigQuery

To connect Google Data Studio to BigQuery:

1. Log into Google Data Studio.
2. Click Data Sources.
3. Select the BigQuery connector.
   
4. Click on Authorize to Connect.
   
5. Choose from the connection options in the Lower Left panel.Select your Project> Dataset> Table , then Click Connect.
   

You have successfully connected Data Studio to your BigQuery data warehouse.

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.