Q&A

I am not able to login the same. Please guide.

I have a JSON data source and use an interpolation variable for the URL. I want the URL values to be provided from the output of a different view within Denodo, but am having problems making this work. The error I am receiving in the 2 failure tests b...

Hi Team, I am seeing an issue with inserting escape characters into text datatype using literal insertion. Can someone from team solve or atleast clear if it is a denodo server behaviour. I am creating a table something like below, Table I created usi...

Hi, I heard there is a config we can play around with to get rid of the _0 being added to the column names when we pull in new tables. Could someone tell me where to find this config?*

Hello, I'm trying to do a case when statement with the clause that a local date is = '' here is what I used case when a15 ='' then 'Empty' else 'Full' end as Status But it will alwasy return as 'Full' regardless a15 is blank or has a date. I don't ...

Hi All I am accessing Azure DevOps to get a list of Epic/Stories, etc. assoicated with a Board query. The results of the Board query that I am interested in are nested in a workItems section of the returned JSON as URLs. These URLs have a different sc...

Hi, I am having a data access issue through DBeaver. I can access the data through Denodo Design Studio, but the same data, same table, I get the following error: SQL Error [20100] [HY000]: The user does not have EXECUTE privileges on the view Any id...

Hi Team, I am very frustated with this decimal datatype related issue. Can someone from team solve or atleast clear if it is a denodo server behaviour. I am creating a table something like below, Table I created using the below syntax: create material...

Has anyone had any luck in connecting to Denodo via SQLAlchemy (ORM for Python)? Are there any python drivers that with both SQLAlchemy and Denodo? For example, I am able to run queries against Dendo using Python's Psycopg2 driver. However when I try...

Hello, Thank you for explain that, that's very usefull. Is it possible to use SqlAlchemy instead of those connectors ? If yes can you have a document wich explain that ? Yesterday i tried to do that but it's not work. Thx.

Related to: How to connect to Denodo from Python - a starter for Data Scientists