Peliqan allows you to replicate any table from an external database, into the Peliqan data warehouse or any other target that is connected in Peliqan (e.g. Snowflake, SQL Server on Azure or Fabric, Redshift, Bigquery, Postgres etc). The same feature can be used to materialize a query into a physical table.

Replicate a table

Select “Replicate table” from the Settings in the top menu (gear icon):

Replicate table in menu.png

Configure the Replication:

Replicate table settings.png

Materialize a query

Different options for SQL queries in Peliqan

SQL queries that you write in Peliqan are ephemeral, this means that they are executed each time you view the data or use the query. By default queries only exist in Peliqan. You can enable “Create as view” to make the query visible as a view in the data warehouse. Or you can Materialize a query (turn it into a physical table), which is the opposite of ephemeral.

For each SQL query in Peliqan you have 3 options:

  1. SQL Query exists in Peliqan (default)
  2. SQL Query is a view in the data warehouse (and visible by BI tools)
  3. SQL Query is materialized into a physical table

Create a view for your query

SQL queries are “views” on the underlying data. By default they only live inside Peliqan. You can enable “Create as view” on an SQL query in Peliqan. By doing so, the view is created in the data warehouse and it will be visible when you connect to the data warehouse using e.g. a BI tool such as Microsoft Power BI or Metabase.

Enable “Create as view” under Settings (gear icon) in the top menu: