Q&A

Getting Source Tables and Columns of a Datasource through Query
answered 17-11-2021 01:37:07 -0500

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 5

JDBC query Database JDBC DataSource

how to create a base view using .tsv.gz file from S3 bucket.
answered 17-11-2021 01:22:54 -0500

we are trieng to add base views from s3 bucket. but files are in tsv.gz format. Kindly assist with procedure to access this files. having read access for the same.

Answers: 1

Import file excel into bv
answered 17-11-2021 01:04:54 -0500

Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...

Answers: 2

Import Excel sftp

How to isolate denodo from unexpected source environment updates
answered 16-11-2021 16:39:33 -0500

Hi, Is there any advice on how to isolate denodo from source environment updates that are unwanted/unexpected cascading into denodo base views? We have implemented our views with the branch pruning approach so cascaded changes should be minimised but w...

Answers: 1

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

VQL Query Shows a Long Time Spent in Data Serialization
answered 15-11-2021 11:43:09 -0500

Hello! We are using Denodo 7.0.20200310 and SQL Server 2017. We have a simple SELECT statement joining 2 base views that runs slowly in our test environment (52 seconds) and fast in our QA environment (<1 second). In looking at the trace information...

Answers: 2

How to avoid array data conversion into text format while creating base view?
answered 12-11-2021 07:47:31 -0500

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...

Answers: 1

Base view ARRAY Create Base View

How to sync user queries in denodo data catalog servers?
answered 12-11-2021 00:48:26 -0500

Hi Team, I have a requiredment to automate the process of export and import user queries between 4 production servers through shell script. Is there any export and import commands available only to export the user queries from one server and to import...

Answers: 1

#userqueries #Datacatalog

how to connect denodo
answered 11-11-2021 22:53:19 -0500

i have downloaded ova file for denodo training quickstart virtual machine i import ova file vmware workstation and started vm which is succesfully started but now its required ip address so kindly guide me which i have to enter in it. thanks

Answers: 1

vmware connect

how to monitor denodo by prometheus?
answered 11-11-2021 08:00:35 -0500

We now uniformly use Prometheus as a monitoring tool. How can denodo's information be connected to Prometheus? Currently only this is still pending, please help as soon as possible, thank you

Answers: 5