Latest Activity

code

Base view deployed even though table not present in database

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

code

Querry execution return error

Hi I just strart testing denodo Sandbox free trial but when executing some querry its return error DataBriks.historical_store_sales Finished with error: Error executing query. Total time 92.279 seconds. HISTORICAL_STORE_SALES [BASE] [ERROR] HISTORICAL...

Base view Create Base View

code

Delimited File Error

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Base view Delimited Files

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

Create BV with variable

Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...

Base view Interpolation Variables variable

code

Denodo Cached Base View Issue: returns 0 records in left join

Nevermind! Figure out the issue.

Base view Query Cache

code

My base views are not appearing when I am searching my data catalog

Once I have syncronized my data with the Data Catalog from the VDP server, how to I get it to appear in search results? I have synched my data from the VDP and it is appearing in the Element Management page. When I search for the views in the catalogue...

Base view synchonization

code

error while creating base view

I have problem while creating a base view. I can open the same url in postman but here in denodo while creatingbase view I have this error Error mssg: Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Unexpected v...

Base view https

code
code

find base view from query

Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.

Base view Query