Latest Activity


Using CTE WITH clause for creating base view from query

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Base view quer cte MSSQL


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


Salesforce object name from denodo base view -Stored procedure

Which stored procedure can be used to get the source object name for salesforce baseviews .I cannot use GET_SOURCE_TABLE as it gives the result only for jdbc connections?

Base view Stored Procedure Salesforce


Create Base Views only from certain Snowflake databases

Hello, I used the Snowflake JDBC 3.13.1 Driver to connect to Snowflake from Denodo. When creating the data source i filled in values for the database, the chema and the warehouse in the Database URI (this is the pattern for the URI : jdbc:snowflake://...

base view snowflake database restriction


remove all _0 from field names on new base view

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there a...

Base view Vql shell Rename


Shared Views

Hello, I have couple of virtual database called "db-A" and "db-B". I have created some baseviews and derived views on "db-A". I am currently on "db-B". I would like to access those derived views which are available on "db-A" and would like to use i...

Base view


Propagating new columns from Base View till Final View

Hi, I have a situation where few new fields were added in the DB from which i created base view (BV1). Now when i click on source refresh, those new fields appear in BV1 but they are not propogating to interface view and any other dervied (selection) ...

Base view


Base view gets created from query, however, cannot execute it.

I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...

Related to: Invalid query error using Create base view from query

Base view baseview created from query Create Base View


Performance of a view based on a MongoDB data source

Hello dear Denodo team, I have a question regarding the performance of a view based on a MongoDB data source. The base view in question has about 2.6 million records and 256 columns. Running the query Select max(date) from ... on Base View level re...

mongo Base view Base View configuration mongodb


JSON file within a ZIP --- can access but the formatting is odd ---

I have created a data source that pulls in a zip file with a JSON file inside it and I am strugging to parse it with a custom tupple pattern. No matter what tuple root I use Denodo fails to display it -- it just blanks out and no error message provided...

Base view JSON Data Source