Share via

Extended properties in ADC

Oman 1 Reputation point
2020-10-14T07:51:58.92+00:00

Is it possible to add extended properties to the Azure Data Catalog?

Azure Data Catalog
Azure Data Catalog
An Azure service that serves as a system of registration and system of discovery for enterprise data assets.
100 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
    2020-10-15T08:17:25.78+00:00

    Hello @Oman ,

    Welcome to Microsoft Q&A platform.

    Could you please provide more details on the extended properties which you are referencing to?

    Note: Some of the extended properties are not supported in the Azure Data Catalog.

    The specific properties differ from data source to data source but, in general, the Data Catalog publishing service extracts the following information:

    • Asset Name
    • Asset Type
    • Asset Description
    • Attribute/Column Names
    • Attribute/Column Data Types
    • Attribute/Column Description

    Important note: For data sources such as SQL Server Analysis Services that have a first-class Description property, the Data Catalog data source registration tool extracts that property value. For on-premises SQL Server relational databases that lack a first-class Description property, the Data Catalog data source registration tool extracts the value from the ms_description extended property for objects and columns. This property is not supported for SQL Azure.

    For more information, see Using Extended Properties on Database Objects.

    For more details, refer “What properties does it extract for data assets that are registered?”.

    Hope this helps. Do let us know if you any further queries.

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.