Materialized Tables¶
A Materialized table is a Virtual DataPort base view that stores data in the cache database instead of an external source. Because Virtual DataPort completely manages both the schema and the data, the table’s structure remains independent of external systems.
This type of view allows you to store data from any source or query without linking it to a specific data source.
Similar to Temporary Tables, materialized tables can be created using standard SQL syntax to support external tools that rely on this functionality.
The section Materialized Tables of the VQL Guide explains how to create these tables and insert data into them.
Materialized tables should be utilized in advanced use cases or to seamlessly support external tools that require materialized SQL table syntax. See Materialization Decision Guide for more information on when to use each materialization option.
Note
Before creating a materialized table, enable the cache engine. To do this, follow the steps described in the section Configuring the Cache.
Note
You can also materialize the result of a query using the Remote Tables feature. It gives you an ETL-like experience and allows you to persist the data in any data source, not just the cache.