Latest Activity

code

Fetching View's underlying query

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Base view Stored Procedures query logs Denodo view

code

VQL for updating the Base View

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?

Base view

code

Need help creating a Base View from a SQL Server Stored Procedure

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

Base view Create Base View Stored Procedure SQL Server

code

Creating A Base View On Snowflake Stored Proc/ Multiple Statements

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

snowflake Base view Create Base View Stored Procedure

code

Duplicate views are getting created while creating base views

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

Base view

code

Optional interpolation variables

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

Base view Interpolation Variables Create Base View

code

SQL Server date datatypes error in conversion for base views

¬°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...

Date Conversion datetime Base view Error SQL Server

code

SQL Server date conversion error in BaseView

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

Date Conversion Base view VDP 7.0 SQL Server

code

create views over xml columns denodo

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)

Base view XML

code

create base view for xml record from json file

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

Base view XML JSON