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