Latest Activity

code

Issues with text data when escape charcters are present

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...

code

Remove _0 from column names when we pull in data

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?*

code

Case When function on a localdate format

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 ...

code

Best way to access an HTTP JSON source from a URL in a parent HTTP JSON source

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...

code

DBeaver data access issue

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...

code

Issues regarding Decimal datatype part 2

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...

code

Python SQLAlchemy and connecting to Denodo

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...

code

SqlAlchemy

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

code

Soure Refresh not working

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...

code

remove all _0 from field names on new base view

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...