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: db.eu.peliqan.io
• APAC region: db.in.peliqan.io
• US region: 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:
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:
Region | IP addresses from Peliqan to whitelist |
Europe | 3.74.207.151 and
52.28.10.115 |
APAC | Contact support |
USA | Contact support |
Private instance | Contact support |