Skip to main content
Version: v2

Looker Studio

In this article, you can learn how to get data from Looker Studio to Canner Enterprise.

Set Canner Enterprise as Looker Studio data source

Step 1: Set the data source

Click the' Create' button from the Looker Studio main screen and select the Data Source option.

1_looker

After selecting the Data Source option, enter PostgreSQL in the screen and select it.

2_looker

Step 2: Set connection information

Set the connection information in the following window.

3_looker

  • Host: Fill in the Host or IP address of Canner Enterprise
  • Port: usually 7432; if there is a particular port setting, please pay attention to this field
  • Database: Enter the SQL Name in Workspace
  • User: canner
  • Password: Fill in Personal Access Token to create Personal Access Token Way

When setting relevant field information, you can click the Share button on the top right of the workspace you want to connect to Looker Studio in Canner Enterprise and switch to PostgreSQL Wire Protocol to view its connection information.

pg_connect_info

After filling in the connection information, click the AUTHENTICATE button, and you can see the information under the workspace of Canner Enterprise.

4_looker

Select the data to be connected. At this time, you will find that the CONNECT button on the upper right changes to a clickable state, and you can click to connect.

5_looker

Step 3: Connection completed

When the connection is completed, Looker Studio will jump to this data table screen, where you can perform various subsequent applications.

6_looker

Usage Restrictions

Usage Restrictions

The median calculation is not supported