Q&A

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

I try to create an SP to create all the vdb folder structures, but when I run this: String query = "CONNECT DATABASE" + vdb + ";" + "CREATE OR REPLACE FOLDER '/01 - connectivity';" + "CREATE OR REPLACE FOLDER '/ 01 - connectivity / 01.1 - data sources'...

CREATE OR REPLACE VIEW my_limit_derivedview folder 'myfolder' AS SELECT X,Y, Z FROM my_derived_view WHERE x = 10 limit 1; Cannot save the above as a VQL view definition. The error comes as "Exception parsing query near limit" The same select query "S...

Is there a way that we can pass a denodo JDBC property in as a parameter? PostgreSQL has an "options" parameter which does this as seen on https://jdbc.postgresql.org/documentation/head/connect.html. We are trying to define the ticketCache property fr...

Hi, I am trying to fetch the data from a table on Azure Databricks (ADLS). Tables are delta tables. I am using Simba driver on Denodo and the connection is successful as suggested in denodo documentation. After successful connection. I try to do "Creat...

I have installed Denodo express 8 version on MAC Os with JDK 11 as per the info from https://community.denodo.com/docs/html/browse/latest/en/platform/installation/appendix/supported_java_runtime_environments/supported_java_runtime_environments Post th...

Hi team, We are trying to configure git in solution manager using VCS,can u please suggest where we can find the databses which we created in denedo platform (or denodo design studio),how to enable these databases in solution manager. Thank you.

Hi, does Denodo 8.0 need acces to internet when performing unattendet installation with the Modifying the Denodo Platform Installer to Include the Latest Update?

How to create a base view from query in S3?

Hi, We have scheduled a cache job in scheduler to load the cache. But it is taking too much time to connect to the database. Sometime it takes one and half hour and sometime 2 hours to establish a connection to the database. Once it establishes the con...