run_aggregate_check
Compare column-level aggregates (SUM, AVG, MIN, MAX, COUNT_DISTINCT) to verify numeric data integrity after row counts match.
Instructions
Compare column-level aggregates: SUM, AVG, MIN, MAX, COUNT_DISTINCT. PREREQUISITES: 1) validate_table_exists 2) validate_columns_exist. USE: After row counts match, to verify numeric data integrity.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | Yes | ||
| target | Yes | ||
| columns | Yes | Numeric columns to aggregate | |
| aggregates | No | ||
| partition_config | No |