Denodo – Script To Alter Association Metadata Description

Here is a Denodo Virtual Query Language (VQL) code snippet, which I use to populate the metadata description of Denodo Associations in Virtual DataPort (VDP).  This snippet identifies Denodo Association without a Metadata Description and fills Metadata Description with a simple explanation of what the Denodo Association’s purpose.

VQL To Generate Association Alter Statements Description Update

select ‘ALTER ASSOCIATION’||’ ‘|| association_name || ‘ ‘||’DESCRIPTION =’|| ””|| ‘Performance association between’ ||’ ‘ || left_view_name || ‘ ‘|| ‘and’ ||’ ‘|| right_view_name ||””||’;’

FROM GET_ASSOCIATIONS()

WHERE input_database_name = ‘<<Database_Name>>’

AND input_type = ‘views’

AND len(trim(association_description)) <1

Add a View Name

Add this line to generate the association’s description updates for a specific view:

AND left_view_name = ‘<<View_Name>>

Vendor References

Denodo >User Manuals > Virtual DataPort VQL Guide > Stored Procedures > Predefined Stored Procedures > GET_ASSOCIATIONS

https://community.denodo.com/docs/html/browse/8.0/en//vdp/vql/stored_procedures/predefined_stored_procedures/get_associations