Q&A

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

Joining 2 files and runs a long time
answered 10-03-2022 06:21:46 -0500

When I run the below, it runs in 10 seconds. When I uncomment out the join, it runs a long time. The join file only has 1 record on it. Is there a way to get this to run in 10 seconds or so with the join file? Thanks. Neil With V5035_A_GROUP as (selec...

Answers: 1

Field value empty/null
answered 10-03-2022 06:06:18 -0500

how can I put a condition so that it considers a field that in the actual value of its content is empty / null ?

Answers: 1

Repointing a derived view to different source
answered 10-03-2022 04:36:55 -0500

Hi, i am trying to change the pointing of a derived view to another data source without disturbing the whole query,but i am using the join of two views in this dervied view, what can be done if i want to change the pointing of this view to other source...

Answers: 1

metadata views describing view and column attributes
answered 10-03-2022 03:27:04 -0500

I would like greater flexability in formatting the output than the GET_SOURCE_COLUMNS stored proc offers. What are the underlying views that the GET_SOURCE_COLUMNS stored proc references?

Answers: 1

Base Views Creation
answered 09-03-2022 08:00:16 -0500

Hi Denodo Team, Can Base Views can be added automatically once the Database Connection is created. Do we have to create manually or can it be automated?

Answers: 1

How best to implement Federation part of Denodo?
answered 09-03-2022 06:43:19 -0500

We have a Redshift data sources, one around EMEA region and second around US region, then we have two Denodo instances already configured in EMEA region and US region. The project requirement states that final set of data needs to be accessed in NA reg...

Answers: 3

Automate creating Interface view usign views and job
answered 09-03-2022 06:41:11 -0500

Hi Team, Is there a way to automate the solution to create interface/derived views from base view? Thanks!

Answers: 1

What about connections in Alteryx Gallery?
answered 09-03-2022 02:56:17 -0500

This seems to work fine in the Alteryx Designer, however, when the workflow is published to the Alteryx Gallery (Alteryx Server), it throws an authentication error: Insufficient privileges. Has this been tested with organizations who utilize the Atlery...

Answers: 1
Related to: How to connect to Denodo from Alteryx

How to connect to MariaDB database?
answered 09-03-2022 01:25:42 -0500

Hi, I want to know how to connect to MariaDB database from Denodo? I noticed that there is a mariadb jdbc client driver available in the following folder: denodo-platform-8.0/lib/extensions/jdbc-drivers/mariadb-2.7/mariadb-java-client-2.7.1.jar When ...

Answers: 1

Incremental cache load
answered 08-03-2022 08:09:58 -0500

Is there any way to implement incremental cache load at derived view level?

Answers: 1