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

VQL for updating the Base View
answered 24-09-2020 06:38:12 -0400

Hi, I know we can detect the changes in the underlying data source using GET_SOURCE_CHANGES and GET_VIEWS stored procedures. However, once we detect the changes, is there any way to refresh the base view (VQL commands?) once we detect the changes?

Answers: 3

Base view

Need help creating a Base View from a SQL Server Stored Procedure
answered 18-08-2020 08:14:29 -0400

I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...

Answers: 3

Base view Create Base View Stored Procedure SQL Server

Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered 22-07-2020 18:04:16 -0400

Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...

Answers: 1

snowflake Base view Create Base View Stored Procedure

Duplicate views are getting created while creating base views
answered 07-07-2020 14:18:41 -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: 2

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