Panoply on BigQuery
To connect Google Data Studio to BigQuery:
- Log into Google Data Studio.
- Click Data Sources.
- Select theΒ BigQuery connector.
- Click on Authorize to Connect.
- 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:
- Log into Google Data Studio.
- Click Data Sources.
- Create a new data source by clicking the blue + button in the lower right hand corner.
- Type
PostgreSQL
into the search bar, and then select the PostgreSQL connector. - Enter the server and database connection details, which are found on the Connect page in Panoply. Exception: set the Port to 5432.
- Click Authenticate.
- 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.