As of January 28, 2021, changes made by Google have effected the way Panoply interacts with Google Data Studio. Some features are not currently supported due to these changes.
To connect Google Data Studio to Panoply:
- 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
PostgreSQLinto 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.