Latest Activity


Base view from query using temp tables (SQL server)

I can't seem to create a base view from a query that uses a temp table. From looking around online/on the forums, this seems like an intentional limitation due to the session-limited lifetime of temporary tables. However, this seems like a bad limita...

Base view baseview created from query Global Temp Table Create Base View Baseview SQL Server INDEX Temp Tables


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


Date Temporary Table

Hello All, I am trying to create a temporary table with two years worth of dates. Is this possible in VQL? I looked through the documentation and it doesn't look like we can call any looping functions. Similar procedure in MS SQL: https://stackoverf...

Function Temp Tables


Denodo & SQL Question - Temporary Tables & Updates

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reas...

Query SQL Temp Tables