Q&A

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

Can we build/deletion DV objects in VDP through access the RestFul API?
answered 24-09-2020 06:34:23 -0400

Hi team, Do we have ways to created DV base views, derived views, delete existing views in VDP side through access REST API?

Answers: 3

VDP build views RestFul API

Not able to login to Denodo Admin Portal with VPN enable, although I am able to login to Denodo Admin Portal without VPN enabled. (This question is in continuation of my previous same question)
answered 24-09-2020 04:35:24 -0400

I am providing my log file below(I have tried with admin as well but no benifit) 1748 [main] INFO 2020-09-21T12:38:33.639 server.start [] - Starting Denodo Platform 7.0 - Operating system: Windows 10 (amd64) - Java(TM) SE Runtime Environment (build 1.8...

Answers: 1

Function to select from an array
answered 23-09-2020 14:29:20 -0400

Hello, I have an array with the following structure: {"description":null,"sourcesystem":"Midas"} and then another array with this structure: {"productmaintype":{"productmaintype":"Currency Investment Account"},"productsubtype":{"productsubtype":"Resid...

Answers: 1

Maximum number of fields
answered 23-09-2020 13:03:38 -0400

Hello what is the maximum number of fields that allows a view in denodo?

Answers: 4

Error Handling with Custom Functions
answered 23-09-2020 08:46:44 -0400

Is there a mechanism by which a custom function can report an error? It appears that exceptions thrown are swallowed and it is treated as though the function returns null.

Answers: 6

Function ERROR_HANDLING Custom Functions Error Handling

Can I feed Rest API parameters from a database query?
answered 23-09-2020 08:01:21 -0400

I have a list of ID values in a database table that I want to feed in as parameters to a Rest API call. I need to make one API call per ID value in the database table. I need to make the union of these Rest API calls into a single table. Can this be ...

Answers: 1

REST API

Flattening json content blob to separate columns
answered 22-09-2020 23:42:18 -0400

Hi, I am working with certain base views containing json data blobs as a column with the field type as text and not something like arrays.I am looking to flatten the view and get all the keys/values in separate columns. The content json blob column is ...

Answers: 1

json

Disadvantage of using multiple CTEs in Denodo
answered 22-09-2020 17:48:01 -0400

We are using many level of CTEs in our architeture.Also joining them with other integrated views.Please let me know what are the disadvantages of using CTEs in Denodo considering performance side.

Answers: 1

CTE

Error modifying view: View names not available
answered 22-09-2020 08:29:57 -0400

Hi , I am creating simple derived view from 2 base views , while enabling cache on the derived view i'm getting "Error modifying view: View names not available" error . Thanks for your help in advance....!

Answers: 1

Cache Error