Yuyin Yang created AIRFLOW-2280:
-----------------------------------
Summary: Extra argument for comparison with another table in IntervalCheckOperator
Key: AIRFLOW-2280
URL: https://issues.apache.org/jira/browse/AIRFLOW-2280
Project: Apache Airflow
Issue Type: Improvement
Components: core
Reporter: Yuyin Yang
Assignee: Yuyin Yang
Current IntervalCheckOperator can only check the values of metrics given as SQL expressions are within a certain tolerance of the ones from days_back before for the same table. For example, if I set metrics as COUNT(*), threshold ratio=1.5, and days_back=-7, then I can compare the count of this table at current, and the count of same table 7 days back.
However, during practice, we would like to first load tables to a tmp dataset, which has an expiration date. And after validation, we start to load it to production dataset. In this case, it makes more sense to compare the current tmp one, with production dataset days_back, because days_back temporary table may not exist.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)