Latest Activity

code

How to search for a range of dates based on a text value - Interpolation variable

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

code

Write on a external table from denodo

Hello Team, Would you please Help on this. i wont to write/update data into an external table which is connected via API. and the data is availbale on a table in denodo. for exapleme: Company (Denodo views) >(write/update)> Company (external ...

code

Pivot rows into columns in an array

Hello, what I would like to achieve could be straightforward but I'm very new to Denodo. I have a view like this: model_id equipment 1 Array where the Array is like this: description v...

code

how to create independent categories and tags for each server in denodo data catalog?

I have created tags and categories in server configuration A and created some tags and categories in server configuration B and currently when i login in server A or B i am seeing both tag and categories of A and B combined. Is there any ways by which ...

code

license file is a name denodo.lic, where can I download the new license file: denodo.lic ?

license file is a name denodo.lic, where can I download the new license file: denodo.lic ?

code

Getting refused connection ,not able to connect to scheduler server.

Installed 8.0 express in my local machine. Able to connect to vdp via admin, datacatalog and diagnostic tool. Trying to connect to schedular server via schedular admin. But getting authentication error in the brower and seeing below message in schedula...

code

Data Catalog Sync taking longer time after external db setup

Hi Team, We recently setup an oracle 12c external db on denodo 7 datacatalog. Post the external db setup, Synchronization with VDP server is taking around an 1 hr to complete the the process. Could you please suggest

code

File system URI as an interpolation variable for DFSListfile wrapper?

Hi Team, I am working on denodo 8.0 I can read the file names from Azure blob storage using com.denodo.connect.dfs.wrapper.DFSListFilesWrapper and specifying File system URI value. I want to make this connection a variable so that i can declare it ou...

code

Custom function

Hi Team, I would like yo use the function, Leftpad and rightpad. Could you please help to how i can use in VPD. I tried but ended up with the error 'Finished with error: Function 'leftpad' with arity 2 not found'.

code

Error accessing the metadata while loading/storing objects

I have created a job in the scheduler for loading the oracle transcodification tables and while executing I am getting error as "Error accessing the metadata while loading/storing objects". Please help on this.