Q&A

vql shell to return all the views under some folder
answered 10-08-2020 05:09:32 -0400

Do we have vql shell that can return all the object name under one folder, including view, associations or folder? The purpose is to get all the object under one folder by script, such as python script. Thanks.

Answers: 1

vql shell view name

MongoDB Custom Wrapper - Type Conversion (Object, String)
answered 07-08-2020 17:21:05 -0400

Hi everyone, I have some issues with data type conversion while using the MongoDB Custom Wrapper. The following example Data illustrates the issue. /* 1 */ { "_id" : ObjectId("5f22f0c2754d8395a9b0acb9"), "Id" : "00Qi000000Jr44XEAR", "Nam...

Answers: 3

Type Conversion Custom Connector Data Type Conversion Error Handling mongodb

VQL significance
answered 07-08-2020 16:44:30 -0400

Hi Why do we need VQL in Denodo as developer I am writing only SQLs to build views. how does Denodo converts SQL which has two different sources(teradata and Hive table) when connecting two diffrent sources with ANSI SQL how Denodo will push part of t...

Answers: 1

Remote Table Feature available
answered 07-08-2020 16:40:28 -0400

Hi All, Could you please let us know is Remote Table feature available in Denodo 6.0. Thanks in advance.

Answers: 1

Denodo scheduler dependencies
answered 07-08-2020 13:00:08 -0400

Hi, We are facing the below problem in setting the dependencies in denodo scheduler. Sequence of job - 1.filecheck job - say JOB1 2.JOB2 3.JOB3 4.JOB4 5.Backup job - say JOB 5 Scenario 1: JOB 1 - dont have any dependencies and it should execute at trig...

Answers: 3

Connecting to Postgresql on EC2 Instance
answered 07-08-2020 11:59:40 -0400

Hi, I am trying to connect to a database "user" on a PostgresQL I set up on an EC2 instance. I believe I have allowed port 5432 on the inbound rules and I have modified the two config files. But I received this error message. Unable to establish c...

Answers: 2

PostgreSQL EC2 instance AWS

Multivalued variables from a query in %CONTEXT directive
answered 07-08-2020 09:40:37 -0400

Hi, is there a way to retrieve multivalued variables from a query in the %CONTEXT directive ? For example, I want to compare the count between views in Denodo and their datasources in DB2 : %CONTEXT viewnames[] = a, b, c schemavdp = eicorea schemadb2 ...

Answers: 1

Incremental data load in Denodo
answered 07-08-2020 08:39:58 -0400

How does Denodo ensure incremental load to a database while writing data ? Is it possible to create SCD type 2 using Denodo ? SCD : Slowly Changing Dimensions

Answers: 1

#Incremental Data Load

Checking for corrupt metadata
answered 07-08-2020 02:25:03 -0400

We have run into issues recently where one of our VDBs, or the entire dbmetadata database has become corrupt. Is there any type of checks than can be done to alert us when this happens for a faster response time?

Answers: 1

Free Trial: no extension available
answered 06-08-2020 07:10:30 -0400

Hi, I am second day on my free trial. I would like to connect to S3. However, there is nothing under "existing extension" Please advise. Thanks, Ming

Answers: 1

license custom S3 extension