Q&A

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

How to access Delta Table on Azure BlobStore from Denodo
answered 20-05-2021 20:00:47 -0400

Hi, I stored my delta tables on Azure Blob Storage. Now I want to access these tables from Denodo. Alternatively, I tried Simba connector to connect Azure DataBricks tables, and that works fine. But that does not show the Blob Store Tables. Ideally Sim...

Answers: 2

BLOB simba deltalake Azure Data Lake Storage Gen2

User Metadata Access
answered 20-05-2021 17:59:32 -0400

Is it possible for the user to view the metadata for all the base views across all databases/schemas but limited to query only the data they are entitled to those base views?

Answers: 1

Role and User Management

Machine requirements for Denodo Express
answered 20-05-2021 16:33:05 -0400

I will load Denodo 8 Express on a Windows machine but I don't see required resources anywhere: RAM, CPU? Obviously more is better, but just to try it with minimal data, what do I need? Thanks Judith Judith Ullman Business Intelligence Team Lead The N...

Answers: 1

Memory Requirements CPU Requirements Denodo Express 8

Error handling mechanism on Baseview
answered 20-05-2021 14:21:32 -0400

Hi, I created one datasource and on top of it there is a baseview. Suppose the source is unavailable now and base view is throwing error and its not retrieving the data. Now whenever baseview throws error due to any reason. It should trigger an mail ...

Answers: 1

ERROR_HANDLING error handling

Listagg distinct
answered 20-05-2021 13:37:54 -0400

Hi, Denodo 8.0 supports listagg function, but can distinct clause can be used inside the listagg?

Answers: 1

Listagg

Querying a Rest API through post request with application/x-www-form-urlencoded content-type
answered 20-05-2021 08:42:33 -0400

Hello, I need to connect to a REST API whit a POST requests which returns a json file. In this Post request, I need to put in the body, that must be an application/x-www-form-urlencoded content-type, two parameters. So I created a Json data source c...

Answers: 3

Denodo to Azure Data Lake Gen2
answered 20-05-2021 08:10:40 -0400

Hi team, I am trying to connect Denodo 7.0 to connect with Azure Data Lake through Custom wrapper. I am trying to connect using shared key authentication method. So I have saved the key in core-site.xml file. the format is like Shared Key: using the s...

Answers: 3
Related to: How to connect to Azure Data Lake Storage from Denodo Platform

Custom Data Sources

Collate functionality with Like operator
answered 20-05-2021 07:21:40 -0400

As denodo does not have collate functionality, i have written a custom function that delegates collate to snowflake server and I am trying to use like operator in denodo vdp client with collate as shown below, SELECT * FROM <myview> where colla...

Answers: 1

snowflake denodo like operator collate with like

I think that "doubledecimalseparator=2" is an error
answered 20-05-2021 01:50:56 -0400

I think that "doubledecimalseparator=2" is an error, isn't it ? Something like doubledecimalseparator='.' sounds better, no ?

Answers: 1
Related to: Custom internationalization configuration for Denodo Scheduler

Regex Pattern Not Working Consistently
answered 19-05-2021 16:45:45 -0400

Hi, I need your help -- i am so confused at the behavior of regexp. As you can see in the 1st image below, the regexp works in that the numbers are getting comma separated. But when i used the same regex patter on the second image, it just fails. Woul...

Answers: 1