Latest Activity


Materialized Tables vs Temporary Tables

Is there a way to limit users so they can be able to create Temporary tables and NOT be able to create Materialized tables in Denodo? I could only find this in the Temporary table documentation: Privileges Required The user creating the temporary t...

materialized table Temp Tables


Creating materialized tables in Snowflake

Hello. I have an online data source from which I extract data in Denodo. The data source has lots of rows of data corresponding to many months in the past. I want to retrive, every month, the data related to the month just ended and use it to create ...

snowflake Materialized View Materialized Table


Data getting removed from Materialized Table

Version 7.0.20190903 Oracle 12c as Cache DB. Hi We are using Materialized Table to store some project specific configurations. We are observing erratic behaviour- Materialized Table is getting truncated after 15-20 days. We understand that Cache Clea...

Materialized Table


Materialized Tables

Hi Team, Please provide differences between Materialized vs Temporary tables Their use cases Documentation links Thanks.

materialized table


Meterialized View Update

Is it possible to update a materialised table by joining it other base view?

materialized table update


Run a query in a JOB to create a table

I read data from different datasources (EXCEL), and I do a complex process to get a final result. In the middle of this process I created a materialized table, to improve the performance of the process. I have a job in the scheduler, that get data fro...

Job scheduler materialized table