Q&A

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

Error editing resource manager rule: field not found 'roles' in view with schema
answered 08-04-2021 07:44:02 -0400

Hi All, When trying to create a rule in resource manager using roles.value condition getting error like below: Error editing resource manager rule: field not found 'roles' in view with schema Same seems to work in dev environment but not in UAT.

Answers: 3

resource Manager

Split Comma separated string to columns
answered 08-04-2021 06:50:06 -0400

Hello I am trying to split a comma separated string to multiple columns . I am not able to find an easy method to do it using the available functions. Essentially I have a field called carmodel in the datawarehouse.It has multiple model separated by a...

Answers: 3

Connecting Denodo to AWS Athena or AWS DynamoDB
answered 08-04-2021 06:34:55 -0400

Hi, Has anyone be able to connect to AWS Athena or AWS DynamoDB? There is already a question about connecting to Athena, but it is from May 2017. I am open to using third party drivers (CData, Simba etc.) if generic drivers will not work. Thanks!

Answers: 3

DynamoDB Athena

pivot dynamically based on values?
answered 08-04-2021 02:21:52 -0400

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Answers: 7
Related to: How to Pivot and Unpivot views

pivot crosstab

getElementDatabase() not working for Denodo 8.0/ Java 11
answered 07-04-2021 09:26:45 -0400

I'm creating a custom policy but getting an error when trying to use the Denodo method getElementDatabase(); The other methods DO work from my library imports (getQuery(), getElementName(), getCurrentUserName()) - but NOT getElementDatabase(). I was g...

Answers: 1

Denodo 8.0

Unable to connect to Denodo Open Sandbox
answered 06-04-2021 04:08:59 -0400

I am unabel to connect to Denodo Open Sandbox. I am using Denodo 8 Express. Your Sandbox URI is: //sandbox.open.denodo.com:9999/vdb_p8yhdf Getting below error. Connection Error : Check the host name and port number are correct, and thet client an...

Answers: 1

Denodo Open Sandbox

Getting "I/O error occurred" when trying to connect to Denodo through ADO.Net
answered 05-04-2021 09:18:46 -0400

I am using the same code provided in the samples/vdp folder. I am able to connect to the Denodo DB through Sqlworkbench from my machine but not from the C# code. Please help. Below is the error stack: at Npgsql.NpgsqlState.<ProcessBackendResponse...

Answers: 1

how to rename a derived view column name
answered 05-04-2021 07:21:02 -0400

ALTER VIEW xyz( ALTER COLUMN abc RENAME column mnn); how can we rename a derived view column name

Answers: 1

derived view column rename

Unable to connect to the database: current license is non-compliant for [jdbc]
answered 05-04-2021 01:38:22 -0400

Hi Team, Configured JDBC datasource using elasticsearch my connecton was scuusessfull but when i want to create baseview from that datasource getting below exception Unable to connect to the database: current license is non-compliant for [jdbc] What...

Answers: 3

#connect