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.

Note

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