You can use your favorite BI tool (Metabase, Microsoft Power BI, Tableau, Qlik, Looker etc.) to visualise data after preparing it in Peliqan, and you can use a DB tool (BeeKeeper, DBeaver) to work with tables in your Peliqan data warehouse.
Use these settings in your BI tool to connect to Peliqan:
- 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 Data Warehouse tile under My Connections in Peliqan (see above)
- Database name: same as the user name
- SSL: enabled
Materialize SQL Queries
In order to see the result of SQL queries written in Peliqan inside your BI tool, You need to materializing the query. Once the table is materialized, you can consume it in your BI tool.
Connect your BI tool to Peliqan
Microsoft Power BIGrafanaMetabaseAWS QuickSightConnect your DB Tool to Peliqan
DBeaverBeeKeeper Studio