How to connect Google Data Studio to Panoply?

To connect Google Data Studio to Panoply:

1. Log in to your Google Data Studio account.
 
2. Once logged in, click Create.
   
 
3. Select Data Source.
   
 
4. Search for the PostgreSQL connector and select it.
 
5. Provide the connection details of your Panoply account. If you don't know what they are, navigate to the BI Connection page of your account in Panoply.
   
   Panoply provides 5439 as the default port value, but use 5432 when using Google Data Studio to connect.
   
 
6. Once you've provided your connection details, complete the setup of the data source by:
   
   • clicking Authenticate to establish a connection to your Panoply data warehouse;
   • selecting a single table from the list; and
   • clicking Connect to complete the process.
     
 
7. You'll be redirected to a page where the fields of your selected table are shown. This confirms that you have successfully connected Google Data Studio to your Panoply data warehouse.