Q&A

Configure fields to ungroup or group dates
answered 15-01-2020 13:57:06 -0500

I want to make an integration of data where I can manage the date, that is to say a type of query for a period of time. Weekly sales, monthly sales, among others. Greetings from Ecuador.

Answers: 2

Using Denodo VDP admin database as source from Talend
answered 15-01-2020 13:33:47 -0500

I got Denodo AWS trial environment and trying to use Denodo as the source from Talend Data Catalog tool to test the metadata harvesting. I tried to use 'jdbc:vdb://ec2-54-175-90-97.compute-1.amazonaws.com:9999/admin' with 'admin/admin' as username/pwd ...

Answers: 1

aws free-trial

Load data from Google Sheets
answered 15-01-2020 10:24:47 -0500

Hello, I'm trying to load data using the Google Drive API from Google Sheets with Denodo. I followed the steps described here: https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Google%20Sheets%20Tool%20-%20User%20Manual an...

Answers: 1

Google Drive API

Fail query if filenames do not exist in path
answered 14-01-2020 12:03:16 -0500

Hi is it possible to fail the query if the required files are not in the path? I tried this, but in the path it is nos possible to set regular expressions (anychar). PATH /path/PATTERNAME_^DateRange("yyyyMMdd",@startdate,@enddate,"yyyyMMdd")(.*) <...

Answers: 1

Collecting Field wise stats without using CSV
answered 14-01-2020 08:45:13 -0500

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?

Answers: 3
Related to: How to update the statistics of a view automatically

Automic scheduler Gather Statistics Generate stats

Populate Denodo view parameters from another table / sub query
answered 14-01-2020 07:30:27 -0500

Hi, I have a view with two data parameters as below SELECT * FROM people_data WHERE effective_date >= in_from_effective_date AND effective_date <= in_to_effective_date USING PARAMETERS ( in_from_effective_date : DATE CURRENT_DATE(), in_to_effec...

Answers: 4

Delimited File Error
answered 14-01-2020 07:10:08 -0500

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Answers: 1

Base view Delimited Files

To add a parameter to a derived view
answered 14-01-2020 02:37:03 -0500

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Answers: 3

Parameter View Parameter entry derived view

Audit List of query execution time is more than 800Sec
answered 13-01-2020 21:19:38 -0500

Hi Team, Could you please share the query or steps to take Audit list of query execution time is more than 800Sec

Answers: 1

Denodo version
answered 13-01-2020 12:55:43 -0500

Hi, How to get Denodo version using VQL script?

Answers: 1