Expectation for comparing counts on two tables or two SQL results

[raangs]

We have ETL pipelines, and we want to implement some validations on daily ingested ETL data with source tables.

Is there any Expectation i can use, to compare the counts between two tables (preferably using two SQLs) like source table count with target table count.

[austiezr]

Hey @raangs ! Thanks for reaching out. Take a look at this documentation on making cross-table comparisons.

Additionally, take a look at these expectations (1, 2) that may be relevant.