While there are different ways to visualize your data inside Peliqan, you can also use your existing BI tool (Metabase, Power BI, Tableau, Qlik, Looker etc.) to visualise data after preparing it in Peliqan, or you can use a DB tool (BeeKeeper, DBeaver) to see tables in your Peliqan data warehouse.
You can do so by materializing one or more tables, for example a table that is based on an SQL query that you wrote. Once the table is materialized, you can connect with your BI tool to your Peliqan built-in data warehouse. See this chapter for more information: Materialize tables.
Once the table is materialized, in Peliqan go to Connections, find your Data warehouse (e.g. named “Sync Data warehouse”), select the Target in the toggle and copy & paste all the details:
For SaaS sources, you can connect directly to the SaaS target database in the Peliqan data warehouse. In Peliqan go to Connections, find your Data warehouse (e.g. named “Sync Data warehouse”), select the Target in the toggle and copy & paste all the details:
Use these settings in your BI tool 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 tile under My Connections in Peliqan (see above)
- Database name: same as the user name
- SSL: enabled