Q&A BY TAG 'Base view'

You must sign in to ask a question. If you do not have an account, you can register here

Duplicate views are getting created while creating base views
answered 25-06-2020 03:43:54 -0400

Hi Team - I am creating base views on a delimited data source(CSV). For this I created a base view under this data source object in the server explorer pane of VDP Admin client. I also see another base view (with the same name) also getting created aut...

Answers: 1

Base view

Optional interpolation variables
answered 17-06-2020 08:14:12 -0400

Each time I create a base view over a JSON data source with interpolation variables, denodo asks me to provide all of the variables. But what if the API does not support the combination of all the variables together? E.g. there is external_id and local...

Answers: 3

Base view Interpolation Variables Create Base View

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion Base view datetime Error SQL Server

SQL Server date conversion error in BaseView
answered 15-06-2020 04:02:11 -0400

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Answers: 1

Date Conversion Base view VDP 7.0 SQL Server

create views over xml columns denodo
answered 06-04-2020 13:35:27 -0400

can I create views over xml columns , as I have view contain colum xml record and I have multiple rows .. so I need to create view to list xml records (as columns)

Answers: 1

Base view XML

create base view for xml record from json file
answered 06-04-2020 12:05:31 -0400

Please i want to ask how i can create base view for spcific key at JSON obect file , which means I import json object from json file and this file contain key which it's value xml .. i need to create base view for this xml key

Answers: 1

Base view XML JSON

Base view deployed even though table not present in database
answered 27-03-2020 12:22:06 -0400

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

Answers: 1

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

Querry execution return error
answered 26-03-2020 10:30:07 -0400

Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL...

Answers: 1

Base view Create Base View

Delimited File Error
answered 14-01-2020 07:10:08 -0500

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Answers: 1

Base view Delimited Files

Timestamp Issue
answered 26-12-2019 17:40:21 -0500

Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...

Answers: 1

snowflake Base view DENODO timestamp