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. SQL queries are “views” on the underlying data.
Materialize is the opposite of ephemeral. You can enable Materialize for an SQL query under the Settings icon of the query above the SQL editor or Grid view. The option is called “Materialize” or “Sync to data warehouse”:
When you activate Materialize, the query will be executed (refreshed) once every hour and the result will be stored in a table in the data warehouse, under the schema “Metarialize”.
You can materialize a query for 2 reasons:
- Speed up complex queries
- Make tables available to BI tools and other applications outside of Peliqan