Q&A BY TAG 'Metadata'
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
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 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
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
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
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
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