You can translate the question and the replies:

Create table as

Can you create a table as a select from a derived view? All the tables are in the derived view are in the same database. The newly created table would be in the same database. I notice you can use scheduler to do an insert into a preexisting table that has a base view over it, but I am curious if the CTAS (create table as) is available in Denodo. Thanks, Clark
06-04-2017 17:07:32 -0400

1 Answer

Hi, I would suggest you to use 'Create View As ...' to create views using another view or table at Virtual DataPort level, as you cannot create a table in data source using VDP Admin tool and “Create Table As (CTAS)” is not supported in Denodo Platform. You can also refer to section "CREATING A BASE VIEW" of the Advanced VQL Guide to know more about the how to create table in Virtual DataPort. Hope this helps!!
Denodo Team
10-04-2017 08:17:23 -0400
You must sign in to add an answer. If you do not have an account, you can register here