Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

parameterized query in Data Catalog
answered 09-09-2020 07:45:18 -0400

Can we have parameterized query in data catalog ? Basically when a user logs in and try to access data or export data from a derived view, they will be given option to enter value for few off the fields within the view as a filter ? but not like where...

Answers: 1

#Query #data catalog

How to convert a date and time to another format?
answered 09-09-2020 05:51:13 -0400

Hi! I would like to know how to convert a column with a date format such as dd/MM/YYYY 12:00:00 a.m to a format where only shows "dd/MM/YYYY". I have used the function FORMATDATE('dd/MM/YYYY, datecolumn) and although it gives me the format that I want ...

Answers: 1

Timezone conversion Dates Questionable

vql shell command to VCS commit and VCS push?
answered 08-09-2020 04:42:42 -0400

Hi team, I understand we have VCS vql shell command for pull (DVCSPULL DBELEMENTS database_name), do we have the same for VCS commit and VCS push operation?

Answers: 1

vql shell VCS push VCS commit

Revision Type Description
answered 07-09-2020 09:01:54 -0400

Hi Team, We have fetch the details of of the solution manager for athe database of denodo. In that we have found that the in Revision. The Revision type is give as 1,3 etc. As Revision type are mentioned in the solution manager are like "Create" etc. ...

Answers: 1

SolutionManager

Different execution plans at design studio
answered 07-09-2020 08:31:31 -0400

Hi, please I want to ask how to get multiple (alternative) execution or query plans at design studio at version 8?

Answers: 1

design studio Execution plans Denodo Query Exceqution Plan

Denodo write back in SQL Server table
answered 07-09-2020 04:08:54 -0400

Hi, When i try to insert rows in sqlserver table with vqlshell in a table with field (NOT NULL) :TIMESTAMP i receive a 'Error executing view. Received exception with message 'Cannot insert an explicit value into a timestamp column. Use INSERT with a c...

Answers: 1

Row_Number() against Derived view
answered 04-09-2020 19:55:24 -0400

I have a final view which has been derived from two different data sources MySQL and Postgres. I have cached the derived view. and underlying cache DB is postgres. it supports the row_number function When I execute the 'row_number()' function in the ...

Answers: 1

anaytical_function row_number

Enable 2FA for Denodo
answered 04-09-2020 18:09:03 -0400

Can we enable 2 factor authentication for login to Denodo Data Catalog and VDP Admin tool ? If not both then either of them ?

Answers: 1

#2FA

json_object_agg
answered 04-09-2020 08:21:05 -0400

What is the equivalent for postgres function json_object_agg(name, value) function in Denodo ?

Answers: 1

json_object_agg JSON

Get the host name in VQL
answered 04-09-2020 08:10:06 -0400

Hi, I have a load balanced infrastructure, and would like to get the name of the node which is answering to my query. Something like select hostname() from dual Is it possible directly in VQL?

Answers: 1