Latest Activity

code

Find Field References

Hi , is there a way to find if base view column is being used in any other view?i want to find list of views that are using a column from base view. i know COLUMN_DEPENDENCIES() gives track back report of the field but i need something that can give me...

columns views

code

Invalid Views list.

Hi team , I am using Denodo 8.0 Verssion. Please let me know how do I bring list of All Invalid Views and associations ( including Base , Integration , Derived , staging , Business views ) in tabular format. I tried to execute desc database <databa...

Views

code

info about view settings in metadata

Hi, I found this: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures to get information about a lot of metadata. As denodo has a lot of parameters and settings for eac...

metadata Base view Views

code

deleted view is still found in catalog search, causes errors in metadata scripts

Hi, a view was first created, and deleted some hours later. On recreating this view with the same name, this error pops up: Error storing view 'VIEWNAME': Error accessing the metadata while loading/storing objects checking Catalog Search, we fi...

Views Metadata Catalog

code

Denodo - Base view vs derived view

I would like to better understand the difference between the base view and the derived view. I have a general idea, but can you articulate it so I can better understand the difference. Thank you...

Views

code

Query Permissions by Object

Is there a way to query Denodo's catalog to return a list of roles or users who have permissions on an object?

VQL Views Permissions