Latest Activity
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
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 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...
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...