Q&A

Virtualization of my data warehouse snowflake
answered 23-07-2020 05:35:17 -0400

Hi, I created a unified view of my datasource of snowflake. When i make an update in my table on snowflake, i saw that the change is made also on my view on denodo. And i don't want the update appear in the view on denodo. Is it possible ? Thank you

Answers: 3

snowflake DENODO

access column values in register
answered 23-07-2020 00:25:01 -0400

How to access register nested columns(eg. id) through vql eg. view openstacktoken column:- token : register { id: string, name : string } I want to do Select id from openstacktoken. Presently, when I am querying openstacktoken, I am getting token as ...

Answers: 4

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

snowflake Base view Create Base View Stored Procedure

I'm sorry
answered 22-07-2020 12:46:46 -0400

I'm sorry I have not had time to save my trial account, can I ask to resend the azure trial account

Answers: 1

free-trial azure

Unable to connect denodo using ODBC from power BI
answered 22-07-2020 02:23:59 -0400

Hi I use denodo platform 7.0 in windows. When i connect denodo data view from Power BI i get below error. --datasource.error: odbc: error [hy000] error while executing the query Even when i tried to connect from microsoft excel using the option "fro...

Answers: 2

ODBC

Issues connecting Amazon S3 bucket with Denodo VDP
answered 21-07-2020 18:06:42 -0400

Hi team, I'm trying to connect Denodo and retrieve CSV files from a S3 Bucket. I have followed all the steps provided in this article: https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20Denodo%20Distributed%20Fil...

Answers: 3

AWS S3

Virtual DataPort server won't start
answered 21-07-2020 16:47:38 -0400

I've recently installed Denodo express platform 7.0 on Windows so that I can explore and try it. Now, when I try to start the Virtual DataPort server, it keeps getting stopped. Here you can find the logs from vdp.log ====== INFO 2020-07-16T17:32:01.46...

Answers: 3

Working with JSON hierarchical data
answered 21-07-2020 15:24:12 -0400

Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...

Answers: 3

flatten JSON

Tableau Desktop connection issue for Denodo SSL enabled server
answered 21-07-2020 11:06:25 -0400

We have SSL enabled Denodo server which we can easily connect from VDP Client.To connect to VDP, we needed to put a certificate file in the security folder under lib within Denodo Installation path. But Tableau desktop data source connection cannot be...

Answers: 5
Related to: How to connect to Denodo from Tableau Desktop

Data calalog giving page not found 404 error
answered 21-07-2020 10:48:32 -0400

Hi All, I have started the denodo platform services in below sequence and all services are running except data catalog and unable to open the http://hostname:9090/denodo-data-catalog/ URL, getting page not found 404 error. I can login in VDP admin too...

Answers: 4

Denodo data catalog data catalog Data Catalog Error Denodo Data Catalog. Version 7.0