Latest Activity

code

Base view struct data type

Hello, I'm trying from Denodo to create a base view using introspection tool from Amazon Athena schema. The tool identifies correctly the data types for all the fields, but when I create the base view, the columns of type STRUCT are converted to text. ...

code

Azure blog storage - excel file

Hi Team, Can denodo 8.0 read excel file thats stored on Azure blob storage? Or is has to be delimited file? and other standard files mentioned over KB? Thanks!

code

Denodo to SAS/SHARE through JDBC : remove quotation marks in queries

Hello, We are trying to connect to a SAS/SHARE server from Denodo, using the SAS JDBC driver. Our table in our SAS server has a field called value and when we query that table through Denodo, the SQL generated by Denodo wraps the field name in double q...

code

Cache maintenance task vs Cache

Hi Team, I am working on denodo 8.0. I was going to the training on Cache module and its recommended there not to use the cache maintanence task under server configuration as it is more expensive. Rather use the Clean_cache_database procedure. What i...

code

Compounding a derived view

Hello, I am working on duplicating the behavior of an API, it works pretty good, all the fields are mapped etc. However, the in-place API expose the data after structuring it : { "cat1": { "a":"toto", "b":"titi" }, "cat2" :{ "c":"tata" } } while the d...

code

Denodo support for something like SQL EXECUTE AS function?

Hello, Does Denodo support some kind of impersonation feature like EXECUTE AS in SQL Server? This would allow a functional user to execute a query on behalf of another user. If Denodo doesn't support it through this kind of statement, does Denodo su...

code

Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks

I have a problem where my requirement is to Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks . The problem is to set up everything inside docker image so that any developer is able to use denodo...

code

Invalid object name 'fn_listextendedproperty' when introspecting tables in SQLServer2000 via JDBC

We are trying to create base views on tables in a SQLServer2000 dataase using Microsoft SQL Server 2000 (JTDS) datbase adapter. However in the "Create base view" tab if we select a table we get an error: Invalid object name 'fnlistextendedproperty' . T...

code

Datediff/timestamp diff

Hi, I have the below SQL server query, how would I interpret this in Denodo? I want to get time difference in days, hours, month, seconds. I am aware of "cast" function which equals "convert", "GETDATE()" which equals "CURRENTDATE()", "Varchar" will ...

code

Access Dynamic file name from API

Hi, I have a scenario where in I need to pull the data from the public API HTTP link and the file name keep on changing. But the structure/format/columns remains the same. How can I handle this scenario within denodo so that view still connect to the l...