Q&A

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

Hello. The Source Refresh functionality seems to be malfunctioning. I am trying to do a source refresh by following these instructions: https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_cr...

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there a...