Using Google Looker Studio with PostgreSQL and Kondado

Using Google Looker Studio with PostgreSQL and Kondado

Most Data Analytics stacks comprise three stages: An ETL tool + a Data Warehouse to centralize data + a visualization or BI tool. Here we will show how to use Google Looker Studio as a BI tool, along with PostgreSQL as a Data Warehouse and Kondado as your ETL tool.

1. Registering Your Postgres as a Destination in Kondado: First, you need to login to Kondado and register your database as a destination to receive data from your tools. To register your Postgres as a destination, follow the step-by-step shown in our documentation.

2. Creating Your Data Sources: Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit our wiki and follow the respective step-by-step instructions.

3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps.

4.Entering Looker Studio: Log in to Looker Studio by accessing .

Connecting Looker Studio to PostgreSQL:

  • In the top left corner, click on “Create” and choose the option “Data Source”:
  • In the search bar, look for “PostgreSQL” and select the returned option:
  • Click on “Authorize” to start the connection:
  • Choose a Google account to use Looker Studio with Postgres.
  • In the “BASIC” option, fill in your Postgres database details and click on “Authenticate”. If your database is protected by a firewall, you need to give access to the IPs listed by Google on this page under “Notes”:
  • Select the table you want to connect to Looker Studio (1), give a name to your data source (2), and then click on “Connect” (3):
  • Done! Now your table will be connected to Looker Studio, where you can create reports, visualizations, or SQL queries.