Here is a spreadsheet documenting all of our existing tests which need to be migrated to the new framework.

Tests labeled bespoke don't use any common validate.py methods and might require custom handling. I've added a difficulty tag to each of these tests based on my initial vibe when looking at these tests. Those labeled easy indicate that I think these tests can be easily reproduced using off-the-shelf macros provided by dbt_expectations or dbt_utils. medium labels indicate that I don't think off-the-shelf macros will work, but it seemed like they could be recreated with custom sql without any major road-blocks. hard tests indicate that the test felt like it would not be easy/straightforward to develop the test in SQL. I spent pretty minimal time evaluating these tests, so some of these labels may end up being inaccurate.

Old tests to replace:

• check_duplicate_county_id_fips
• check_hour_from_date
• check_valid_aggregation_groups
• cooling_system_information_withdrawal_discrepancy_check
• fgd_cost_discrepancy_check (eia923)
• fgd_cost_discrepancy_check (eia860)
• test_bga_eia860
• test_dupe_years_in_plant_id_ferc1
• test_fbp_ferc1_mismatched_fuels
• test_fbp_ferc1_missing_fractions
• test_fuel_for_electricity
• test_generator_id_consistency
• test_nuclear_units_are_generators
• test_own_eia860
• test_ownership_for_owned_records
• test_plant_id_clash
• test_record_id_dupes
• test_unique_operator_id