Output Table Schema
Column | Data Type | Description |
---|---|---|
ColumnName | VARCHAR (CHARACTER SET UNICODE) |
Name of target column. |
DataType | VARCHAR (CHARACTER SET LATIN) |
Data type of target column. |
NonNullCount | BIGINT | Count of non-NULL values in target column. |
NullCount | BIGINT | Count of NULL values in target column. |
BlankCount | BIGINT | Count of blank values (values with all space characters) in target column when data type is CHAR or VARCHAR; otherwise NULL. |
ZeroCount | BIGINT | Count of zero values in target column when data type is NUMERIC; otherwise NULL. |
PositiveCount | BIGINT | Count of positive values in target column when data type is NUMERIC; otherwise NULL. |
NegativeCount | BIGINT | Count of negative values in target column when data type is NUMERIC; otherwise NULL. |
NullPercentage | DOUBLE PRECISION | Percentage of NULL values in target column. |
NonNullPercentage | DOUBLE PRECISION | Percentage of non-NULL values in target column. |