Latest Activity

code

Creating materialized tables in Snowflake

Hello. I have an online data source from which I extract data in Denodo. The data source has lots of rows of data corresponding to many months in the past. I want to retrive, every month, the data related to the month just ended and use it to create ...

snowflake Materialized View Materialized Table

code

Description in base views for

Hello, I want to create base views from Snowflake views. They are created well except for the descriptions of the numeric fields without decimals. Indeed, in the VQL I see that the description is correctly retrieved but then when it creates the base vi...

snowflake Base View descrptions Decimal Type

code

Create Base Views only from certain Snowflake databases

Hello, I used the Snowflake JDBC 3.13.1 Driver to connect to Snowflake from Denodo. When creating the data source i filled in values for the database, the chema and the warehouse in the Database URI (this is the pattern for the URI : jdbc:snowflake://...

base view snowflake database restriction

code

How to import snowflake stored procedures in Denodo

We can't able to import snowflake stored procedures into Denodo , can you please let us know if any work around .

snowflake

code

Collate functionality with Like operator

As denodo does not have collate functionality, i have written a custom function that delegates collate to snowflake server and I am trying to use like operator in denodo vdp client with collate as shown below, SELECT * FROM <myview> where colla...

snowflake denodo like operator collate with like

code

Snowflake connection - change warehouse based on e.g. a particular role

Hi, With Snowflake as our backend, we keep track of the compute consumption per departement. Users are assigned a "department role" and each departement role uses a dedicated warehouse. How can I do something similar in Denodo? I want to give users acc...

snowflake

code

Virtualization of my data warehouse snowflake

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

snowflake DENODO

code

Creating A Base View On Snowflake Stored Proc/ Multiple Statements

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 ...

snowflake Base view Create Base View Stored Procedure

code

Timestamp Issue

Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...

snowflake Base view DENODO timestamp

code

DB and SCHEMA - default versus usage

i have the JDBC connection set and the Database URI includes a default DB, SCHEMA and WAREHOUSE. when selecting CREATE BASE VIEW, i see other schemas. If i select a table from a schema or db other then the values provided in the JDBC connection string,...

Related to: How to connect to Snowflake from Denodo

schema snowflake