Denodo – Find Views With Missing Metadata Description

Advertisements

Here is a Denodo code snippet, which I use to identify views that do not have the metadata description populated.  Granted, this is a simple thing, but I have found it useful when validating that all Denodo views have been described in Virtual DataPort (VDP).

SELECT *
FROM GET_VIEWS()
WHERE
input_database_name = ‘Database_Name
And len(description) = 0;

Leave a Reply Cancel reply