How to get PostgreSQL data to Looker Studio

In today’s business world, the ability to report PostgreSQL to Looker Studio is useful. Looker Studio offers a great deal of flexibility when tracking a company’s performance, but there are limitations. One limitation is the ability to maintain data sources for databases such as PostgreSQL in Looker Studio.

Although there are some connectors available to connect PostgreSQL to Looker Studio, their design is buggy. To address this issue, we have developed the Two Minute Reports PostgreSQL connector. This allows users to connect and send data from PostgreSQL databases to Looker Studio without having to write queries.

Write PostgreSQL queries and pull data into Looker Studio

In a few minutes, the TMR’s PostgreSQL connector makes it easy to integrate PostgreSQL into Looker Studio. You can easily reduce your time creating reports.

Select PostgreSQL in the TMR Portal

The first thing to do is to go through our portal and select the data source you want to add.

  • Choose Two Minute Reports for Looker Studio (the blue one).

  • Select your team. If you only have one team, you skip this and TMR automatically redirects you to the connectors page.

You will now see the connectors page.

  • In the connectors page, find and select PostgreSQL.

Authorize Your PostgreSQL Database

The next series of steps is to configure PostgreSQL with TMR.

Info

The example below is for PostgreSQL. Two Minute Reports also allows you to connect with other data sources.

Connect Your PostgreSQL Database

In this section, you need to login to your PostgreSQL database for authentication making sure it connects with TMR and Looker Studio.

  • Under Data Sources, click +Add New button.
  • Name your data source.
  • Enter your DB Host Address.
  • Enter your DB Port.
  • Enter your Username and Password.
  • Click the blue Test Connection button.

  • If successful, Two Minute Reports gives a prompt “Signed in! You may close this tab now.

Configuring Your PostgreSQL Database with TMR

Info

Query configuration is a setting in Two Minute Reports. It’s where you need to choose which account to get data from and other configurations from that data source.

  • In the Query Configs section, click + Add New button. Choose the data source you added earlier. Click Next.

The next following steps is where you configure your PostgreSQL settings to TMR so that you can create reports in Looker Studio. You may configure the following parameters depending on your preference as TMR has imported them.

Method 1 is for accessing Tables. This doesn’t require writing SQL queries.

  • Name your query config.
  • Select the Table you want to query from.
  • Enter the Limit and Offset of the query.
  • Click Save.

Method 2 is writing your own Custom Query.

  • Name your query config.
  • Select the Custom Query
  • Enter actual SQL query under Execute.
  • Click Save.

Once everything is finished, click Create Report. The next section is creating reports in Looker Studio.

Create a PostgreSQL Report with TMR in Looker Studio

After connecting PostgreSQL, you can create your own custom dashboard with TMR in Looker Studio. Looker Studio is a powerful data visualization tool that contains many features to help you reduce time creating reports.

  • After clicking Create Report from the previous section, click blue Create Report from scratch button.

  • You are redirected to Looker Studio. In Looker Studio, under Select Query Config, choose the configuration you created earlier (it should be the name you gave it). Under Select your Team, choose the appropriate team as well if the dropdown is showed to you.
  • Click Connect blue button in the upper right side of the page.

  • You can now view the PostgreSQL schema on Looker Studio. Click Create Report in the right side of the page.

Once everything is loaded, you are presented with a blank canvas. You can now create custom reports (adding dates and charts) in Looker Studio with your PostgreSQL data.

If you want to learn about creating your own report, like adding dates and charts, read How to Create a Report in Looker Studio

Was this helpful?