Q&A BY TAG 'Create Base View'
How to Create Base View in Denodo to a NEO4J data-source?
answered
27-09-2021 01:16:38 -0400
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...
Answers:
7
Error in Data source creation in ADLS 2 container
answered
15-07-2021 05:27:29 -0400
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...
Answers:
2
CSV Create Base View Data sources Azure Data Lake Storage Gen2
creating a base view off of a working script in VQL Shell
answered
10-03-2021 10:04:35 -0500
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...
Answers:
1
Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered
24-02-2021 06:15:56 -0500
Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...
Answers:
3
custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View
Error Creating the Base View
answered
27-01-2021 05:51:43 -0500
I tried testing Json data source from SAP using HTTP method 'GET', but it responded below error message when creating base view Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Error retrieving data from 'http://&...
Answers:
1
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
Need help creating a Base View from a SQL Server Stored Procedure
answered
18-08-2020 08:14:29 -0400
I have a SQL Stored Procedure which I will use to create a Base View in Denodo. The issue is that the Stored Procedure takes an User-Defined Table type as input parameter. If I select the SP and click Create from Selected I get an error that says the ...
Answers:
3
Creating A Base View On Snowflake Stored Proc/ Multiple Statements
answered
22-07-2020 18:04:16 -0400
Hi, I was wondering if you could tell me if there was a way to create a base view on snowflake stored procs. What I am trying to do is: Run the stored proc Capture the result of the proc The Snowflake statments are like these: -----CALLING ...
Answers:
1
Restriction User From Creating More View
answered
23-06-2020 06:35:39 -0400
I would like to know is there any possible way to restriction a user (newly created or existing one) when creation views. Example: a user " trainer" who have create, read, write privileges. but need to restriction the user from creating more than 5 view.
Answers:
1
Optional interpolation variables
answered
17-06-2020 08:14:12 -0400
Each time I create a base view over a JSON data source with interpolation variables, denodo asks me to provide all of the variables. But what if the API does not support the combination of all the variables together? E.g. there is external_id and local...
Answers:
3