Hi,
To create a snapshot table in Denodo, I would use the** "[Materialized Table](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/materialized_tables/materialized_tables#materialized-tables)"** option in the Denodo Platform. In Virtual DataPort, a Materialized table is a type of base view whose data is stored in the database where it is cached rather than in an external data source. Please note that before creating any materialized table, it is require to [enable the cache engine](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/configuring_the_cache/configuring_the_cache#configuring-the-cache) in Virtual DataPort Administration Tool.
To create materialized view in the Denodo Platform, I would use any one of the following methods:
* **CREATE MATERIALIZED TABLE** - This statement creates a materialized table without data in it.
* **CREATE MATERIALIZED TABLE ... AS SELECT** - This statement creates a materialized view based on the SELECT statement's schema and inserts the query result into it.
* **SELECT ... INTO** – This statement creates a materialized table, but it does not work if the table name already exists as specified in the query.
For more information about creating and inserting the data into a materialized table, you could refer to the [Creating Materialized Tables](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/materialized_tables/creating_materialized_tables/creating_materialized_tables#creating-materialized-tables) section of the Virtual DataPort VQL Guide.
Hope this helps!!
