Latest Activity

code

Interpolation Variable - Date function

Hi, I am trying to create a base view with query from DB2 in which I included 2 parameters Begin_date, End_date that are added in where clause to filter Date(confirm_date) column. Example: Select * from Table where Date_column between @Begin_date and ...

code

Error while connecting to Azure data lake storage GEN2

Hello Team, I am trying to create Datasource based on Azure data lake storage GEN2. Till i save all the configuration, it goes fine. When I try creating base view, it throws below error: There was an error while creating this base view: Error while e...

code

Renaming of Staging View

Can i Rename the Staging view. if yes do we have to do the impact analysis before renaming i mean do we have to check the dependencies of that Staging View and it can refelect in all places.

code

How to fetch the deploymnet error log in solution manager

Hi Team, We need your help to find the complete error(execution error) log which is occuring during deployments in solution manager. We could not see the entire error as it have serveral lines with the help of tooltip. since the log is huge, Could you...

code

How to name the CSV Output file from Scheduler using a field from the view, without selecting that specific view in the selection query which will load the fields in the CSV File

Hi Team, I have a view in Denodo which I need to expose the data output in CSV file. I have a field created called "filename" in the view, which has a case statement logic: If current_day() is Sunday: then Liberty ||'-' ||adday(current_day,-3) else Li...

code

How to install odbc for mac with m1 running it? Does denodo support macos?

I have tried downloading odbc friver for linux from the drivers provided. Unable to figure out the next steps. Any help would be much appreciated.

code

check Denodo is installed already

Hi Team, How to check whether Denodo is installed already in a linux box using CLI ? Once it is confirmed it is installed or not , then we will identify the process ID of services .Already know to get the PID of denodo services. Thanks in advance , ...

code

Where to pass the body of an API in DENODOTEST file

I want my body to be like that: grant_type, client_id, client_secret Below is a test case I'm trying to run https://drive.google.com/file/d/1peiszrO6cRY4bCYZmCcOINQpSbYU5pJM/view

code

Webcontainer status

For linux start/stop scripts we typically check if a process is already running before starting it, as well as rotate it's logs. How do we do that with these webcontainers like designstudio_startup, datacatalog etc. ? We need a designstudio_status , th...

code

"The parameters of the function 'to_timestamp' cannot be delegated to this database." in MS SQL Server 2017

Hi. In my view, I use the TO_TIMESTAMP function to parse a string to a timestamp. In the VQL, it looks like this: to_timestamp('dMMyy', common.i_bv_erp_kund.creation_date) But now, queries involving this view won't get pushed down to the source becaus...