You can translate the question and the replies:

Snapshot tables

What all possible options would you recommend to create monthly snapshot tables in Denodo?
28-01-2022 03:43:29 -0500

1 Answer

Hi, To create a snapshot table in Denodo, I would use the** "[Materialized Table]("** 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]( 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]( section of the Virtual DataPort VQL Guide. Hope this helps!!
Denodo Team
30-01-2022 23:57:27 -0500
You must sign in to add an answer. If you do not have an account, you can register here