Q&A

You must sign in to ask a question. If you do not have an account, you can register here

LIMIT not working in a subquery .
answered 25-04-2022 06:21:35 -0400

I'm trying to execute the following query : SELECT * FROM (SELECT * FROM Connections LIMIT 1000) AS T LIMIT 1; But its giving the following error : Exception parsing query near 'LIMIT' . Can someone help ? OR suggest any alternative working way of ...

Answers: 3

JDBC Query limit SQL

Garbage Collector
answered 22-04-2022 09:26:49 -0400

How do I identify logs for Garbage collector? Where is the Garbage collector located? When does it run? What log file has the information on the Start and Stop time?

Answers: 1

Garbage Collector

datamasking
answered 22-04-2022 09:23:03 -0400

we have snowflake db and we have table masked and unmaksed data based on the role. can we use denodo to display the data depending on the snowflake role's

Answers: 1

Data Mask

Excel text field is defined as double in base view
answered 22-04-2022 09:20:44 -0400

I am using Denodo 8.0. I have an Excel spreadsheet data source which contains multiple worksheets. I have created the data source for each worksheet. All of the data columns are defined as General or Text on the Excel spreadsheet. But when I create the...

Answers: 5

Excel

Scheduler Job execution Details
answered 22-04-2022 08:14:51 -0400

SQL server procedures are loading data to a CSV file. Need to implement this solution using Denodo and send the status of the job execution as view output. We are able to export the view output in a CSV file using Denodo scheduler jobs. Is there...

Answers: 1

Metadata Schedule jobs

Denodo SSO SAML with Azure AD failing when connection to VDP
answered 22-04-2022 00:08:03 -0400

I tried setting up Azure SAML SSO in denodo solution manager, I could login to Solution Manager using SSO.From Solution manager, while I tried to connect design studio in preprod /prod environment, It gives me below errors. I tried assigning different ...

Answers: 3

Denodo SSO SAML

Commercial Usage of Denodo
answered 21-04-2022 10:07:43 -0400

Can I use Denodo Express edition in any of my ongoing projects..? What all use cases we need to buy or take up standard edition..? Please elobrate the scope of usage for Denodo Express edition.

Answers: 1

Denodo Express

Denodo Express
answered 21-04-2022 10:02:20 -0400

Hi Team, Do we get model bridge in the express download?

Answers: 2

Denodo Model Bridge Denodo Express

View model parameters in web service call
answered 21-04-2022 08:09:10 -0400

I created a view with a parameter, "param_Value". In the where clause I'm filtering on key table value "in" param_Value. My web service vql looks like the following CREATE OR REPLACE VIEW "iv_ViewName1" FOLDER = '/folders/3 - integrated views' PRIMAR...

Answers: 1

Filter API

How to pass comma delimited value to webservice
answered 21-04-2022 07:47:38 -0400

My view query looks like Select val1, val2, val3 from iv_view where val1 in (input_Val). I am passing input_Val from query string in web service call. If I pass a single value I get a single result but if I pass multple values I don't get any results...

Answers: 1

Filter API