How to get Managed Attributes field details from Purview from their respective assets(Azure Dedicated SQL Pool table)
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:
Below images are for references :
Here from the above images all data is coming inside JSON like Asset Description, Classification etc, except Managed Attributes section.