ColumnDataProfiles

Get list of column data profiles.

Table Specific Information

Select

The component 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 component.
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.

SSIS Components for Azure Data Catalog

ColumnDataProfiles

Table Specific Information

Select

Columns