Q&A BY TAG 'Metadata'

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

Metadata select invalid view/colums
answered 30-11-2018 04:36:51 -0500

Is it possible in denodo 6 tot make a query on metadta to select all invalid view with invalid columns?

Answers: 1


View column order metadata
answered 15-10-2018 05:53:36 -0400

I am using Denodo 7, latest update. I'm using get_view_columns() to extract metadata on columns included in views for various purposes. There doesn't seem to be anything that provides the order of the columns in the views. Is this metadata available a...

Answers: 1

metadata column order get_view_columns

Query Denodo and return Rest Webservices Metadata
answered 10-09-2018 19:15:32 -0400

Is it possible to query Denodo 6.0 for rest webservice metadata (soap and json)? I found GET_CATALOG_METADATA_WS() in Denodo 7.0 manuals, but cannot find anything similar in 6. Thank you, John

Answers: 1

Denodo 6.0 Metadata Rest Webservices

error accessing metadata
answered 07-09-2018 05:15:55 -0400

Hi Team, Denodo 5.5 DB1 - elevation in progress DB2 - query - select * from catalog_elements() DB2 - error - received exception with message 'error accessing the metadata while loading/storing objects' Is this error intended ? Please tell. Thanks.

Answers: 4


Join conditions in metadata tables
answered 29-05-2018 02:33:50 -0400

Is there a metadata table which holds join condition and WHERE clause criteria of join views ? Plese let me know. Regards Nagaraja

Answers: 3

joins in Metadata Metadata

Denodo metadata for Datasource
answered 25-05-2018 14:07:11 -0400

Is there a metadata table available in Denodo which can link a Base view to its datasource's Database,schema and table ?

Answers: 2


info about view settings in metadata
answered 25-05-2018 12:09:45 -0400

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

Answers: 1

metadata Base view Views

Column dependency using metadata procedures.
answered 17-05-2018 12:48:05 -0400

I have an requirement to pass list/multiple ViewName parameter to COLUMNDEPENDENCIES procedure dynamically to get all the dependent views consuming this ColumnName parameter across database. ## Metedata Query: Select column_name, dependency_identifie...

Answers: 3


deleted view is still found in catalog search, causes errors in metadata scripts
answered 04-05-2018 10:25:54 -0400

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

Answers: 3

Views Metadata Catalog

query metadata tables SOURCE_CHANGES()
answered 27-03-2018 08:54:21 -0400

Hi, I found these functions to query metadata: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures we use SOUCE_CHANGES() in a select condition and wondering how this f...

Answers: 3