Latest Activity
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...
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 ...
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...
Hi Team, Please provide differences between Materialized vs Temporary tables Their use cases Documentation links Thanks.
Is it possible to update a materialised table by joining it other base view?
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...