View / Table description meta Data update/set in batch via SQL
Hi all,
is it possible to set/update the metadata for objects in DV like virtual views/tables using sql in batch mode?
I would like to transport the metadata from database to Data Virtuality for better understanding and searching during development and ETL processing for business purposes. This is also very important for new colleagues as this information is linked directly to the object and does not need to be extra searched out via doc.
Thanks for your answers.
Many greetings
Oliver
-
Comment actionsOfficial comment
Hi Oliver,
normally our metadata is gathered from the source and it should include descriptions. If you would like to update it, a metadata refresh can help. The descriptions we read are normally for views, tables and columns. If you can't see the descriptions, can you please provide the database type and we can check it.
If you would like to set descriptions from any source, you can use the setRemark function, for example:
EXEC "SYSADMIN.setRemark"(name => 'mydatasource.sales_data', remark => 'Sales information');
This can be used in automation. Below statement sets the descriptions for tables according to a description table.
BEGIN
LOOP ON (SELECT tableName, description from myconn.tableDescription) as cur
EXEC SYSADMIN.setRemark("name" => cur.tableName, "remark" => cur.description);
ENDPlease let us know if this works for you.
Best,
Matthias
Please sign in to leave a comment.
Comments
1 comment