Microsoft Purview · Schema
ColumnProfile
ComplianceData CatalogData ClassificationData GovernanceData Loss PreventionInformation Protection
Properties
| Name | Type | Description |
|---|---|---|
| columnName | string | |
| dataType | string | |
| nullCount | integer | |
| nullPercentage | number | |
| distinctCount | integer | |
| minValue | string | |
| maxValue | string | |
| meanValue | string | |
| standardDeviation | number | |
| topValues | array |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/ColumnProfile",
"title": "ColumnProfile",
"type": "object",
"properties": {
"columnName": {
"type": "string"
},
"dataType": {
"type": "string"
},
"nullCount": {
"type": "integer",
"format": "int64"
},
"nullPercentage": {
"type": "number",
"format": "float"
},
"distinctCount": {
"type": "integer",
"format": "int64"
},
"minValue": {
"type": "string"
},
"maxValue": {
"type": "string"
},
"meanValue": {
"type": "string"
},
"standardDeviation": {
"type": "number",
"format": "double"
},
"topValues": {
"type": "array",
"items": {
"type": "object",
"properties": {
"value": {
"type": "string"
},
"count": {
"type": "integer",
"format": "int64"
}
}
}
}
}
}