Q&A

Building derived views that originally have subqueries in them
answered 16-02-2021 10:07:04 -0500

I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...

Answers: 2

Denodo 8.0 Subquery Derived views

Row restriction preventing user from utilizing view in a derived view in their own Denodo database.
answered 16-02-2021 07:59:18 -0500

We are running V7.0.20201003. Thanks for any insight that can be provided on the following security scenario we are struggling with. A view (v1) is created in database d1. Column access is granted to col1, col2 on v1 to a user’s AD group. Row access g...

Answers: 3

security

How to define CASE statement in view parameters
answered 16-02-2021 07:52:05 -0500

Hi, I need to use a case statement in Denodo view parameters. whenever a defaut date is selected (ex: 1900-01-01) it should fetch data based case condition(ex: current_date-1) else it should fetch data by given date. Ex: case when start_date='1900-01...

Answers: 1

#parameters #Denodo #Denodovaraiables #variables #CASE

Automation testing for Denodo deployments
answered 15-02-2021 06:53:34 -0500

Hi Team, We are looking for some automation tesing for regression testing after migrating from Denodo 7.0 to Denodo 8.0. Also after code deployments from one environment to another. Which tool is the best to suffice the purpose? Thanks, Manju

Answers: 1

#Denodo_Migration #DenodoDeployments #Regression_testing #automation_testing

Excellent tutorial. Need help with filters resolvers
answered 15-02-2021 06:36:52 -0500

Thanks for tutorial. I got great Idea. Can you help me How your Query resolver? You explained filters. But I have JSON data . I need to execute this Query on JSON Data.

Answers: 3
Related to: GraphQL in Action - Advanced Query Capabilities

Help Access Denodo Express GraphQL Denodo Query Exceqution Plan

Create a birmap indexes in a remote table
answered 15-02-2021 06:26:37 -0500

Hi, Is there a way to create a bitmap index in a remote table ? Pierre SANGUINETTI

Answers: 1

remote table Index

Configure Bulk data load API for databricks source in denodo 8.0
answered 15-02-2021 05:49:28 -0500

Would like to know how to configure bulk data load API for Databricks source in denodo 8.0. I have gone through the Bulk data load API docs for Databricks, spark and impala. But I didnt understand how to configure it. Can you please let know the step b...

Answers: 1

bulkload Bulk Data Load databricks Spark

Use of Interpolation variable with multiply function
answered 15-02-2021 04:38:04 -0500

Hi Team, Can you please provide me syntax how to use mult function i have a requriment with interpolation variable like this in teradata: Query1: 1.where "Count" <= (@EmployeeCount 60) i tried like this : 1."Count" <= mult(@EmployeeCount,60) 2....

Answers: 1

mult func

Not able to execute the generate_stats..getting timeout..
answered 15-02-2021 01:59:25 -0500

Hi Team, I am trying to execute the procedure call GENERATE_STATS('view_name'); calling some 18 baseviews... Info: begin batch execution Info: number of jobs: 18 Command #1 ..... OK Command #2 ..... OK Command #3 ..... OK Command #4 ..... OK Command...

Answers: 2

Bring rules of the tables to base views
answered 12-02-2021 03:48:37 -0500

we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...

Answers: 1

Access Denodo Express DENODO