Latest Activity
Good day, I have been trying to combine the Generate VQL Script to Create Base View and Get Source Tables stored procs to automate the creation of my views for all tables in a range of schema's from a DB2 datawarehouse. I was provide a sample from the...
I can't seem to create a base view from a query that uses a temp table. From looking around online/on the forums, this seems like an intentional limitation due to the session-limited lifetime of temporary tables. However, this seems like a bad limita...
Base view baseview created from query Global Temp Table Create Base View Baseview SQL Server INDEX Temp Tables
Hi, I am trying to create JDBC datasource using MYSQL adaptor. The test connection is successful but when Save the source and try to create base views of tables I am unable to see any tables in my database. I have granted all the access to the databas...
Hi there, Is there a method where any changes made on a source table can be automatically 'enforced' on a base view table? The purpose being the ability to always keep base views in line with the LAG version of its source table? Likewise, should the s...
Related to: How to detect changes in data sources
I faced a problem, in Denodo 7, my folders are all empty. I cannot see the views inside, but I can save the views, just I cannot see them. And my colleagues can see them in their Denodo VDP, very strange. does anybody know why? Thanks and regards.
I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...
Related to: Invalid query error using Create base view from query
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...
Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers...
Hi, I am trying to establish a connection to read and write back a csv file ADLS 2.0 container. I am trying in custom wrapper so I configured my core-site.xml with my ADLS account with keys. When I try to test connection the connection is succes...
CSV Create Base View Data sources Azure Data Lake Storage Gen2
I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGH...