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
“Create as view” for SQL Queries
In order to see SQL queries written in Peliqan inside your BI tool, you need to set the option “Create as view”. Once this is done, you can consume those queries it in your BI tool.
In the SQL editor, click on the Settings icon in the top right corner (gear icon) and enable “Create as view”:
