Materialized Tables

A Materialized table in Virtual DataPort is a special type of base view whose data is stored in the database where the data is cached instead of in an external data source. Unlike the other types of views, its schema and its data are completely managed from Virtual DataPort so its structure does not depend on any external source.

The section Materialized Tables of the VQL Guide explains how to create these tables and insert data into them.


Before creating a materialized table, enable the cache engine. To do this, follow the steps described in the section Configuring the Cache.


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.

Add feedback