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.
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.