aggregate_check

AstroCertified

Validate the result from a SQL which performs an aggregation matches an expected value.

View on GitHub

Last Updated: Dec. 16, 2021

Access Instructions

Install the Astro provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.

Parameters

tableRequiredastro.sql.table.TableThe ``Table`` to perform aggregate SQL command.
checkRequiredstrThe SQL statement to execute.
greater_than[int or float]The minimum expected value. This value range is inclusive i.e. some_value >= ``greater_than``.
less_than[int or float]The maximum expected value. This value range is inclusive i.e. some_value <= ``less_than``.
equal_to[int or float]The expected value.

Documentation

Validate the result from a SQL which performs an aggregation matches an expected value.

Was this page helpful?