Any table in Peliqan can be materialized, which means a copy is created in the built-in data warehouse, which is refreshed on a regular basis.

Keep in mind that when you view tables in Peliqan, those are actual virtual tables because transformations could be applied to the source data, the table could be an SQL query etc.

You can materializing a table for 2 reasons:

Speed up complex queries
Make tables available to BI tools and other applications outside of Peliqan

Activate materialisation for a table

Go to any table, open it in the grid view and in the top action menu, click on Table Settings. Next switch the toggle “Sync to data warehouse” from Off to On.

From now on this table will be materialized into your Peliqan built-in data warehouse and it will be updated on a schedule. Check the schedule under Admin > My connections > Sync data warehouse.

Connect to your Peliqan data warehouse from a BI tool or DB tool

Go to Admin > My connections > Sync data warehouse.

You can copy/paste the credentials of your data warehouse and use them in e.g. Power BI.

Connection details:

Database (data warehouse) type	Postgres
Host name	• European region: http://db.eu.peliqan.io/
• APAC region: http://db.in.peliqan.io/
• US region: http://db.us.peliqan.io/
Port	5432
Username	See Admin > My connections > Sync data warehouse
Password	See Admin > My connections > Sync data warehouse
Database name	Same as user name

More info:

Connect your BI or DB tool