Q&A

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

Error connecting to SQL Server
answered 13-01-2020 09:40:32 -0500

I cannot connect Denodo with an SQL Server data source. I have used ODBC and JDBC, if someone can send me the step by step I would appreciate it. Greetings from Ecuador.

Answers: 2

Join views: Can Denodo fetch JOIN branches sequentially rather than in parallel?
answered 13-01-2020 08:37:25 -0500

Hi team, I'm working on an Oracle datasource. There is an Oracle procedure that accepts a test parameter and dynamically creates a view based on this parameter. Depending on the parameter, view columns are different but view name stay the same. I kn...

Answers: 2

Load data from Denodo View to Google Cloud Storage
answered 13-01-2020 04:58:28 -0500

Hi. We have views created in Denodo that we would like to load into Google Cloud Storage (which will eventually be moved to BigQuery to create a subject layer). Has anyone been able to complete this? We are currently in the very early stages of testing...

Answers: 3

google analytics google cloud storage googlecloud