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 | If data type is char or varchar, count of blank values (values with all space characters) in target_column; otherwise NULL. |
| ZeroCount | BIGINT | If DataType is numeric, count of zero values in target_column; otherwise NULL. |
| PositiveCount | BIGINT | If DataType is numeric, count of positive values in target_column; otherwise NULL. |
| NegativeCount | BIGINT | If DataType is numeric, count of negative values in target_column; otherwise NULL. |
| NullPercentage | DOUBLE PRECISION | Percentage of NULL values in target_column. |
| NonNullPercentage | DOUBLE PRECISION | Percentage of non-NULL values in target_column. |