Data warehouse - materialize tables

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
Host name
• European region: • APAC region: • US region:
See Admin > My connections > Sync data warehouse
See Admin > My connections > Sync data warehouse
Database name
Same as user name

More info:

Connect your BI or DB tool

Use your own data warehouse

You can also connect your existing data warehouse to Peliqan and use this as a target to materialize tables, instead of using the built-in data warehouse. Contact Peliqan support to setup your own data warehouse.

Supported data warehouses:

  • Snowflake
  • PostgreSQL
  • MS SQL Server (e.g. on Azure)
  • Google Bigquery
  • AWS Redshift (on request)

IP whitelisting

You can restrict access to your data warehouse by whitelisting following IP addresses from Peliqan:

IP addresses from Peliqan to whitelist
Europe and
Contact support
Contact support
Private instance
Contact support