View / Table description meta Data update/set in batch via SQL

Comments

1 comment

  • Comment actions Permalink
    Official comment
    Avatar
    Matthias Korn

    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);
    END

    Please let us know if this works for you.

    Best,
    Matthias

Please sign in to leave a comment.

Powered by Zendesk