You can connect with BeeKeeper Studio 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 BeeKeeper 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
- Enable SSL: set to “On”
Make sure to toggle on “Enable SSL”.
