ColumnDataProfiles
Get list of column data profiles.
Table Specific Information
Select
The connector will use the Azure Data Catalog API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
Note: ItemId is required in order to query ColumnDataProfiles.
- ItemId supports the '=' operator.
SELECT * FROM ColumnDataProfiles WHERE ItemId = '8a2b7305-b474-45d6-9fba-562454045070'
Columns
| Name | Type | Description |
| ItemId [KEY] | String | Item Id of a view or table. |
| ColumnName | String | The name of the column. |
| Type | String | The type of the column. |
| Min | String | The minimum value in the data set. |
| Max | String | The maximum value in the data set. |
| Avg | Decimal | The average value in the data set. |
| Stdev | Double | The standard deviation for the data set. |
| NullCount | Integer | The count of null values in the data set. |
| DistinctCount | Integer | The count of distinct values in the data set. |