You must sign in to ask a question. If you do not have an account, you can register here

answered 23-07-2020 06:51:38 -0400

I am trying to create base view using 'create from query', select * from table1 where id=@id1 @id1 = 34This works super it creates base view and also BV executes... select from table1 where name=@name1 @name1='veeresh' This creates base view. But whe...

Answers: 3

Specifying a timezone on a 'timestamp without timezone' value
answered 23-07-2020 05:55:32 -0400

I'm curious of the best way to convert a 'timestamp' (without timezone) to a timestamptz (with timezone) value in Denodo when your original timestamp value is in a timezone other than UTC? I am currently using 'CAST([TimestampColumnHere] AS TIMESTAMPTZ...

Answers: 1

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


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


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