For Materialized tables: in Peliqan go to Connections, find the tile named “Sync Data warehouse” and copy & paste all the details from the Target:

For SaaS sources: in Peliqan go to Connections, find the tile of the SaaS connection and copy & paste all the details from the Target:

Use these settings in Grafana to connect:

• Connection type: Postgres (default data warehouse type in Peliqan)
• Host: db.eu.peliqan.io (for EU instance)
• Port: 5432 (for Postgres)
• User name & password: copy / paste from the Target of the Connection tile (see above)
• Database name: same as the user name
• TLS/SSL mode: set to “require”

In Grafana, go to Settings, data sources, and add a new data source of type Postgres.

Here’s an example configuration: