The aggregates Module

class Aggregator(context: Optional[DBConnectionConfig] = None)

QUERY = '\n    SELECT\n        1 as ORD,\n        \'cms.ps\' as table, \n        COUNT(*) \n    FROM \n        "cms"."ps"\n    UNION\n    SELECT\n        2 as ORD,\n        \'medicaid.beneficiaries\' as table, \n        COUNT(*) \n    FROM \n        "medicaid"."beneficiaries"\n    UNION\n    SELECT\n        3 as ORD,\n        \'medicaid.enrollments\' as table, \n        COUNT(*) \n    FROM \n        "medicaid"."enrollments"\n    UNION\n    SELECT\n        4 as ORD,\n        \'medicaid.eligibility\' as table, \n        COUNT(*) \n    FROM \n        "medicaid"."eligibility"\n    ORDER BY 1\n    '

count() → Dict[str, int]

verify(expected)

class ExpectedData