In Peliqan, go to Connections, find the Data Warehouse tile and copy/paste your connection details:

Data warehouse details.png

Use these settings in Looker Studio to connect:

Connection type: Postgres (default data warehouse type in Peliqan)
Server: db.eu.peliqan.io (for EU instance)
User name & password: copy / paste from the Data Warehouse Connection tile (see above)
Database name: same as the user name
SSL: enabled

Step by step

In Looker Studio, click on “Create” and choose “Data source”.

Select PostgreSQL from the list:

Screenshot 2024-08-07 at 10.42.43.png

Paste the host name from the Peliqan data warehouse, e.g. db.eu.peliqan.io , the database name, username and password and check the checkbox “Enable SSL”:

Looker Studio connect Postgres DWH.png

Upload the Peliqan Server Certificate (public key) and click on Authenticate.