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 proc - datasource for a base view
answered 14-06-2019 04:07:08 -0400

Is there a predefined stored proc where I can see the details of the datasource for a base view? I've been looking through https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_proce...

Answers: 3

Metadata

Finding a list of views within a folder from metadata
answered 12-06-2019 03:19:07 -0400

How do I query Denodo metadata to return all of the views within a specific folder (or it's subfolders) within a database? I can select list of folders using "select resultname from catalog_elements() where resulttype='folder' " but I can't work out ...

Answers: 1

Metadata

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

Metadata

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

metadata

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

Metadata

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

Metadata