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