Q&A BY TAG 'Dynamic'

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

Executing Stored VQL via Scheduler
answered 18-01-2022 22:23:02 -0500

Hello, We want to develop a query builder for our business users where they can create queries interactively on denodo base views as per their requirements. They can also choose a frequency (e.g. Hourly, daily) for which query should execute automatica...

Answers: 2

Dynamic Sche

dynamically create derived views based on list of multiple base views
answered 15-11-2021 16:50:51 -0500

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

Answers: 1

VQL Dynamic Derived views Loops

Dynamic column names generated from a pivot
answered 08-10-2021 06:19:33 -0400

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

Answers: 8

Dynamic Pivot

Dynamic Query in JSON
answered 02-09-2021 07:11:26 -0400

Hi team, How to create a dynamic query for the specific field or multiple fields? Because, I think Dynamic query helps to filter the data in runtime and gets to filter the huge data and provide the result much faster than the usual one. So I need to ...

Answers: 1

Dynamic JSON JSON Data Source Dynamic Datasources JSON Datasource

Dynamic Path for Custom S3 Wrapper
answered 31-08-2021 09:05:29 -0400

I have a backup file that is time stamped like this each day: GDW_08-30-2021.csv The current path to reference this file in the custom wrapper via AWS S3... looks like this: /gdw_backup/GDW_08-30-2021.csv is there a way to embed a caclulated value ...

Answers: 2

Formula Dynamic CSV AWS S3 Distributed File System Custom Wrapper

Dynamic Base View based on another Base view (not JOIN)
answered 04-01-2021 12:18:07 -0500

Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...

Answers: 5

Dynamic Interpolation Variables Create Base View join

Denodo Inserts with dynamic values
answered 20-02-2020 07:25:32 -0500

Is it possible to insert records in denodo base views with the below query insert into base_view1 (col1,col2) select col1,col2 from base_view2; With the current doc I concur we can only insert hard coded values like below insert into base_view1 (col...

Answers: 1

Dynamic Insert Operation

Executing Dynamic VQL generated from view output
answered 20-11-2019 18:54:48 -0500

Hi, We have a list of report views that are cached for which we need to generate the report which shows the count or records for all those views. There is a view we have which could give the names of these views that we have to get the counts on. Is ...

Answers: 1

Dynamic

Using an interpolate variable in FROM clause
answered 05-04-2017 08:23:19 -0400

Hi team, I am trying to create a base view from a query based on an interpolate variable within the FROM clause. (SELECT * FROM {schema}.@TABLENAME). I want to do this because the platform I am trying to reach (OutSystems) uses a database with 2 layer...

Answers: 1

Dynamic Interpolation Variables joining of interpolation variables OutSystems