Power BI Connector for Azure Data Catalog

Build 24.0.9062

ColumnDataProfiles

Get list of column data profiles.

Table Specific Information

Select

The 本製品 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 本製品.
Note: ItemId is required in order to query ColumnDataProfiles.

  • ItemId supports the '=' operator.
For example:
    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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062