You can connect with DBeaver to your Peliqan data warehouse, e.g. to view materialized tables.
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 DBeaver 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
- SSL mode: set to “require”
Make sure to set SSL Mode to “require”: