How to get Managed Attributes field details from Purview from their respective assets(Azure Dedicated SQL Pool table)

Utsav Mori 20 Reputation points
2024-07-10T07:19:08.4966667+00:00

I want Managed Attributes field of all the assets in purview and I am already using PurviewCatalogClient functionality to fetch the details of each assets.

cred = AzureCliCredential()
#cred = DefaultAzureCredential()
client = PurviewClient(
    account_name="client-account-name",
    authentication = cred
)
client1  =  PurviewCatalogClient(endpoint="client-endpoint-already-at-my-end", credential = cred, logging_enable=True)
body_input={
        
        "keywords": keywords,
        "limit":1,
        "filter": {"assetType":"Azure SQL Data Warehouse"}
       
        
    }
response  =  client1.discovery.query(search_request= body_input)
client1.discovery.query(search_request= body_input)

Below is the JSON as a response which is generating from the above code but it is not fetching Managed Attribute details from my purview for that respective assets.

[
  {
    "@search.count": 2552,
    "value": [
      {
        "objectType": "Tables",
        "updateBy": "ServiceAdmin",
        "contact": [
          {
            "contactType": "Owner",
            "id": ""
          },
          {
            "contactType": "Owner",
            "id": ""
          },
          {
            "contactType": "Owner",
            "id": ""
          },
          {
            "contactType": "Expert",
            "id": ""
          },
          {
            "contactType": "Expert",
            "id": ""
          },
          {
            "contactType": "Expert",
            "id": ""
          }
        ],
        "term": [
          {
            "name": "Demo",
            "guid": "",
            "glossaryName": "Glossary"
          },
          {
            "name": "Schedule",
            "guid": "",
            "glossaryName": "Glossary"
          }
        ],
        "id": "ec0dce83-032c-4fb5-af2e-04f6f6f60000",
        "collectionId": "",
        "displayText": "Demo",
        "isIndexed": true,
        "userDescription": "Demo it is ",
        "qualifiedName": "",
        "entityType": "azure_sql_dw_table",
        "updateTime": 1719645571119,
        "classification": [
          "M"
        ],
        "assetType": [
          "Azure SQL Data Warehouse"
        ],
        "createBy": "ServiceAdmin",
        "createTime": 1705136063145,
        "name": "Demo",
        "@search.score": 39.6999
      },

Above JSON is the response of API it contain all the details of asset except Managed Attributed Details of that asset which contains field Business Metadeta, Operational Metadeta, Technical Metadeta this are customised fields created by us for business purpose.Managed Attribute(Customised fields) Strucutre Define Below:User's image

Below images are for references :

User's image

User's image

Here from the above images all data is coming inside JSON like Asset Description, Classification etc, except Managed Attributes section.

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,236 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.