[docs]
class SQLReference:
SQL_FILES = {
"/home/ubuntu/airflow/dags/bead/sar_export/dbt_project/models": [
"schema.yml",
"sar_no_bead_locations_tx.sql",
"sar_served_cais_tx.sql",
"sar_deployment_projects_ar.sql",
"qa_served_locations_guard_tx.sql",
"sar_subgrantees_tx.sql",
"sar_deployment_projects_tx.sql",
"sar_subgrantees_ar.sql",
"sar_baba_tracker_tx.sql",
"sar_served_bsls_tx.sql",
"sar_subgrantees.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations/SQL/lookups": [
"pg_select_app_ids_by_status.sql",
"pg_select_app_locations.sql",
"pg_select_app_location_answers.sql",
"ath_select_matched_applicants.sql",
],
"/home/ubuntu/airflow/dags/rad/classifier/stage2_building_type/dbt_project/models": [
"schema.yml",
"t_rad_classifier_building_type.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/sga_rp_migration/SQL": [
"00_delete_old_sga_answers_count.sql",
"verification_after.sql",
"00_delete_old_sga_answers_update.sql",
"02_delete_old_sga_apps_count.sql",
"01_delete_old_relations_update.sql",
"verification_before.sql",
"02_delete_old_sga_apps_update.sql",
"01_delete_old_relations_count.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage0_prep/dbt_project/models": [
"schema.yml",
"t_fp_reporting_projects.sql",
"t_fp_cai.sql",
"t_fp_deployment_projects_answers.sql",
"t_fp_subgrant_agreements.sql",
"t_fp_users.sql",
"t_fp_subgrantees.sql",
"t_fp_grantor_users.sql",
"t_fp_reporting_project_cai.sql",
"t_fp_deployment_projects.sql",
"t_fp_locations.sql",
"t_fp_subgrant_agreement_projects_answers.sql",
"t_fp_subgrant_agreement_dp_map.sql",
"t_fp_reporting_projects_answers.sql",
"t_fp_deployment_reporting.sql",
"t_fp_reporting_project_locations.sql",
"t_fp_no_bead_locations.sql",
],
"/home/ubuntu/airflow/dags/general/data_summary/isp_cheat/SQL": [
"unserved_change-nationwide.sql",
"unserved_change-state.sql",
],
"/home/ubuntu/airflow/dags/bead/bead12_map/dbt_project/models": [
"schema.yml",
"c_bead12_merge.sql",
],
"/home/ubuntu/airflow/dags/architecture/boss_prd2stg_keep_users/SQL": [
"empty_signature_documents.sql",
"reset_sga_applications.sql",
],
"/home/ubuntu/airflow/dags/suitability/ms_hypercube/03_composite/dbt_project/models/ms_hyper/transformed": [
"ms_fcc_towers.sql",
"ms_client_preferred.sql",
"ms_hospitals_by_county.sql",
"ms_hrsa_health_centers.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/va": [
"x_va_datasme2095_llu_nodes.sql",
"x_va_datasme2095_llu_applications.sql",
"x_va_datasme2095_llu_file_metadata.sql",
"x_va_datasme1847_unfunded_addresses.sql",
"x_va_datasme2136_baba_report_attachments.sql",
"x_va_datasme2095_llu_location_activities.sql",
"x_va_datasme2095_llu_form_answers.sql",
"x_va_datasme2095_llu_locations.sql",
"x_va_datasme1419_reporting_project_cai.sql",
"x_va_datasme2136_baba_report_history.sql",
"x_va_datasme2136_baba_report_answers.sql",
"x_va_datasme1419_reporting_project_locations.sql",
"x_va_datasme1419_reporting_projects.sql",
"x_va_datasme2136_baba_reports.sql",
"x_va_datasme2095_llu_reviews_revisions.sql",
"x_va_datasme1419_deployment_reporting.sql",
],
"/home/ubuntu/airflow/dags/game/ingest_data/SQL/game_mississippi": [
"geotel_lata.sql",
"geotel_rate_centers.sql",
"geotel_data_centers.sql",
"geotel_bdc_fiber_to_premise_fcc.sql",
"geotel_bdc_wireless_5g_fcc.sql",
"public_safety_answering_point_broadband_services.sql",
"geotel_central_offices.sql",
"bsl_locations.sql",
"geotel_cable_operating_areas.sql",
"geotel_fiber_lit_buildings.sql",
"geotel_cell_towers.sql",
"counties.sql",
"cdc_health.sql",
"geotel_fiber_routes.sql",
"geotel_area_codes.sql",
"geotel_wire_centers.sql",
],
"/home/ubuntu/airflow/dags/proposed_project_areas/curate_ppa/SQL": [
"indiana.sql",
"arkansas.sql",
"mississippi.sql",
"demo_base.sql",
"minnesota.sql",
"texas.sql",
"arizona.sql",
"california.sql",
"pg_c_proposed_project_areas.sql",
"lake_pg_copy.sql",
"oklahoma.sql",
],
"/home/ubuntu/airflow/dags/general/test/dbt_intro/travis/dbt_project/models/staging": [
"dbt_schema.yml"
],
"/home/ubuntu/airflow/dags/geometry_library/SQL": [
"single_dataset_insert.sql",
"standard_geography.sql",
"create_table_c_geometry_library_in_pg.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/version_compare/dbt_project/models": [
"t_fp_compare_versions_rp.sql",
"t_fp_compare_versions_dp.sql",
"sources.yml",
],
"/home/ubuntu/airflow/dags/cpc/point_in_time_refactor/stage2_load_providers/SQL": [
"2_upsert_fcc_providers.sql",
"1_extract_fcc_providers.sql",
"2_upsert_fcc_tech_map.sql",
"1_extract_fcc_tech_map.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/in": [
"x_in_datasme1726.sql",
"x_in_datasme1456.sql",
"x_in_datasme1457.sql",
"x_in_datasme1440.sql",
"x_in_datasme1454.sql",
"x_in_datasme2117_joink_ocremc_cai.sql",
"x_in_datasme2117_joink_ocremc_bsl.sql",
"x_in_datasme2117_joink_ocremc_bsl_lake.sql",
"x_in_datasme2117_joink_ocremc_cai_lake.sql",
"x_in_datasme1821.sql",
"x_in_datasme1950.sql",
"x_in_datasme1417.sql",
"x_in_datasme1459.sql",
"x_in_datasme1458.sql",
"x_in_datasme1461.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/ca": [
"x_ca_datasme1432.sql",
"x_ca_datasme1961.sql",
"x_ca_datasme1312.sql",
"x_ca_datasme1945.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_qc": [
"template.sql"
],
"/home/ubuntu/airflow/dags/digital_equity/maternal_child_health/SQL": [
"curate.sql"
],
"/home/ubuntu/airflow/dags/general/ingest_from_s3/json": [
"ar_cust_4133_no_bead.json",
"ms_proposed_project_areas.json",
"ms_cpf_datasme813_ackerman.json",
"oh_cpc_post_challenge_ntia_classification_cust_2706.json",
"tx_cpc_curing_20250415.json",
"nc_cpc_post_challenge_cai_name_revision.json",
"ok_update_cai_list_07082025_flagged_for_removal.json",
"ar_cust_bead_results_stage.json",
"ms_ulfw_20250626_latest_fabric.json",
"in_final_proposal_combine_20260409.json",
"ar_cust_4133_ar_bb_round_20250819.json",
"or_app_2927.json",
"mn_datasme_1314_fp_subgrant_agreements.json",
"in_cpc_post_remediated.json",
"in_address_data_no_code_3_4_update.json",
"la_final_proposal_final_no_bead_locations.json",
"tx_ulfw_gvtc_challenge_loc.json",
"tx_datasme_2084.json",
"ms_bip_polarville_locations.json",
"in_r2_ppa_master_project_area_join.json",
"ar_datasme_973_cai_verification.json",
"ms_cpf_indicated_locations.json",
"ok_cust_4130_award_locs.json",
"ar_cpc_post_challenge_cai_revision.json",
"ok_datasme-1153_final_proposal_cai.json",
"data_1601.json",
"ok_datasme_1513_cai_removal.json",
"ms_cpc_post_challenger.json",
"tx_fp_no_bead_usda.json",
"ms_cpc_challenger.json",
"ar_datasme_1211.json",
"la_rdof_removal_dup.json",
"in_bad_ec_in_daviess.json",
"ca_cpuc_high_need_locations_20250522.json",
"la_final_proposal_final_deployment_projects.json",
"oh_cpc_post_challenge_ntia_classification_cust_2770.json",
"ms_cpc_curing_update_20250131.json",
"TX_curing_results_20251015.json",
"tx_cpc_conceded_planned_locations_spectrum_actual.json",
"ms_rate_no_bead_20250827.json",
"ms_cpc_post_challenges.json",
"in_r2_ppa_raw_project_areas.json",
"ms_ulfw_code5.json",
"ms_cpc_curing_update_20250326.json",
"ar_cust_4133_org194.json",
"va_datasme_1409_fp_supp_users.json",
"ar_datasme_1861.json",
"in_cust_4136_provider_mapping.json",
"tx_ulfw_spectrum_actual.json",
"tx_ppa_ingest.json",
"ms_cpf_round_2_20250303.json",
"ok_slfrf_v4_s2.json",
"nc_cai_beadchallenge_240804.json",
"nj_cpc_dedup_adjustments.json",
"la_final_proposal_final_locations.json",
"in_r2_ppa_master_project_name_join.json",
"az_cpc_bead_r2_ppa.json",
"va_datasme_1356_fp_reporting_projects.json",
"nm_cpc_post_review_020625.json",
"oh_cpc_pre_challenge_orbeg.json",
"ok_datasme_1513_project_to_add.json",
"az_bob_locations.json",
"tx_final_proposal_leo_20251020.json",
"ar_datasme_1850.json",
"in_eligible_addresses_null.json",
"ms_bip_kmz_dedup_dropped.json",
"mn_restructured_bead_eligible_locations.json",
"al_datasme_1468_scabcd_report_cai.json",
"az_cpc_bead_r1_covered_cai.json",
"ar_datasme_973_paf_map.json",
"ca_cpc_post_cai_0924.json",
"tx_bob_potential_preliminary_awards.json",
"ok_bead_highcost_cbg.json",
"md_rate_datasme_1125_p1.json",
"az_cpc_post_challenge_locations.json",
"nm_cpc_post_review.json",
"ms_ulfw_20250626_cai_eligible.json",
"ca_cpc_post_cai_qa.json",
"oh_cpc_challenge_provider_id.json",
"az_cpc_post_challenge_locations_1122.json",
"ms_ rc5_not_served_latest_bdc_src.json",
"ms_ulfw_20250701_cai_master.json",
"ar_cust_cumulative_bead_results_t3.json",
"ms_bob_priority_pau.json",
"naics_index_codes.json",
"tx_ppa_20250606_donut.json",
"tx_fp_location_reference_20251013.json",
"ms_cpc_post_challenges_review.json",
"tx_ulfw_locations_20250702.json",
"tx_ppa_20250707_adjacency.json",
"tx_fp_projects_compiled_20251007.json",
"gu_bob_pre_challenge_loc.json",
"ms_cpc_curing_20250321_removed_challenges.json",
"xz_bead_highcost_cbg.json",
"ms_bead_cost_v5.json",
"la_final_proposal_final_non_deployment_projects.json",
"ms_cpc_copy_fabric_v6.json",
"ms_bead_ppa_20250512.json",
"tx_fp_20251125_projects.json",
"tx_final_proposal_leo_20251020_project.json",
"ar_datasme_1934.json",
"ca_cpuc_high_need_locations.json",
"va_datasme_1356_fp_subgrant_agreements.json",
"la_rdof_removal_pre.json",
"in_cpc_post_default_mercury_fwa.json",
"tx_final_proposal_curing_20251024.json",
"tx_cpc_conceded_planned_locations_spectrum_planned.json",
"ok_datasme_1523_fp_archive.json",
"in_omitted_code_3_4_locations.json",
"tx_fp_no_bead_cai_removed.json",
"va_bead_post_challenge_locations.json",
"ms_datasme_1886_national_forest_boundaries.json",
"la_rdof_removal_post.json",
"ms_psap_locations_id.json",
"ok_datasme-1153_final_proposal_locations.json",
"ms_no_bead_initial_submission_datasme_1171.json",
"ms_rate_no_bead.json",
"tx_fp_location_qc_20151024.json",
"in_cpc_post_speed_adjustment.json",
"ar_bb_round_sgs_results_approved_20250808.json",
"tx_bob_remove_locations_rc6.json",
"ms_cpc_curing_update_20250224.json",
"tx_cpc_conceded_planned_locations_easttex.json",
"ms_ulfw_20250626_master_indicated.json",
"ar_cust_bead_results_t3.json",
"ok_update_cai_list_07082025_new_updated_list.json",
"ms_34_ATT_Marshall_1617_provisional_awarded_bsls.json",
"tx_fp_20251125_locations.json",
"la_additional_fedfunded_012326.json",
"tx_fp_locations_compiled_20251007.json",
"la_final_proposal_final_cai.json",
"tx_fp_no_bead_v7_removed.json",
"ca_bob_round_3_ppa_awarded_apps.json",
"ar_cpc_post_challenge_cai_sbo_cust_1628.json",
"tx_ulfw_spectrum_planned.json",
"tx_bob_remove_locations_rc5.json",
"tx_found_cai_names.json",
"nm_cpc_post_validation.json",
"ms_datasme_1886_att_national_forest_list.json",
"mn_cpc_post_remediated.json",
"in_cpc_post_default_mercury_fiber.json",
"ar_cust_cbg_recommended_results.json",
"ms_bip_kmz_funded.json",
"ms_rdof_funded_d25_20260722.json",
"or_cpc_post_challenge.json",
"ms_cpc_curing_20250321_updated_locations.json",
"datasme_1341.json",
"mn_irrrb_pbc_no_bead.json",
"ca_bob_round_3_ppa_awarded_ppas.json",
"ca_cpuc_fire_threat_map_v3r.json",
"in_madison_co_name_update.json",
"ca_bead_urban_rural_counties.json",
"tx_fp_no_bead_state_challenge.json",
"tx_cpc_post_challenge.json",
"tx_fp_deployment_project_reference_20251013.json",
"ok_proposed_project_areas_20250305.json",
"va_datasme_1254_fp_subgrant_agreements.json",
"ok_datasme_1523_match_revision.json",
"tx_fp_potential_special_process_202151007.json",
"tx_ppa_20250514.json",
"ms_bead_ppa_20250602.json",
"az_project_areas_attributes.json",
"ms_tlp_location_speedcheck.json",
"xz_deployment_projs_datasme_1330.json",
"ca_cpc_post_cai_add.json",
"ar_cpc_post_location_sb_cust_1628.json",
"tx_bead_cai_outside.json",
"mn_bob_all_bead_locations.json",
"ca_bob_bsl_pau_mapping.json",
"mn_application_area_polygons.json",
"md_rate_datasme_1125_p2.json",
"tx_ulfw_comcast_concedes.json",
"cust_1699.json",
"ca_gms_locations_20250304.json",
"ms_ulfw_20250626_latest_rdof.json",
"ar_cust_cbg_recommended_results_stage.json",
"national_bead_progress.json",
"nc_cpc_datasme738_post_challenge_cai.json",
"az_cpc_bob_ppa_price.json",
"la_final_proposal_final_subgrantees.json",
"az_cpc_bead_r2_ppa_price.json",
"va_datasme_1356_fp_reporting_projects_locations.json",
"tx_cpc_conceded_planned_locations_gvtc.json",
"tx_fp_cai_reference_20251013.json",
"ms_app_1297_bsl_primary.json",
"tx_datasme_2052_bead_permit_bulk_load_consolidated.json",
"tx_ppa_20250606.json",
"ms_cpc_curing_update_20250210.json",
"ms_lookback_locations_datasme_1940.json",
"ca_bob_files_20250711.json",
"ok_bead_fp_cai_2.json",
"in_fp_no_bead_warren.json",
"ar_cpc_post_location_sbo.json",
"in_fp_no_bead_rossville.json",
"ny_default_funding_locations.json",
"ar_cust_bead_result_t1.json",
"tx_fp_no_bead_state_details.json",
"or_cpc_post_challenge_disposition.json",
"ok_oklahoma_locations_npv.json",
"tx_bob_remove_locations_rc4.json",
"ar_cust_cumulative_bead_results2.json",
"ok_datasme_1497.json",
"ms_cpc_project_areas_redrawn_20250313.json",
"va_datasme_1848_vati_funding.json",
"ar_cbg_post_challenge.json",
"tx_fp_20251125_cai.json",
"ms_cpf_datasme813_noackerman.json",
"tx_fp_20251125_no_bead_locations.json",
"in_bob_eligible_locations.json",
"gu_bob_pre_challenge_loc_20250722.json",
"ar_cust_cumulative_bead_results.json",
"xz_ppa_datasme_1330.json",
"ok_datasme_1513_fp_archive.json",
"tx_datasme_2052_permitting_excel_template_frontier_southwest.json",
"ar_datasme_1301_fp_subgrant_agreements.json",
"gu_cpc_post_challenge_ntia_20250404.json",
"gu_bob_pre_challenge_loc_project.json",
"az_cpc_bead_r2_locs.json",
"ar_cust_bead_results.json",
"al_datasme_1468_scabcd_report_locations.json",
"oh_cpc_post_challenge_0102.json",
"ca_cpuc_high_cost.json",
"ms_cpf_round_2_preliminary_determination_locations.json",
"ms_cpc_post_challenges_011524.json",
"ok_slfrf_v4.json",
"tx_bob_potential_preliminary_awards_20251007.json",
"ar_paf_datasme_949.json",
"ok_bead_fp_cai.json",
"nc_cpc_post_challenge_cai_zipcode.json",
"tx_challenge_portal_export_01222025.json",
"in_fp_no_bead_9095.json",
"tx_ppa_20250707_donut.json",
"va_datasme_1356_fp_reporting_projects_cais.json",
"ms_exhibit_c_bead_locations_csv_file_082826.json",
"ms_datasme_2134_cpf_beam_10122026.json",
"ms_datasme_2153_psc_current_cas.json",
"la_ready_data_compare012026V1.json",
"ms_cpc_curing_20250321_updated_challenges.json",
"az_cpc_bead_r1_covered_bsl.json",
"oh_arc_mbdr_1076.json",
"ok_datasme-1559_final_proposal_choctaw_nation.json",
"ms_ulfw_20250626_cai_ineligible.json",
"tx_bead_pau_summary_20250508.json",
"tx_bob_remove_locations_rc2.json",
"in_appsme_1900.json",
"ok_bead_net_20250414.json",
"ok_fp_tribal_update_20260515.json",
"nd_cpc_post_location_sbo.json",
"ca_bob_cai_pau_mapping.json",
"ms_exhibit_c_bead_locations_csv_file_091026.json",
"ar_datasme_1992.json",
"gu_bob_pre_challenge_loc_20250724.json",
"in_r2_ppa_dissolved_project_areas.json",
"ar_cpc_post_challenge_cai_sbo.json",
"ok_datasme-1559_final_proposal_choctaw_nation_v2.json",
"ca_cpc_post_cai_20250321.json",
"tx_ppa_clean_geometry_20250609.json",
"ok_datasme_1433.json",
"ca_gms_locations_20250314.json",
"ok_datasme_1472.json",
"ms_bip_curing_update_20250210.json",
"ok_proposed_project_areas.json",
"ca_datasme_1638_tribal_locations.json",
"az_project_areas.json",
"oh_cpc_post_challenge_ntia_underserved.json",
"ar_datasme_1809_spacex.json",
"ca_casf_initial.json",
"xz_boundary_datasme_1330.json",
"ca_bob_round_3_ppa.json",
"tx_fp_deployment_project_reference_20251014.json",
"in_tcc_data.json",
"ms_psap_locations.json",
"tx_fp_20251125_subgrantees.json",
"ca_cafii_casf_overlap_locations.json",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects/SQL/SubgrantAgreement": [
"pg_insert.sql",
"load_lake.sql",
],
"/home/ubuntu/airflow/dags/sbo/ms/cpf_s3_to_boss/SQL": [
"t_ms_cpf_awarded_locations.sql"
],
"/home/ubuntu/airflow/dags/safegraph/normalize_addresses/SQL": [
"ctas_normalize_address.sql"
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_cai": [
"test.sql",
"OK_customized_20260413.sql",
"OK_customized_20260416.sql",
"OK_customized_20260210.sql",
"OK_customized_20260317.sql",
"TX.sql",
"template.sql",
"OK_customized_20260506.sql",
"AZ.sql",
"MN.sql",
"OK_customized_20260515.sql",
"OK_customized.sql",
"MS.sql",
"AR.sql",
"OK.sql",
"IN_customized_20260409.sql",
"OK_customized_20260326.sql",
"IN.sql",
],
"/home/ubuntu/airflow/dags/arc/phub_project_view/SQL": [
"AR_projects.sql",
"XY_locations.sql",
"AR_locations.sql",
"VA_projects.sql",
"XY_projects.sql",
],
"/home/ubuntu/airflow/dags/general/test/mock_ingest_export/dbt_project/models": [
"x_ca_rail_network.sql",
"_sources.yml",
],
"/home/ubuntu/airflow/dags/bead/export_bead_app_meta/SQL": [
"pg_question_mapping.sql",
"pg_question_no_mapping.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator_edge_score/stage1_features/dbt_project/models": [
"schema.yml",
"t_rad_rel_address_building_candidates.sql",
"t_rad_rel_address_building_features.sql",
],
"/home/ubuntu/airflow/dags/arc/nepa/ingest_locations/dbt_project/models": [
"schema.yml",
"c_nepa_locations_in.sql",
"c_nepa_locations_ar.sql",
"c_nepa_locations.sql",
"c_nepa_locations_va.sql",
"c_nepa_locations_mn.sql",
"c_nepa_locations_az.sql",
"c_nepa_locations_tx.sql",
"sources.yml",
],
"/home/ubuntu/airflow/dags/cpc/point_in_time_refactor/stage2_load_point_in_time/SQL": [
"0_ath_extract_point_in_time_bob_ok.sql",
"0_ath_extract_point_in_time_demo.sql",
"0_ath_extract_point_in_time.sql",
"0_ath_extract_point_in_time_legacy.sql",
"0_ath_extract_point_in_time_post_challenge_ca.sql",
"0_ath_extract_point_in_time_post_challenge_legacy.sql",
"0_ath_extract_point_in_time_arc.sql",
"0_ath_extract_point_in_time_objection.sql",
"0_ath_extract_point_in_time_post_challenge_tx.sql",
"0_ath_extract_point_in_time_post_challenge_ok.sql",
"0_ath_extract_point_in_time_bob.sql",
"2_pg_load_point_in_time.sql",
"1_pg_upsert_address.sql",
"1_ath_extract_address_updates.sql",
"0_ath_extract_point_in_time_ulfw.sql",
"0_ath_extract_point_in_time_bob_ca.sql",
"0_ath_extract_point_in_time_az.sql",
"0_ath_extract_point_in_time_post_challenge.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator_edge_score/stage2_score/dbt_project/models": [
"schema.yml",
"t_rad_rel_address_building_scored.sql",
],
"/home/ubuntu/airflow/dags/rad/openaddresses/transform/dbt_project/models": [
"t_openaddress_county.sql",
"schema.yml",
"t_openaddress_usa.sql",
"_t_openaddress_usa_county.sql",
"t_openaddress_summary.sql",
],
"/home/ubuntu/airflow/dags/general/test/mock_ingest_export_2/dbt_project/models": [
"x_ca_rail_network.sql",
"_sources.yml",
],
"/home/ubuntu/airflow/dags/cpc/stage9_backfill_final_proposal/SQL/Application": [
"test.sql",
"pg_update_ok.sql",
"load_lake_mn.sql",
"load_lake_az.sql",
"check_delta_mn.sql",
"pg_insert.sql",
"load_lake_ms.sql",
"pg_update.sql",
"load_lake_ok.sql",
"pg_insert_mn.sql",
"pg_update_ok_int.sql",
"load_lake.sql",
"pg_update_az.sql",
"pg_update_mn.sql",
"load_lake_ok_int.sql",
],
"/home/ubuntu/airflow/dags/training/11_dbt_run/dbt_project/models": [
"training_demo.sql"
],
"/home/ubuntu/airflow/dags/cpc/stage3_load_addresses/SQL": [
"MS_load_BOSS_cpf.sql",
"DE_load_BOSS.sql",
"OH_load_BOSS.sql",
"CT_load_BOSS.sql",
"AZ_load_BOSS.sql",
"LA_load_BOSS.sql",
"CA_load_BOSS.sql",
"MS_load_BOSS.sql",
"TX_load_BOSS.sql",
"NY_load_BOSS.sql",
"AL_load_BOSS.sql",
"WV_load_BOSS.sql",
"MT_load_BOSS.sql",
"NH_load_BOSS.sql",
"OK_load_BOSS.sql",
"KS_load_BOSS.sql",
"NM_load_BOSS.sql",
"VA_load_BOSS.sql",
"DC_load_BOSS.sql",
"NJ_load_BOSS.sql",
"PA_load_BOSS.sql",
"IN_load_BOSS.sql",
"HI_load_BOSS.sql",
"OR_load_BOSS.sql",
"ND_load_BOSS.sql",
"NC_load_BOSS.sql",
"AR_load_BOSS.sql",
"MN_load_BOSS.sql",
"OK_load_BOSS_cpf.sql",
"MI_Detroit_load_BOSS.sql",
"WY_load_BOSS.sql",
"GU_load_BOSS.sql",
"NV_load_BOSS.sql",
],
"/home/ubuntu/airflow/dags/general/airflow_config_update/table_reference/SQL": [
"DL_CONTROL.sql",
"DL_POST_BEAD.sql",
"PG_CONTROL.sql",
"PG_TENANTS.sql",
"DL_PRE_BEAD.sql",
],
"/home/ubuntu/airflow/dags/lsd/both/SQL": [
"athena_cet_c_lsd.sql",
"athena_cet_t_lsd.sql",
"pg_ddl_c_lsd_individual.sql",
"athena_insert_c_lsd.sql",
"pg_create_c_lsd.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations_wip/SQL/no_bead": [
"extract_no_bead_attributes.sql",
"update_pit_no_bead_attributes.sql",
],
"/home/ubuntu/airflow/dags/funding_cpc/update/la/gumbo_ingest_v3/SQL": [
"merge_gumbo.sql"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects_wip/SQL/SubgrantAgreement": [
"pg_insert.sql",
"pg_update.sql",
"load_lake.sql",
],
"/home/ubuntu/airflow/dags/general/ctasifier/sql": [
"VA_DATASME-1895_rp_financial_reporting_project_answers_backup.sql",
"ar_bi_applicant_contact.sql",
"bi_application_answer_wide.sql",
"VA_DATASME-1895_rp_financial_subgrant_agreements_backup.sql",
"c_bob_merge_tile_tx_backup_082626.sql",
"ca_bi_application_answer.sql",
"mn_bi_application_cai.sql",
"bi_bead_project_activity.sql",
"VA_DATASME-1943_non_cai_hash_control.sql",
"bi_bead_compliant_report_detail.sql",
"bi_bead_project_review_stage.sql",
"ar_bi_application_answer_wide.sql",
"VA_DATASME-1895_rp_financial_reporting_projects_backup.sql",
"demo_bi_application_answer_wide.sql",
"bi_application_question_answer_mapping.sql",
"demo_bi_applicant_contact.sql",
"bi_bead_project_plan_detail.sql",
"VA_DATASME-1895_rp_financial_subgrant_agreement_answers_backup.sql",
"bi_application_answer.sql",
"ca_bi_deployment_projects.sql",
"ApplicationLocation_backup_082626.sql",
"ca_bi_application_answer_wide.sql",
"bi_application_location.sql",
"ar_bi_application_location.sql",
"ar_bi_deployment_projects.sql",
"demo_bi_application_question_answer_mapping.sql",
"bi_application_cai.sql",
"bi_deployment_projects.sql",
"demo_bi_application_cai.sql",
"bi_bead_project_plan.sql",
"mn_bi_deployment_projects.sql",
"az_bi_application_question_answer_mapping.sql",
"ar_bi_application_question_answer_mapping.sql",
"demo_bi_application_location.sql",
"ca_bi_application_question_answer_mapping.sql",
"bi_bead_project_permit.sql",
"az_bi_application_answer_wide.sql",
"ca_cpc_funding_arc_pre_20260217.sql",
"ar_bi_application_cai.sql",
"VA_DATASME-1943_cai_corrected_tile_projection.sql",
"bi_applicant_contact.sql",
"mn_bi_application_question_answer_mapping.sql",
"tx_economic_regions.sql",
"mn_bi_applicant_contact.sql",
"bi_bead_provider_sga.sql",
"mn_bi_application_answer_wide.sql",
"az_bi_application_answer.sql",
"mn_bi_application_location.sql",
"ca_bi_application_cai.sql",
"bi_bead_project_milestone_1.sql",
"ar_bi_application_answer.sql",
"ca_bi_applicant_contact.sql",
"bi_bead_project_overview.sql",
"demo_bi_application_answer.sql",
"mn_bi_application_answer.sql",
"bi_bead_project_budget.sql",
"bi_user_applicant_access.sql",
"az_bi_application_cai.sql",
"bi_bead_location_detail.sql",
"az_bi_deployment_projects.sql",
"bi_bead_award_overview.sql",
"demo_bi_deployment_projects.sql",
"ca_bi_application_location.sql",
"bi_bead_compliant_report.sql",
"az_bi_application_location.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage7_post_challenge_adjustment/SQL/cai": [
"XZ_post_challenge_cai.sql"
],
"/home/ubuntu/airflow/dags/sbo/ms/bead/SQL": [
"MS_fabric_post_challenge.sql",
"MS_version_comp.sql",
"MS_v5_summary.sql",
"MS_version_comp_district.sql",
"MS_post_challenge_summary_bsl.sql",
"MS_post_challenge_summary_cai.sql",
],
"/home/ubuntu/airflow/dags/bedrock/ingest_db/sql": [
"AR_DATASME-1075_archie_bsls.sql",
"AR_DATASME-1075_archie_cais.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage5_application_answer_wip/dbt_project/models": [
"schema.yml",
"t_fp_location_place_input.sql",
"t_fp_answer_targets.sql",
"t_fp_location_place_resolution.sql",
"t_fp_answer_project.sql",
"t_fp_answer_location_counts.sql",
"t_fp_answer_location_places.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage1_ingest_schema/dbt_project/models": [
"schema.yml",
"sources.yml",
],
"/home/ubuntu/airflow/dags/bedrock/data_comparison_agent/comparison/dbt_project/models": [
"schema.yml"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage9_export/dbt_project/models": [
"schema.yml",
"x_fp_deployment_reporting.sql",
"x_fp_reporting_project_cai.sql",
"x_fp_locations.sql",
"x_fp_subgrant_agreements.sql",
"x_fp_deployment_projects.sql",
"x_fp_reporting_project_locations.sql",
"x_fp_subgrantees.sql",
"x_fp_reporting_projects.sql",
"x_fp_cai.sql",
"x_fp_no_bead_locations.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations/SQL/no_bead": [
"extract_no_bead_attributes.sql",
"update_pit_no_bead_attributes.sql",
],
"/home/ubuntu/airflow/dags/arc/upload_onboard_templates/dbt_project/models/standard": [
"users.sql",
"companies.sql",
"projects.sql",
],
"/home/ubuntu/airflow/dags/funding_cpc/default/SQL": [
"create_default_or.sql",
"create_default_nc.sql",
"create_default_al.sql",
"create_default_ca.sql",
"create_default_in.sql",
"create_default_template.sql",
"create_default_hi.sql",
"create_default_la.sql",
"create_default_nh.sql",
"create_default_ms.sql",
"create_default_ar.sql",
"create_default_ny.sql",
"create_default_oh.sql",
"create_default_wy.sql",
"create_default_nm.sql",
],
"/home/ubuntu/airflow/dags/arc/ne_project_plan_bulk_load/SQL": ["apply.sql"],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_locations": [
"OK_customized_20260413.sql",
"OK_customized_20260416.sql",
"OK_customized_20260210.sql",
"OK_customized_20260317.sql",
"TX.sql",
"template.sql",
"OK_customized_20260506.sql",
"AZ.sql",
"MN.sql",
"OK_customized_20260515.sql",
"OK_customized.sql",
"MS.sql",
"AR.sql",
"OK.sql",
"IN_customized_20260409.sql",
"OK_customized_20260326.sql",
"IN.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage1_subgrantees/SQL": [
"TX.sql",
"XY.sql",
"MN.sql",
"CA.sql",
"VA.sql",
"LA.sql",
"AR.sql",
"OK.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage1_relationships/SQL": [
"rel_address_parcel.sql",
"rel_place_building.sql",
"rel_address_building.sql",
"rel_building_parcel.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/challenger": [
"PA_challenger.sql",
"TX_challenger.sql",
"DC_challenger.sql",
"DE_challenger.sql",
"NV_challenger.sql",
"OK_challenger.sql",
"no_selection.sql",
"XZ_challenger.sql",
"NM_challenger.sql",
"MT_challenger.sql",
"ND_challenger.sql",
"MS_challenger.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/challenges": [
"TX_challenges.sql",
"OR_challenges.sql",
"PA_challenges.sql",
"DC_challenges.sql",
"NY_challenges.sql",
"XZ_challenges_dsl_fw.sql",
"NV_challenges.sql",
"DE_challenges.sql",
"LA_challenges.sql",
"CA_challenges.sql",
"AR_challenges.sql",
"XZ_challenges_no_mod.sql",
"CT_challenges.sql",
"WY_challenges.sql",
"OK_challenges.sql",
"GU_challenges_no_latency.sql",
"no_selection.sql",
"IN_challenges.sql",
"XZ_challenges.sql",
"NJ_challenges.sql",
"OH_challenges.sql",
"NM_challenges.sql",
"HI_challenges.sql",
"MT_challenges.sql",
"AL_challenges.sql",
"MS_challenges.sql",
"NC_challenges.sql",
],
"/home/ubuntu/airflow/dags/subsidy/transfer_to_pg/SQL": ["pg_create_table.sql"],
"/home/ubuntu/airflow/dags/rad/google_alpha_earth/dbt_project/models": [
"schema.yml"
],
"/home/ubuntu/airflow/dags/general/aws_breakfixer/SQL": [
"ALL_SAMPLE_show_create_table.sql"
],
"/home/ubuntu/airflow/dags/mbdr/curate_mbdr/dbt_project/models": [
"c_mbdr_businesses.sql",
"t_ohio_google_locations.sql",
"t_ohio_mbdr_locations.sql",
"c_mbdr_businesses.yml",
"t_ohio_utility_commission.sql",
"t_ohio_frn_providers.sql",
"sources.yml",
],
"/home/ubuntu/airflow/dags/mbdr/get_raw_data/SQL": [
"mbdr_offline_dedup_input.sql",
"mbdr_curated.sql",
"merge_locations.sql",
"mbdr_offline_dedup_llm_input.sql",
"mbdr_ohio_normalization.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/post_challenge_summary": [
"post_challenge_summary.sql"
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage1_ingest_schema/dbt_project/models/mn": [
"c_outbound_spec_mn.sql",
"c_inbound_spec_mn.sql",
],
"/home/ubuntu/airflow/dags/general/test/dbt_test2/dbt_project/models": [
"t_dbt_test003_reference_select.sql",
"t_dbt_test002_source_select.sql",
"t_dbt_test004_loop_select.sql",
"t_dbt_test002_source_select.yml",
"t_dbt_test001_simple_select.sql",
"dbt_schema.yml",
"t_dbt_test005_marco_select.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations/dbt_project/models": [
"schema.yml",
"x_export_nepa_locations.sql",
],
"/home/ubuntu/airflow/dags/bead/export_bead_app_wip/SQL": [
"pg_attachments.sql"
],
"/home/ubuntu/airflow/dags/arc/demo_tenant/seed_customer_tenant/SQL": [
"enum_labels.sql",
"user_fk_columns.sql",
"owned_sequences.sql",
"seed_sets.sql",
"column_compatibility.sql",
"divergence_check.sql",
],
"/home/ubuntu/airflow/dags/proposed_project_areas/curate_ppa_locations/SQL": [
"indiana.sql",
"arkansas.sql",
"mississippi.sql",
"demo_base.sql",
"template.sql",
"texas.sql",
"arizona.sql",
"california.sql",
"pg_c_proposed_project_areas_locations.sql",
"oklahoma.sql",
],
"/home/ubuntu/airflow/dags/general/map_image_generator/json": [
"az_datasme1719_spacex_consolidation.json"
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/rad": [
"x_nc_rad_negotiator_buildings_buncombe.sql",
"x_nc_rad_negotiator_parcels_buncombe.sql",
"x_nc_rad_tiger_fallback_neighbor_dist.sql",
"x_nc_rad_negotiator_addresses_buncombe.sql",
"x_nc_rad_missing_addr.sql",
"x_nc_rad_openaddress_buncombe.sql",
"x_nc_rad_e911_buncombe.sql",
"x_nc_rad_e911_37119.sql",
"x_nc_rad_negotiator_structures_buncombe.sql",
],
"/home/ubuntu/airflow/dags/rad/classifier/stage1_features/SQL": [
"audit_unmapped_usecodes.sql",
"label_distribution.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects/SQL/DeploymentProject": [
"pg_insert.sql",
"load_lake.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage4b_llu_reports/SQL": [
"pg_insert_proof_of_passings.sql",
"pg_preview.sql",
"pg_clone_application_locations.sql",
],
"/home/ubuntu/airflow/dags/general/test/dbt_intro/travis/dbt_project/models/staging/grapi": [
"stg_grapi__permutations.sql"
],
"/home/ubuntu/airflow/dags/cpc/point_in_time_refactor/stage2_load_providers_wip/SQL": [
"1_extract_fcc_providers.sql",
"1_extract_fcc_tech_map.sql",
],
"/home/ubuntu/airflow/dags/sbo/oh/bead_mod/SQL": [
"bizres_comp.sql",
"compare_mod.sql",
"bizres_comp_curate.sql",
],
"/home/ubuntu/airflow/dags/bead/bead_award_map/SQL": ["mississippi.sql"],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/archive_projects/SQL": [
"export_location_summary.sql",
"export_subgrant_agreements.sql",
"close_requests.sql",
"archive_deployment_projects.sql",
"cancel_reminder_jobs.sql",
"resolve.sql",
"export_application_locations.sql",
"_targets.sql",
"preview.sql",
"archive_locations.sql",
"archive_project_rows.sql",
"export_report_chains.sql",
"archive_reports.sql",
"preimage.sql",
"export_projects.sql",
"archive_subgrant_agreements.sql",
"export_requests.sql",
"export_deployment_projects.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage3_address/dbt_project/models": [
"schema.yml",
"t_rad_structures_addressed.sql",
"t_census_addrfeat_25_v1.sql",
"t_rad_addr_candidates_tiger.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects_wip/SQL/ReportingProject": [
"pg_insert.sql",
"pg_update.sql",
"load_lake.sql",
"sync_child_application_owner.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_deployment_projects": [
"OK_customized_20260413.sql",
"TX_applicant.sql",
"OK_customized_20260416.sql",
"OK_customized_20260210.sql",
"OK_customized_20260317.sql",
"TX.sql",
"OK_customized_20260506.sql",
"AZ.sql",
"MN.sql",
"OK_customized_20260515.sql",
"OK_customized.sql",
"MS.sql",
"AR.sql",
"OK.sql",
"IN_customized_20260409.sql",
"OK_customized_20260326.sql",
"IN.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3_outbound_generator/dbt_project/models/staging": [
"stg_application_relations.sql",
"stg_application_po.sql",
"stg_invoice_data_tx.sql",
"stg_application_answers.sql",
"stg_applicant_profiles.sql",
"stg_applications.sql",
],
"/home/ubuntu/airflow/dags/game/ingest_data/SQL/shared": [
"dams.sql",
"electric_utility_territories.sql",
"waterways.sql",
"submarine_cables_coastal.sql",
"fcc_towers.sql",
"roads.sql",
"schools.sql",
"indian_lands.sql",
"health_facilities.sql",
"electric_power_plants.sql",
"railways.sql",
"census_water_areas.sql",
"natural_gas_facilities.sql",
"public_libraries.sql",
"county_demographics.sql",
"electric_grid_equipment.sql",
"submarine_cables_river.sql",
"oil_gas_pipelines.sql",
"counties.sql",
"data_centers.sql",
"oil_gas_wells.sql",
"electric_grid_regions.sql",
"electric_power_lines.sql",
],
"/home/ubuntu/airflow/dags/bead/report_export_ca/dbt_project/models": [
"schema.yml",
"t_bob_ca_day1_technology.sql",
"t_bob_ca_day1_project_summary.sql",
"t_bob_ca_day1_top_num.sql",
"t_bob_ca_day1_project_summary_part_4.sql",
"t_bob_ca_day1_project_summary_part_1.sql",
"t_bob_ca_day1_project_summary_part_3.sql",
"t_bob_ca_day1_county.sql",
"t_bob_ca_day1_project_summary_part_2.sql",
".gitkeep",
"t_bob_ca_day1_finance.sql",
"t_bob_ca_day1_top_funding.sql",
"t_bob_ca_day1_top_bsls.sql",
"t_bob_ca_day1_application_answers.sql",
"t_bob_ca_day1_provider_type.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations/SQL/n_to_m": [
"cai_ReportingProject.sql",
"bsl_ReportingProject.sql",
"cai_ReportingProject_CA.sql",
"cai_ReportingProject_VA.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage9_backfill_final_proposal/SQL/ApplicationLocation": [
"pg_delete_ms.sql",
"pg_delete_ok.sql",
"pg_delete.sql",
"pg_update_ok.sql",
"pg_insert_ok.sql",
"load_lake_az.sql",
"check_delta.sql",
"pg_upsert.sql",
"load_lake_ms.sql",
"load_lake_ok.sql",
"load_lake.sql",
"pg_delete_az.sql",
"load_lake_ok_test.sql",
"load_lake_ok_int.sql",
],
"/home/ubuntu/airflow/dags/cpc/point_in_time_refactor/stage1_create_schema/SQL": [
"1_load_fcc_ffa_tech_map.sql",
"0_create_tables.sql",
"1_load_fcc_fabric_addresses.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage0_clean/SQL": [
"address_units.sql",
"flag_subparcels.sql",
"clean_parcels.sql",
"clean_places.sql",
"clean_buildings.sql",
"clean_addresses.sql",
"excluded_addresses.sql",
"excluded_parcels.sql",
],
"/home/ubuntu/airflow/dags/funding_cpc/update/ms/SQL": [
"update_location_id.sql",
"bip_update_geoid.sql",
"melt_cpf_table.sql",
"bip_union_three.sql",
"create_stage_table.sql",
"bip_update_franklin_loc_id.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/sga_dp_migration/SQL": [
"verification_after.sql",
"verification_before.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3_outbound_generator/dbt_project/models/intermediate": [
"int_latest_reimbursements.sql",
"int_eligible_requests.sql",
"int_reimbursement_versions.sql",
"int_request_details.sql",
],
"/home/ubuntu/airflow/dags/redshift/cdc/register_spectrum_table/SQL": [
"create_external_table.sql"
],
"/home/ubuntu/airflow/dags/redshift/dag_trigger_scheduler/SQL": [
"seed_pg_to_redshift_tables.sql",
"create_tables.sql",
"mark_triggered.sql",
"claim_items_batch.sql",
"mark_completed.sql",
"find_due_items.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage0_clean/dbt_project/models": [
"schema.yml",
"t_rad_excluded_addresses.sql",
"t_rad_address_units.sql",
"r_rad_parcels_negotiator.sql",
"r_rad_places_negotiator.sql",
"t_rad_excluded_parcels.sql",
"c_rad_addresses_negotiator.sql",
"r_rad_addresses_negotiator.sql",
"r_rad_buildings_negotiator.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage1_ingest_schema/dbt_project/models/tx": [
"c_outbound_spec_tx.sql",
"c_inbound_spec_tx.sql",
],
"/home/ubuntu/airflow/dags/suitability/ms_hypercube/01_ingest/hrsa/SQL": [
"county_curate.sql"
],
"/home/ubuntu/airflow/dags/suitability/ms_hypercube/01_ingest/cdc_places/SQL": [
"county_curate.sql"
],
"/home/ubuntu/airflow/dags/general/s3_geofile_to_athena/json": [
"ca_rail_road_network_highway_rail_crossings.json",
"ca_rail_road_network_california_rail_network.json",
"tx_congressional_district_house.json",
"tx_congressional_district_house_20251201.json",
"ca_state_highway_network_lines.json",
"ca_senate_boundaries_2022.json",
"ca_assembly_boundaries_2022.json",
"ca_cpuc_high_cost.json",
"tx_congressional_district_senate.json",
"tx_congressional_district_senate_20251201.json",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects_wip/SQL/DeploymentProject": [
"pg_insert.sql",
"pg_update.sql",
"load_lake.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter/SQL": [
"AR_CUST-4133-cai-outliers.sql",
"AR_DATASME-1258.sql",
"VA_DATASME_1408.sql",
"CA_DATASME-849_application_summary.sql",
"MS_CUST-2399_CPF_ffa_04122023.sql",
"CA_DATASME-849_project_summary_part1.sql",
"NC_DATASME-738_public_bsl_challenges.sql",
"PA_CUST-847.sql",
"TX_CUST-2990_Unserved.sql",
"MS_DATASME-1023.sql",
"LA_DATASME_1155_22085.sql",
"LA_DATASME_1155_22091.sql",
"AR_DATASME-1099_bsl_paf_mapping.sql",
"IN_services_status_v4.sql",
"LA_CUST-2439_gumbo2_bsls_spa_id.sql",
"CA_CUST_2255_E.sql",
"MS_CUST-2399_CPF_application_eligible_location_fabric_v3_ms.sql",
"AZ_DATASME-990-exactmap.sql",
"CA_DATASEME_1279.sql",
"LA_CUST-3438.sql",
"MS_DATASME-1234.sql",
"MS_DATASME-1125-p2.sql",
"LA_DATASME_1155_22053.sql",
"LA_DATASME_1155_22047.sql",
"OK_DATASME-1138.sql",
"MS-CUST-110.sql",
"LA_CUST-2110_fp_locations_archive.sql",
"NY_post_challenge_summary.sql",
"LA_DATASME_1155_22127.sql",
"OK_DATASME-1064.sql",
"OK_DATASME-595-latlon-add-google.sql",
"LA_CUST-2447_pending_alt_tech.sql",
"OK_CUST-3597_changelog.sql",
"NY_CUST-2127.sql",
"LA_ARC_83.sql",
"IN_CPC-430.sql",
"XZ_BEAD_VERIFICATION.sql",
"OK_CUST-1214.sql",
"OH-CUST-165-Fiber.sql",
"OK_DATASME-595.sql",
"NC_CUST-817_served_funded.sql",
"AR_CUST-2984.sql",
"CA_DATASME-849_project_summary_part2.sql",
"LA_DATASME_1155_22119.sql",
"TX_DATASME-900.sql",
"TX_DATASME-971-delta.sql",
"LA_DATASME_1155_22125.sql",
"TX_DATASME_fp_location_temp.sql",
"TX_DATASME-2.sql",
"MN_DATASME-1053_overlaps_round_2.sql",
"TX_DATASME-739-update-pre-challenge-cai.sql",
"IN_DATASME-1060_pg_application_count_by_provider.sql",
"LA_DATASME_1155_22079.sql",
"LA_DATASME_1155_22051.sql",
"PA_CUST-918.sql",
"TX_DATASME-739-no-challenges.sql",
"LA_DATASME_1155_22045.sql",
"MS_DATASME-1006_fabric_fixed_availability_v59.sql",
"MS_CUST_1454.sql",
"PA_county-summary.sql",
"TX_DATASME_842_missing_bsl.sql",
"OK_CUST-3563.sql",
"CA_DATASME-999_not_applied_STAGE.sql",
"NC_DATASME-738_public_cai_challenges.sql",
"LA_CUST-1280_building_type.sql",
"OK_DATASME-991_eligible_locations.sql",
"TX_DATASME-1328_location.sql",
"MS_DATASME-1125-p1.sql",
"LA_CUST-2533.sql",
"LA_DATASME_1155_22087.sql",
"LA_DATASME_1155_22093.sql",
"MS_CUST-1859_CPFProject_pg.sql",
"AR_CUST_707.sql",
"OK_CUST-106.sql",
"LA_CUST-2110_fp_deployment_projects.sql",
"OK_DATASME-802-unserved.sql",
"OK_DATASME-999.sql",
"CA_DATASME-849_project_summary_part3.sql",
"CA_DATASME-1186_pg.sql",
"AZ_CUST-3479b.sql",
"MS_CUST-2399_cpf_prelim_awarded_locations.sql",
"TX_DATASME_842_remaining_cais.sql",
"CA-update_cbg.sql",
"AZ_DATASME-990.sql",
"OR_post_challenge_classification_change.sql",
"NC_DATASME-738_public_challengers.sql",
"LA_DATASME-1113.sql",
"IN_DATASME-814_cais.sql",
"CA_DATASME-1209_pg.sql",
"CA-DSL-Cellular.sql",
"OH_CUST-1228.sql",
"CA-CUST-267-underserved.sql",
"AZ_DATASME-1135.sql",
"OK_DATASME-915-ulfw-v6.sql",
"LA_CUST-1280_land_use_code.sql",
"CA_DATASME-849_top_applicants_by_funding.sql",
"LA_DATASME_1155_22097.sql",
"LA_DATASME_1155_22083.sql",
"TX_CUST-2656.sql",
"GU_DATASME-736_Case1.sql",
"MN_DATASME-817_overlaps.sql",
"IN_services_status_v3.sql",
"LA_DATASME_1155_22069.sql",
"ND-CUST-1913.sql",
"AR_DATASME-973-replicate-bcg.sql",
"IN_DATASME-1062.sql",
"TX_DATASME-739-cai-location_id.sql",
"LA_DATASME_1155_22055.sql",
"MS_DATASME-957_indicated_rate.sql",
"XZ-post-challenge_summary.sql",
"OK_DATASME_1094_cai.sql",
"TX_APPSME-1958.sql",
"AR_CUST_1628.sql",
"LA_DATASME_1155_22109.sql",
"AR_DATASME-820.sql",
"MS_ARC_799_all.sql",
"CA_DATASME-999_excluded_STAGE.sql",
"AZ_DATASME-1134.sql",
"LA_DATASME_1155_22121.sql",
"MS_CUST-4021_indicated.sql",
"CA_DATASME-1018.sql",
"OK_DATASME_1094_bsl.sql",
"LA-CUST-2137-NOT-GUMBO.sql",
"OK_DATASME-915-ulfw.sql",
"CA-DSL-Cellular-CAI-dedup-casf.sql",
"MS_fp_no_bead_locations_09_2_export.sql",
"XZ_fabric_change.sql",
"GU_DATASME-943_v6removed.sql",
"CA_DATASME-1141_pg.sql",
"NY-CPC-1311.sql",
"OH-CUST-165-Cable.sql",
"PA_post_challenge_summary_challenge_types.sql",
"MS_DATASME-914_indicated.sql",
"LA_DATASME_1155_22123.sql",
"IN_DATASME-929.sql",
"OK_CUST-2519.sql",
"CA_DATASME-999_excluded.sql",
"OR_dsl_mod_classification.sql",
"CA_CUST_2477_full_cai.sql",
"OH-CUST-173-ORBEG.sql",
"TX_DATASME-899.sql",
"AR_DATASME-1103.sql",
"ND_CPC-532.sql",
"LA_DATASME_1155_22043.sql",
"TX_CUST-2641.sql",
"LA_DATASME_1155_22057.sql",
"TX_DATASME-668-latency-check.sql",
"CA-CUST-267-cai.sql",
"OK_DATASME_FP_1455_cai_evaluation.sql",
"OK_DATASME-802-underserved.sql",
"TX_DATASME-918_with_speedranks.sql",
"OR_dsl_mod_impact.sql",
"CA_DATASME-860_application_locations.sql",
"IN_CPC-470_fce0.sql",
"GU_DATASME-736_Case2.sql",
"IN_DATASME-814_locations.sql",
"MS_CUST-1374.sql",
"AR_DATASME-1116.sql",
"LA_DATASME_1155_22095.sql",
"NY-CUST-1995.sql",
"LA_DATASME_1155_22081.sql",
"MS_DATASME-956_cai.sql",
"LA_CUST-2502_location_type_breakdown.sql",
"OH-CUST-171-DSL-Cellular-Busi-CAI.sql",
"ZX_TEST_001.sql",
"OK_CUST-2915.sql",
"AR_DATASME_1050.sql",
"MN_DATASME-1218_recent_updates.sql",
"CA_DATASME-1054.sql",
"MS_DATASME-1108.sql",
"TX_DATASME-867-bsl.sql",
"OH_CUST-1122-c5.sql",
"AR_post_challenge_validation.sql",
"IN_DATASME-1172.sql",
"LA_DATASME_1155_22019.sql",
"LA_DATASME_1155_22025.sql",
"LA_DATASME_1155_22031.sql",
"CA_DATASME-999_not_applied.sql",
"TX_DATASME-867-cai.sql",
"TX_DATASME-1156.sql",
"IN_CUST-3299-coverage.sql",
"TX_DATASME-739-no-deduplication.sql",
"MS_CUST-1845.sql",
"LA_DATASME_888_CD6.sql",
"AZ_DATASME-880.sql",
"VA_DATASME_1254_r_vaup_fp_reporting_projects.sql",
"TX_CUST-2632.sql",
"MS_DATASME-996_all.sql",
"CA_DATASME-849_applicant_type_report.sql",
"OK_CUST-4130-loc-cai-overlap.sql",
"OH_CUST-1122-c4.sql",
"NH_post_challenge_summary.sql",
"NM_bead_post_challenge_verification.sql",
"MS-CUST-1293-survey.sql",
"MS_DATASME-996_part_of_applicaton_true.sql",
"ND_post_challenge_summary.sql",
"OH_CUST-2221.sql",
"OH_CUST_2706.sql",
"CA_DATASME-849_county_report.sql",
"CA_CUST_2477_full_challenges.sql",
"TX_CUST-4096_1_general.sql",
"PA_post_challenge_summary_funding.sql",
"IN_DATASME-1060_pg_full_impacted_locations.sql",
"MS_CUST-2399_CPF_application_eligible_location_fabric_v5_ms.sql",
"LA_DATASME_1155_franklin.sql",
"GU_CUST-2648.sql",
"MS_DATASME-813.sql",
"CA_DATASME_1162.sql",
"LA_DATASME_888_CD4.sql",
"CA_DATASME-849_provider_type.sql",
"CA_DATASME-818_pg.sql",
"LA_DATASME_888_CD5.sql",
"LA_DATASME_1155_22027.sql",
"LA_DATASME_1155_22033.sql",
"LA_DATASME_1155_tammany.sql",
"MN_DATASME-1058_organization_details_report.sql",
"TX_CUST-4096_2_time_applicant.sql",
"MS_CUST-2036.sql",
"TX_DATASME-1236_pg.sql",
"IN_CUST-3299-provider.sql",
"CA_DATASME-999_not_applied_no_prelim.sql",
"IN-CUST-2997.sql",
"CA-CUST-267-served.sql",
"AR_DATASME-1211.sql",
"CA_DATASME-1095.sql",
"TX_DATASME-1024_application_locations_bsl.sql",
"MS_DATASME-1324.sql",
"ND_CUST-1197.sql",
"AR_DATA_1654.sql",
"OR_post_challenge_summary.sql",
"OK_CUST-1624_indian_electric_coop.sql",
"CA_DATASME-849_top_applicants_by_num.sql",
"CA_CUST-3105_served.sql",
"CA_CUST_2477.sql",
"TX_CUST-2990_Underserved.sql",
"LA_DATASME_1155_tensas.sql",
"AR_DATASME-933-export2.sql",
"LA_DATASME_1155_22037.sql",
"MS_CUST-1859_CPF1BroadbandinfrasturctureLocationData_pg.sql",
"LA_DATASME_1155_22023.sql",
"TX_DATASME-1024_application_locations_cai.sql",
"LA_DATASME_888_CD1.sql",
"AR_PLAT-65.sql",
"TX_CUST-4096_3_time_dist_applicant.sql",
"AZ_DATASME-893.sql",
"OK_bead_post_challenge_verification.sql",
"OH-CUST_postchallenge-qa.sql",
"TX_DATASME-1150.sql",
"IN_CUST_2319_defaul_mercury_fiber.sql",
"MN_DATASME-1058_deconfliction_report.sql",
"AR_DATASME_1130_pg.sql",
"NM_CPC-544.sql",
"MS_CUST-3004-removed-bip-from-dedup.sql",
"MS_unserved_underserved_cpf.sql",
"CA_CUST-1404_pg_10a.sql",
"CA_DATASME-999_applied_STAGE.sql",
"OH_CPC-540-unserved.sql",
"IN_APPSME-1900.sql",
"TX_DATASME-971-ppa-summary.sql",
"CA_CUST-3105_underserved.sql",
"MS_DATASME-351_TreasuryTemplate_pg.sql",
"OK_DATASME-1015.sql",
"MS_DATASME-1127.sql",
"TX_CUST-4096_4_application_submission.sql",
"CA-DSL-Cellular-CAI.sql",
"TX_DATASME-668-post_challenge_validation.sql",
"AR_DATASME-789_applicantXlocation_pg.sql",
"LA_CUST-3501.sql",
"AR_DATA-1628.sql",
"NY-CPC-541.sql",
"OK_DATASME_FP_1472_application_to_add.sql",
"AZ_DATASME-990b.sql",
"MS_DATASME-1131.sql",
"TX_CUST-2641-b.sql",
"TX_DATASME-971.sql",
"TX_DATASME-1231.sql",
"AR_DATASME-933-export1.sql",
"CA_CUST_2354_casf.sql",
"LA_DATASME_888_CD2.sql",
"MS_DATASME-1291.sql",
"TX_DATASME-1152.sql",
"OK_DATASME-595-latlon.sql",
"TX_DATASME-1177_application_locations_bsl_split.sql",
"MS_DATASME-1006_rate_review.sql",
"LA_DATASME_888_CD3.sql",
"LA_DATASME_1155_22009.sql",
"CA_DATASME_1075_application_attachment_question_mapping.sql",
"CA_CUST-1404_pg_10b.sql",
"LA_DATASME_1155_22021.sql",
"MS_DATASME-854-cai.sql",
"TX_CUST-3664_awardee_name_match.sql",
"OH_CPC-540-served.sql",
"LA_CPC-406.sql",
"MN_DATASME-817_scores.sql",
"PA_post_challenge_summary.sql",
"TX_DATASME-757.sql",
"TX_DATASME-899b.sql",
"WY_post_challenge_summary.sql",
"CA_DATASME-999_excluded_no_prelim.sql",
"AR_DATASME-1203.sql",
"CA-CUST-267-funded.sql",
"CA_DATASME-849_equity_report.sql",
"MS-CUST-3441.sql",
"ZX_CUST-3484b.sql",
"PA_post_challenge_cai.sql",
"MN_DATASME-1058_final_proposal_report.sql",
"IN_DATASME-1147.sql",
"OK_DATASME-1153.sql",
"LA_CUST-2110_fp_subgrantees.sql",
"CA-CUST-267-unserved.sql",
"LA_ARC-818_applicants.sql",
"MS_DATASME-956_underserved.sql",
"AR_DATASME-1122_pg.sql",
"CA_DATASME-869_application_pau.sql",
"AR_DATASME-931_adjusted_v6ffa_served.sql",
"OK_DATASME-746-challenges-ffa31.sql",
"MN_DATASME_1055_application_attachment_question_mapping.sql",
"CA_DATASME-849_finance_report.sql",
"TX_DATASME-1177_application_locations_cai.sql",
"MS_CUST-2399_BCI_objection.sql",
"MS_CUST-1708-challenge-locations.sql",
"LA_DATASME_1155_22011.sql",
"LA_DATASME_1155_22005.sql",
"LA_DATASME_1155_22039.sql",
"OK_DATASME-991_cais_with_net_id.sql",
"NC_CUST-2872.sql",
"AR_APP_1817_2.sql",
"OK_DATA-1573-application_ranking.sql",
"TX_DATASME-1177_application_locations_bsl.sql",
"TX_DATASME-767.sql",
"OH_CUST-2770.sql",
"OH-CUST-167-DSL-mod.sql",
"TX_CUST-2595_pre_challenge_comparison.sql",
"LA_ARC_127.sql",
"CA_DATASME-1269_pg.sql",
"WY_CUST-2084.sql",
"LA_CUST-2110_fp_locations.sql",
"MS_locations_for_david.sql",
"OR_pre_challenge_post_challenge_update.sql",
"IN_DATASME-1144.sql",
"MS_DATASME-854-funded-served.sql",
"CA_CUST-1404_pg_7.sql",
"LA_DATASME_1155_22013.sql",
"IN_CPC-470_bc0d.sql",
"TX_CUST-2611.sql",
"LA_DATASME_1155_22007.sql",
"MS_DATASME-1274.sql",
"GU_DATASME-1067.sql",
"MS_CUST-4021_served.sql",
"OK_DATASME-746-challenges-ffa33.sql",
"OK_CUST-1624_dobson_fiber_rogers.sql",
"MN_DATASME-817_locations.sql",
"CA_CUST-3105_unserved.sql",
"MS_CUST-1708-applicant.sql",
"OK_DATASME-991_eligible_bsl_with_net_id.sql",
"AR_DATASME-931_v6removed.sql",
"OH-CUST-169-DSL-Cellular-mod.sql",
"AZ_CUST-3479.sql",
"AR_DATASME_1339.sql",
"CA_CUST-1404_pg_6.sql",
"AR_APP_1817_1.sql",
"XZ_CUST_3295.sql",
"AR_CUST-2494-cai-challenge.sql",
"OH_CPC-540-cai.sql",
"GU_DATASME-774.sql",
"MS_DATASME-956_served.sql",
"LA_DATASME-1155.sql",
"CA_DATASME-922-v6.sql",
"MS_DATASME-1315.sql",
"CA_CUST-1404_1.sql",
"AZ_CUST-3079.sql",
"CA_post_cai_validation.sql",
"IN_post_challenge_summary.sql",
"TX_CUST-2861_p3.sql",
"GU_CUST-2985_part3.sql",
"OK_CUST-2996.sql",
"OK_DATASME_1438_cost_per_net.sql",
"CA_CUST_1797_postchallenge_E.sql",
"OR_dsl_mod_typeA_ffa.sql",
"AZ_CUST-3509.sql",
"CA_DATASME-999_applied.sql",
"TX_DATASME-739-update-pre-challenge-cai-formatted.sql",
"IN_DATASME-954.sql",
"AR_DATASME-931_aristotle.sql",
"MS_DATASME-837.sql",
"CA_CUST-1404_pg_2.sql",
"AR_DATA_1701.sql",
"MS_DATASME-1136_unserved.sql",
"OR_CUST-1878_pre_challenge_dsl_mod.sql",
"AR_CUST_1694.sql",
"IN_CUST-3276.sql",
"MS_fp_no_bead_locations_09_22.sql",
"TX_DATASME-833.sql",
"AR_DATASME-1181.sql",
"CA_DATASME-849_top_applicants_by_bsls.sql",
"MS-CUST-1330.sql",
"MS_DATASME-854-unserved.sql",
"OK_DATASME_1438_other_locs_add.sql",
"TX_DATASME-971-bsl.sql",
"AZ_DATASME-1027_application_export.sql",
"AR_CUST_783.sql",
"LA_DATASME_1155_22003.sql",
"LA_DATASME_1155_22017.sql",
"TX_DATASME-1084_pg.sql",
"LA_CUST_3373.sql",
"LA_CUST-2439_gumbo2_bsls_spa_id_post_pit_check.sql",
"CA_CUST-1404_pg_3.sql",
"TX_DATASME-971-cai.sql",
"LA_DATASME-1352.sql",
"OH-CUST-173-DSL-Cellular-Busi-CAI-dedup-orbeg.sql",
"CA-DSL-Cellular-CAI-dedup.sql",
"CA_DATASME-922.sql",
"MS_CUST-3161-bip-funded-kmz.sql",
"MN_DATASME-825.sql",
"AR_DATASME-1109_comp.sql",
"GU_CUST-2985_part2.sql",
"TX_CUST-2861_p2.sql",
"AR_CUST-2494-location-ls.sql",
"MS_DATASME-956_indicated.sql",
"VA_DATASME_1254_r_vaup_fp_rp_locations.sql",
"CA-Explain-Delta.sql",
"OH_CUST-2606-cai.sql",
"OK_DATASME-1196_fp_cai.sql",
"OK_CUST-1734.sql",
"LA_CUST-2110_fp_cai.sql",
"IN_DATASME-822-no-application.sql",
"LA_DATASME_1155_22001.sql",
"LA_DATASME_1155_22015.sql",
"AR_DATASME-1182.sql",
"ZX_CUST-3484.sql",
"LA_DATASME_1155_22029.sql",
"CA_APPSME-1571.sql",
"AZ_DATASME-1057_pg.sql",
"TX_DATASME-1199.sql",
"MS_CUST-4021_funded.sql",
"TX_DATASME-971-pau.sql",
"AR_DATASME-1394.sql",
"VA_DATASME_1254_r_vaup_fp_rp_cai.sql",
"MN_DATASME-1058_application_export.sql",
"TX_DATASME-781_idtofile.sql",
"LA_CUST-2110_fp_cai_all_location_ids.sql",
"IN_CPC-501.sql",
"AR_DATASME-1099_v6_removed.sql",
"IN_DATASME-822.sql",
"AR_CUST_1696.sql",
"DATA_CHALLENGE_50.sql",
"TX_DATASME-1106_pg.sql",
"CA_DATASME-999_applied_no_prelim.sql",
"TX_APPSME-1931.sql",
"TX_DATASME-775-CAI.sql",
"CA-CAI-verification.sql",
"MS_DATASME-914_removed.sql",
"MS_DATASME_1017_application_attachment_question_mapping.sql",
"OH_CUST-2946.sql",
"CA-DSL.sql",
"LA-CUST-2137-GUMBO-only.sql",
"MS_DATASME-956_unserved.sql",
"MS_DATASME-1105.sql",
"AZ_CUST-3523.sql",
"AR_DATASME-1103-mismatches.sql",
"MS_DATASME-956_funded.sql",
"AR_DATASME-1008.sql",
"TX_DATASME-1024_application_locations_bsl_split.sql",
"TX_DATASME-1328_stats.sql",
"GU_CUST-2985_part1.sql",
"TX_DATASME-775-BSL.sql",
"AZ_CUST-3047.sql",
"OK_CUST-1624_dobson_fiber_osage.sql",
"TX_CUST-2861_p1.sql",
"TX_DATASME-1011_application_calculated.sql",
"CA_CUST-2477-CWF_MOD_VERIZON.sql",
"OK_DATASME-746-post-challenge-location-ffa33.sql",
"AR_DATA-1692.sql",
"OH-CUST-171-DSL-Cellular-Busi.sql",
"TX_DATASME-739.sql",
"MS_CUST-3690-supervisor-district-counts.sql",
"VA_DATASME_1254_locations.sql",
"CA_DATASME-819_pg.sql",
"OK_POLSME-25.sql",
"LA_DATASME_1155_22113.sql",
"CA_CUST_2399_QA.sql",
"OH-CUST-165-FW.sql",
"LA_DATASME_1155_22067.sql",
"LA_DATASME_1155_22073.sql",
"OH_CPC-540-underserved.sql",
"MS_CUST-4021_cai.sql",
"GU_DATASME-943_adjusted_v6ffa_eligible.sql",
"NC_DATASME-921.sql",
"MS_CUST-1859_CPFSubrecipientTemplate_pg.sql",
"OK_CUST-3597.sql",
"AZ_CUST-2934.sql",
"MS_CUST-1708-public-comment.sql",
"IN_DATASME-850.sql",
"LA_CUST-1280_cais.sql",
"OK_DATASME-740_changelog.sql",
"AR_DATASME_933_2.sql",
"LA_DATASME_1155_22099.sql",
"CA_DATASME_1056.sql",
"OK_DATASME-1079.sql",
"CA_DATASME-849_project_report.sql",
"CA_CUST_2354.sql",
"CA_CUST-2856.sql",
"CA_CUST-1404_pg_5b.sql",
"VA_ARC_436_projects.sql",
"OH-CUST-165-Copper.sql",
"LA_CUST-3223.sql",
"GU_CUST-3138.sql",
"LA_CUST-2502_awards_made.sql",
"MS_CUST_2317_county.sql",
"CA_DATASME-1263_pg.sql",
"TX-CUST-1948.sql",
"NY_CUST-986.sql",
"CA_CUST-3545.sql",
"TX_DATASME-1249.sql",
"MS_DATASME_1256.sql",
"TX_DATASME-882.sql",
"VA_ARC_436_companies.sql",
"CA_DATASME-1312_pg.sql",
"CA_DATASME-849_technology_report.sql",
"OH-data-summary.sql",
"CA-CUST-267-allbsl.sql",
"OK_CUST-1744_pg.sql",
"TX_CUST-2990_challenge_portal_export.sql",
"LA_CUST-2110_fp_locations_all_field.sql",
"LA_CUST-1219.sql",
"LA_DATASME_1155_22065.sql",
"LA_DATASME_1155_22071.sql",
"LA_DATASME_1155_22059.sql",
"OH-CUST-165-LBRFW.sql",
"AR_DATASME_933_1.sql",
"TX_CUST-2990_Served.sql",
"MT_CPC-462-bsl.sql",
"AZ_DATASME-795_pg.sql",
"VA_ARC_436_users.sql",
"LA_DATASME_1155_22111.sql",
"LA_DATASME_1155_22105.sql",
"LA_DATASME-1320.sql",
"OK_CUST-2915_num.sql",
"MS_DATASME-1136_underserved.sql",
"TX_CUST-3425.sql",
"VA_DATASME_1254_cai.sql",
"CA_DATASME-849A_overlapping_paus.sql",
"AZ_DATASME_1390.sql",
"OH-ORGEB_mapping.sql",
"AR_DATASME-789_cost_per_loc_pg.sql",
"CA_CUST-1404_pg_5a.sql",
"CA_DATASME-1210_eligible_ppas.sql",
"OK_DATASME-902_pg.sql",
"MT_CPC-462-cai.sql",
"CA_CUST-3604-missing.sql",
"OR_CUST-1878.sql",
"MS_DATASME-1404.sql",
"MS_DATASME-854-underserved.sql",
"OK_DATASME-915-v6.sql",
"CA_CUST-1404_pg_4a.sql",
"CA_post_challenge_validation.sql",
"IN_CPC-399.sql",
"MN_DATASME-1053_locations_round_2.sql",
"AZ_DATASME-966.sql",
"OH-CUST-173-DSL-Cellular-Busi-CAI-dedup.sql",
"TX_DATASME_842_PAU_05102025_cai.sql",
"LA_DATASME_1155_22101.sql",
"LA_DATASME_1155_22115.sql",
"CA_CUST-3554.sql",
"TX_DATASME-918.sql",
"CA_DATASME-886_all_bsl_pau.sql",
"IN_DATASME-1081.sql",
"AR_DATASME-1109.sql",
"LA_DATASME_1155_east_caroll.sql",
"MS_CUST-1708-challenge-evidence.sql",
"AR_CUST-2494-challenge.sql",
"LA_DATASME_1155_22075.sql",
"LA_DATASME_1155_22061.sql",
"CA_DATASME-1054_2.sql",
"LA_DATASME_1155_22049.sql",
"OK_CUST-2856.sql",
"TX_DATASME_842_PAU_05102025_bsl.sql",
"AR_CUST_1628_bcg_followup.sql",
"LA_CUST-2502_funding_amount.sql",
"AR_CUST_2843.sql",
"MN_DATASME_1205.sql",
"CA_CUST-3545a.sql",
"AR_CUST_1628_2nd_round.sql",
"LA_CUST-2439_gumbo2_bsls.sql",
"OR-CUST-1110.sql",
"MN_DATASME-1053_scores_round_2_initial.sql",
"CA_DATASME-1091_pg.sql",
"MS-CUST-1293-data.sql",
"MS_CUST-4021_unserved.sql",
"AZ_DATASME-990-verify.sql",
"CA_CUST-1404_pg_4b.sql",
"MS_CUST-4021_underserved.sql",
"OK_CPF_application.sql",
"CA-CAI-BSL.sql",
"LA_DATASME-1333.sql",
"NC_CUST-2020.sql",
"LA_DATASME-993.sql",
"OR_pre_challenge_non_cai_status.sql",
"MS-CUST-109.sql",
"MS_CUST-3161-bip-dedup-kmz.sql",
"NY_post_challenge_version_integrity_check.sql",
"LA_DATASME_1155_22089.sql",
"AR_DATASME-793.sql",
"OK_CUST-4133-cai-additional.sql",
"OR_raw_fabric_fixed_availability_4-16-24.sql",
"OR-CUST-1110_validation_by_location_id.sql",
"MS_DATASME-854-served.sql",
"OK_DATASME-740_202503_revert_funding.sql",
"TX_DATASME_842_PAU_05102025_combined.sql",
"OK_CUST-2883.sql",
"CA_CUST-2435-CASF_additional.sql",
"OK_CUST-1178.sql",
"MS-CUST-2033-MBI.sql",
"MN_DATASME-1053_scores_round_2_modified.sql",
"LA_DATASME_1155_22077.sql",
"LA_DATASME_1155_22063.sql",
"AZ_CUST-3434.sql",
"IN_DATASME-1083.sql",
"TX_CUST-2990_Funded.sql",
"XZ_DATASME-856_all_providers.sql",
"AR_CUST-4133-cai-qa.sql",
"LA_DATASME_1155_22117.sql",
"PA-CUST-544-challenges.sql",
"TX_APPSME-1931-applications.sql",
"OK_DATASME-1256.sql",
"AZ_DATASME-890-delta.sql",
"MS_DATASME-1364.sql",
"IN_CPC-470_10f6.sql",
"OK_DATASME-746-post-challenge-location_ffa31.sql",
],
"/home/ubuntu/airflow/dags/rad/address/e911/ingest_fl/dbt_project/models": [
"t_e911_fl.sql",
"sources.yml",
],
"/home/ubuntu/airflow/dags/general/test/shaoying_dbt_project/dbt_project/models": [
"select_cross_db.sql",
"test_run_cross_db.sql",
],
"/home/ubuntu/airflow/dags/general/test/dbt_intro/travis/dbt_project/models/staging/athena": [
"stg_athena__permutations.sql"
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/xz": [
"x_xz_datasme1500_nepa_project_locations.sql",
"x_xz_datasme2027_fabric_churn_summary.sql",
"x_xz_datasme2058_bead15_loc_funded.sql",
"x_xz_datasme2058_bead15_loc.sql",
"x_xz_all_potential_dup_applicants.sql",
"x_xz_datasme1568.sql",
"x_xz_datasme2058_bead15.sql",
"x_xz_datasme2027_fabric_churn_locations.sql",
"x_xz_default_query.sql",
"x_xz_datasme2027_fabric_churn_all_locations.sql",
"x_xz_datasme2027_fabric_coverage.sql",
],
"/home/ubuntu/airflow/dags/rad/address/e911/ingest/dbt_project/models": [
"t_e911_nc.sql",
"t_e911_or.sql",
"sources.yml",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage1_relationships/dbt_project/models": [
"schema.yml",
"t_rad_rel_place_building.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/challenge_rebuttal_summary": [
"CA_challenge_rebuttal.sql",
"XZ_challenge_rebuttal.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/la": [
"x_la_datasme_1533_funding_awardees.sql"
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3b_outbound_summary/dbt_project/models": [
"schema.yml",
"sources.yml",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/breakfix/fix_missing_app_answer/SQL": [
"reporting_project_answers.sql"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/fp_grapi_cleanup/SQL/lookups": [
"get_child_apps.sql",
"get_target_apps.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/post_challenge_table": [
"no_selection.sql",
"XZ_post_challenge_table.sql",
],
"/home/ubuntu/airflow/dags/suitability/ms_hypercube/03_composite/dbt_project/models/ms_hyper/curated": [
"ms_hyper_suitability_scores.sql",
"ms_hyper_county_suitability.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage1_ingest_schema/dbt_project/models/az": [
"c_outbound_spec_az.sql",
"c_inbound_spec_az.sql",
],
"/home/ubuntu/airflow/dags/regrid/sql": [
"buildings_footprints_unload.sql",
"buildings_tile_partition.sql",
],
"/home/ubuntu/airflow/dags/arc/tenant/mock_subgrantee/SQL": [
"locations_by_id.sql",
"remove.sql",
"pit_permutations.sql",
"verify.sql",
"sample_cais.sql",
"remove_scope.sql",
"availability.sql",
"sample_locations.sql",
"cais_by_id.sql",
"collisions.sql",
],
"/home/ubuntu/airflow/dags/bbm/audit/SQL": [
"create_table_c_bbm_audit_in_pg.sql",
"t_bbm_audit_ffa_stats_tribal.sql",
"t_bbm_audit_location_census_v3.sql",
"tile_cai_poi.sql",
"t_bbm_audit_ffa_stats_tract.sql",
"t_bbm_audit_ffa_stats_county.sql",
"t_bbm_audit_location_census_v4.sql",
"t_bbm_audit_demographics_county_place_aiannh_consity_tract.sql",
"t_bbm_audit_ffa_stats_state.sql",
"t_bbm_audit_fa_stats_v3.sql",
"t_bbm_audit_location_tract_v3.sql",
"t_bbm_audit_location_cb10_v3.sql",
"t_bbm_audit_fa_stats_v4.sql",
"c_bbm_audit_city.sql",
"t_bbm_audit_demographics_state_bg_cb.sql",
"t_bbm_audit_location_cb_v4.sql",
"c_bbm_audit_county.sql",
"c_bbm_audit_tract.sql",
"c_bbm_audit_tribal.sql",
"t_bbm_audit_cpc.sql",
"t_bbm_audit_location_cb_v3.sql",
"c_bbm_audit_state.sql",
"t_bbm_audit_ffa_stats_cb.sql",
"c_bbm_audit_cb.sql",
"t_bbm_audit_ffa_stats_city.sql",
"t_bbm_audit_cai.sql",
],
"/home/ubuntu/airflow/dags/general/data_summary/bead_allocation/SQL": [
"select_unserved_loc.sql",
"merge_staging.sql",
"summarize_unserved_archive.sql",
"unserved_unfunded_pg_state.sql",
"unserved_unfunded.sql",
"unserved_unfunded_pg.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/fp_grapi_cleanup/SQL/count": [
"applicant.sql",
"application_location_answer.sql",
"application_request.sql",
"application_relation.sql",
"permit_application.sql",
"application_request_revision.sql",
"application.sql",
"child_application.sql",
"application_location.sql",
"application_answer.sql",
"application_activity.sql",
],
"/home/ubuntu/airflow/dags/digital_equity/places_health/publish/SQL": [
"pg_c_places_health.sql"
],
"/home/ubuntu/airflow/dags/funding_cpc/update/nh/SQL": ["merge_state.sql"],
"/home/ubuntu/airflow/dags/arc/phub_agg_data/SQL": [
"town_agg.sql",
"congressional_district_agg.sql",
"county_agg.sql",
],
"/home/ubuntu/airflow/dags/census/adjacency_matrix/curate/SQL": [
"cbg_adjacency.sql",
"cb_adjacency.sql",
"ct_adjacency.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_subgrantees": [
"OK_customized_20260413.sql",
"OK_customized_20260416.sql",
"OK_customized_20260210.sql",
"OK_customized_20260317.sql",
"TX.sql",
"template.sql",
"OK_customized_20260506.sql",
"AZ.sql",
"MN.sql",
"OK_customized_20260515.sql",
"OK_customized.sql",
"MS.sql",
"AR.sql",
"OK.sql",
"IN_customized_20260409.sql",
"OK_customized_20260326.sql",
"IN.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage00_controller/dbt_project/models": [
"schema.yml",
"t_fp_delta_relations.sql",
"t_fp_delta_answer_orphans.sql",
"t_fp_delta_renames.sql",
"t_fp_delta_projects.sql",
"t_fp_delta_locations.sql",
],
"/home/ubuntu/airflow/dags/general/data_summary/SQL": [
"fabric_change_state.sql",
"fabric_change_nation.sql",
],
"/home/ubuntu/airflow/dags/cpc/raw_to_transformed_state_dedup/SQL": [
"state_fed_insert_into.sql",
"create_t_combined_state_and_fed_dedup_bdc.sql",
"federal_insert_into.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3_outbound_generator/dbt_project/models": [
"schema.yml"
],
"/home/ubuntu/airflow/dags/bead/export_pre_bead_bob/SQL": [
"application_review_qa.sql",
"application_locations.sql",
"get_applicants.sql",
"org_contact.sql",
"application_qa.sql",
"get_applications_for_applicant.sql",
"attachment_metadata.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/post_challenge_cai": [
"TX_post_challenge_cai.sql",
"OK_post_challenge_cai.sql",
"XZ_post_challenge_cai.sql",
"MS_post_challenge_cai.sql",
"DC_post_challenge_cai.sql",
"LA_post_challenge_cai.sql",
"CA_post_challenge_cai.sql",
"GU_post_challenge_cai_no_latency.sql",
"PA_post_challenge_cai.sql",
"no_selection.sql",
"NC_post_challenge_cai.sql",
"NM_post_challenge_cai.sql",
],
"/home/ubuntu/airflow/dags/rad/classifier/stage1_features/dbt_project/models": [
"schema.yml",
"t_rad_classifier_features.sql",
],
"/home/ubuntu/airflow/dags/general/data_summary/bead_vote/SQL": [
"bead_eligible_percentage.sql",
"bead_eligible.sql",
],
"/home/ubuntu/airflow/dags/point_in_time/create_schema/SQL": [
"1_load_fcc_ffa_tech_map.sql",
"0_create_tables.sql",
"1_load_fcc_fabric_addresses.sql",
],
"/home/ubuntu/airflow/dags/funding/ingest_ffm_state/SQL": ["transform.sql"],
"/home/ubuntu/airflow/dags/cpc/stage5_sbo_validation/SQL": [
"ZX_dedup_dsl_cfw.sql",
"NH_comp.sql",
"ZX_dedup_dsl.sql",
"MS_comp.sql",
"ZX_comp_dsl.sql",
"NH_dedup.sql",
"MS_dedup.sql",
"ZX_comp_dsl_cfw.sql",
"ZX_comp.sql",
"ZX_dedup.sql",
],
"/home/ubuntu/airflow/dags/grow/rec/site_selection/SQL": [
"adjacent_matrix.sql",
"town_isp.sql",
"business_overall.sql",
"dist_rec.sql",
"bsl_coverage.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/ee_validate_files/dbt_project/models": [
"schema.yml"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage4_application_relation/SQL": [
"r_xyup_supp_awarded_application_projects.sql"
],
"/home/ubuntu/airflow/dags/bead/export_complete_application/dbt_project/models/export": [
"c_complete_export_application_spacex.sql",
"schema.yml",
"c_complete_export_application_amazon.sql",
"c_complete_export_application_all.sql",
"c_complete_export_application_submitted_nepa.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage9_backfill_final_proposal/SQL/Applicant": [
"pg_update_ms.sql",
"pg_update_ok.sql",
"pg_insert_ok.sql",
"load_lake_mn.sql",
"load_lake_az.sql",
"pg_insert_ms.sql",
"load_lake_ms.sql",
"pg_update.sql",
"load_lake_ok.sql",
"pg_insert_mn.sql",
"pg_insert_az.sql",
"pg_update_az.sql",
],
"/home/ubuntu/airflow/dags/training/08_colocated_sql_jinja/SQL": [
"XY.sql",
"LA.sql",
],
"/home/ubuntu/airflow/dags/bead/curate_c_national_bead/SQL": ["default.sql"],
"/home/ubuntu/airflow/dags/sbo/cai/SQL": [
"create_table_r_cai_sbo.sql",
"create_table_c_cai_sbo.sql",
],
"/home/ubuntu/airflow/dags/bbm/audit/SQL/archive": [
"t_bbm_audit_location_census_v3.sql",
"t_bbm_audit_fa_stats_v3.sql",
"t_bbm_audit_fa_stats.sql",
"t_bbm_audit_location_cb_v3.sql",
],
"/home/ubuntu/airflow/dags/lsd/cb20_level/SQL": [
"cb20_lsd.sql",
"create_table_c_lsd_cb20_in_pg_boss_platform.sql",
"create_table_c_lsd_cb20_in_pg.sql",
],
"/home/ubuntu/airflow/dags/rad/google_alpha_earth/SQL": [
"alphaearth_embeddings.sql"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/breakfix/in_joink_ocremc_removal/SQL": [
"preview_applications.sql",
"count.sql",
"delete.sql",
"preview_applicants.sql",
"preview_locations.sql",
"preview_children.sql",
],
"/home/ubuntu/airflow/dags/suitability/ok_portal/02_h3_need_surface/SQL": [
"t_ok_portal_tract_need.sql"
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage4_inbound_processor/dbt_project/models/marts": [
"c_payment_status_updates.sql"
],
"/home/ubuntu/airflow/dags/tileserver/generate_tileset/json": [
"cpc_merge_p_tx.json",
"c_assembly_boundaries_2025_tx.json",
"locations_npv_ok.json",
"c_census_county_2023.json",
"c_cpuc_fire_threat_ca.json",
"c_national_bead.json",
"c_national_bead_progress.json",
"c_senate_boundaries_2025_tx.json",
"c_village_boundaries_gu.json",
"c_national_bead_final_proposal.json",
"c_mbdr_businesses.json",
"c_national_bead_final_proposal_state.json",
"c_cpuc_high_cost_ca.json",
"c_census_city_2023.json",
"c_town_boundaries.json",
"c_national_bead_state.json",
"c_bead_area_attributes_ar.json",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects/dbt_project/models": [
"t_fp_application_rp.sql",
"t_fp_application_sa.sql",
"t_fp_application_dp.sql",
],
"/home/ubuntu/airflow/dags/rad/classifier/stage3_verification/SQL": [
"step4_non_oth_audit.sql",
"step4b_non_oth_usedesc.sql",
"step6_bsl_delta_sample.sql",
"step8_location_id_yield.sql",
"step7_geometry_outliers.sql",
"step5_assessor_gap.sql",
"step2_bus_drivers.sql",
"step3b_non_comm_audit.sql",
"step1_county_bsl.sql",
"step3_non_gov_size.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects_wip/dbt_project/models": [
"t_fp_application_rp.sql",
"t_fp_application_sa.sql",
"t_fp_application_sa_compat.sql",
"t_fp_application_dp_compat.sql",
"t_fp_application_rp_compat.sql",
"t_fp_application_dp.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage4_inbound_processor/dbt_project/models/intermediate": [
"int_payment_matches.sql",
"int_unmatched_records.sql",
],
"/home/ubuntu/airflow/dags/network_resilience/SQL": [
"fiber_edges.sql",
"co_nodes.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage9_backfill_final_proposal/SQL/ApplicantProfile": [
"pg_upsert_ms.sql",
"load_lake_mn.sql",
"load_lake_az.sql",
"pg_upsert.sql",
"load_lake_ms.sql",
"load_lake.sql",
"pg_upsert_mn.sql",
],
"/home/ubuntu/airflow/dags/funding_cpc/refactor/SQL": [
"NM_bead_pre.sql",
"MS_bead_pre.sql",
"OH_bead_pre.sql",
"WY_bead_post.sql",
"NC_bead_post.sql",
"CA_bead_pre.sql",
"AR_bead_post.sql",
"HI_bead_pre.sql",
"OR_bead_post.sql",
"NY_bead_pre.sql",
"HI_bead_post.sql",
"IN_bead_post.sql",
"TEMPLATE_fed_sql_header_awardee_only.sql",
"NJ_bead_post.sql",
"TEMPLATE_fed_sql_header.sql",
"NM_bead_post.sql",
"OK_cpf_pre.sql",
"MS_cpf_pre.sql",
"MN_arc_pre.sql",
"NH_bead_post.sql",
"AR_bead_pre.sql",
"OK_bead_post.sql",
"AL_bead_post.sql",
"CA_arc_pre.sql",
"NY_bead_post.sql",
"TEMPLATE_funding_awardee.sql",
"MS_bead_post.sql",
"CA_bead_post.sql",
"TX_bead_pre_v4.sql",
"OK_arc_pre.sql",
"TX_bead_post.sql",
"ND_bead_pre.sql",
"NC_bead_pre.sql",
"AL_bead_pre.sql",
"MS_arc_pre.sql",
"MS_bead_post_v5.sql",
"AZ_bead_post.sql",
"OH_bead_post.sql",
"OK_bead_pre.sql",
"NH_bead_pre.sql",
"CA_ulfw_pre.sql",
"TEMPLATE_funding.sql",
"TX_bead_pre.sql",
"IN_bead_pre.sql",
"WY_bead_pre.sql",
"VA_arc_pre.sql",
"MS_ulfw_pre.sql",
],
"/home/ubuntu/airflow/dags/funding/SQL": [
"cet_parquet_r_fcc_fm_unserved_unfunded.sql",
"t_funding_arpa_coords.sql",
"cet_parquet_r_fcc_fm_areaattributes.sql",
"cet_parquet_r_fcc_fm_program_funded_locations.sql",
"cet_r_funding_reconnect.sql",
"t_funding_mtts_other_admin_div.sql",
"t_funding_type_ref.sql",
"cet_funding_fcc_fm_versions.sql",
"c_funding_fcc_coords.sql",
"t_fcc_fm_areaattributes_v.sql",
"c_fabric_location_funding.sql",
"t_funding_rmlei_other_admin_div.sql",
"t_fcc_fm_areapolygons_v.sql",
"t_fcc_fm_programdata_v.sql",
"t_fcc_fm_areabuildout_v.sql",
"t_funding_cafiia_cb10.sql",
"cet_parquet_r_fcc_fm_locationattributes.sql",
"t_funding_rep_other_admin_div.sql",
"cet_parquet_r_fcc_fm_programdata.sql",
"t_fcc_fm_locationlist_v.sql",
"t_funding_cnm_other_admin_div.sql",
"t_funding_ctr_other_admin_div.sql",
"cet_parquet_r_fcc_fm_areapolygons.sql",
"t_funding_slfrf_other_admin_div.sql",
"cet_t_fabric_location_funding.sql",
"t_location_id_funding_str_long_cb10.sql",
"t_location_id_funding_str_long_oad.sql",
"t_funding_usac_coords.sql",
"t_funding_jci_other_admin_div.sql",
"c_funding_to_tiles.sql",
"c_funding_fcc_other_admin_div.sql",
"c_fcc_fabric_address_from_sbo.sql",
"t_fcc_fm_locationattributes_v.sql",
"cet_parquet_r_fcc_fm_locationlist.sql",
"cet_r_fcc_fm_areapolygons.sql",
"t_funding_arc_other_admin_div.sql",
"cet_parquet_r_fcc_fm_areabuildout.sql",
"cet_parquet_r_fcc_fm_locationbuildout.sql",
"t_fcc_fm_unserved_unfunded_v.sql",
"t_funding_abaf_other_admin_div.sql",
"t_funding_cm_other_admin_div.sql",
"cet_parquet_r_fcc_fm_funded_locations.sql",
"t_funding_begp_other_admin_div.sql",
"t_fcc_fm_program_funded_locations_v.sql",
"r_funding_type_ref.sql",
"t_fcc_fm_locationbuildout_v.sql",
"t_location_id_funding_str_long_coords.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator_edge_score/stage1_features/SQL": [
"training_rows.sql",
"addr_competing_bldgs_30m.sql",
"bldg_competing_addrs_30m.sql",
"addr_density_50m.sql",
"addr_alphaearth_2025.sql",
],
"/home/ubuntu/airflow/dags/mbdr/overture_gap_fill/SQL": [
"05_dedup.sql",
"01_categories.sql",
"02_businesses.sql",
"06_gap_fill.sql",
"04_pairs.sql",
"03_candidates.sql",
],
"/home/ubuntu/airflow/dags/sbo/fabric_address/load_db/SQL": [
"pg_create_table.sql",
"curate_data_first_time.sql",
"curate_data.sql",
],
"/home/ubuntu/airflow/dags/funding_cpc/update/general_datalake/SQL": [
"merge_ready_dedup.sql",
"create_state_and_fed_dedup_nm_v3.sql",
"create_state_and_fed_dedup_al_v4.sql",
"create_state_and_fed_dedup_ny_v3.sql",
"create_state_and_fed_dedup_nc_v4.sql",
"delete_staging.sql",
"create_state_and_fed_dedup_ny_v4.sql",
"create_state_and_fed_dedup_ms_v4.sql",
"create_state_and_fed_dedup_nm_v4.sql",
"find_provider_id.sql",
"create_state_and_fed_dedup_de_v3.sql",
"insert_final.sql",
"create_state_and_fed_dedup_in_v3.sql",
"update_bidder_ny.sql",
"create_state_and_fed_dedup_std.sql",
"create_state_and_fed_dedup_ok_v4.sql",
"create_state_and_fed_dedup_std_v4.sql",
"create_state_and_fed_dedup_ct_v3.sql",
"create_state_and_fed_dedup_pa_v4.sql",
"create_ready_funding.sql",
"create_state_and_fed_dedup_ar_v4.sql",
"template_fed_sql_header.sql",
"create_state_and_fed_dedup_la_v3.sql",
"create_state_and_fed_dedup_std_awardee.sql",
"create_state_dedup_de.sql",
"create_state_and_fed_dedup_ok_v3.sql",
"create_state_and_fed_dedup_ar_v3.sql",
"create_fed_dedup_v3.sql",
"create_state_and_fed_dedup_nv_v3.sql",
"map_provider_id.sql",
"create_state_and_fed_dedup_nv_v2.sql",
"create_state_and_fed_dedup_oh_v3.sql",
"create_state_and_fed_dedup_hi_v3.sql",
"create_state_and_fed_dedup_mt_v3.sql",
"create_state_dedup.sql",
"create_state_and_fed_dedup_nh_v4.sql",
"create_state_and_fed_dedup_wy_v3.sql",
"create_state_and_fed_dedup_hi_v4.sql",
"create_state_and_fed_dedup_ca_v4.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL": [
"project_id.sql"
],
"/home/ubuntu/airflow/dags/bead/post_challenge_summary/dbt_project/models": [
".gitkeep",
"challenge_type_provider.sql",
],
"/home/ubuntu/airflow/dags/digital_equity/places_health/curate/SQL": [
"county_curate.sql",
"census_tract_curate.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/mn": [
"x_mn_datasme2104_budget.sql",
"x_mn_datasme2104_public_awareness.sql",
"x_mn_datasme2104_overview.sql",
"x_mn_datasme1917_locations.sql",
"x_mn_datasme1930_budget.sql",
"x_mn_datasme1930_overview.sql",
"x_mn_datasme1754.sql",
"x_mn_datasme1917_schedule.sql",
"x_mn_datasme1930_locations.sql",
"x_mn_datasme1917_awareness_low_cost.sql",
"x_mn_datasme1917_overview.sql",
"x_mn_datasme1930_awareness_low_cost.sql",
"x_mn_datasme1930_schedule.sql",
"x_mn_datasme1702.sql",
"x_mn_datasme2104_locations.sql",
"x_mn_datasme2104_schedule.sql",
"x_mn_datasme2104_low_cost_offer.sql",
"x_mn_datasme1917_budget.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/public": [
"x_public_datasme1915.sql",
"x_public_test.sql",
],
"/home/ubuntu/airflow/dags/lsd/other/SQL": [
"ctas_stage1_combine.sql",
"ctas_stage0_fa.sql",
],
"/home/ubuntu/airflow/dags/mbdr/publish_to_pg/SQL": [
"pg_create_c_mbdr_businesses.sql"
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3_outbound_generator/dbt_project/models/marts": [
"c_mart_payment_queue.sql",
"c_payment_batch.sql",
"c_payment_relationship.sql",
],
"/home/ubuntu/airflow/dags/speedtest/update_ookla_mlab/SQL": [
"mlab_curate_daily.sql",
"ookla_create_curate_daily.sql",
"speed_main.sql",
"ookla_m_create_transform.sql",
"ookla_m_curate.sql",
"mlab_curate_3month.sql",
"ookla_b_create_transform.sql",
"ookla_daily_create_base.sql",
"ookla_daily_unload.sql",
"mlab_create_curate.sql",
"mlab_ingest_downloads.sql",
"mlab_create_curate_daily.sql",
"ookla_m_transform.sql",
"ookla_m_partition.sql",
"mlab_daily_unload.sql",
"ookla_b_transform_pr.sql",
"ookla_b_create_curate.sql",
"speedmain_create_base.sql",
"ookla_b_curate_3month.sql",
"speedmain_unload.sql",
"ookla_b_transform.sql",
"ookla_curate_daily.sql",
"mlab_daily_create_base.sql",
"mlab_ingest_uploads.sql",
],
"/home/ubuntu/airflow/dags/digital_equity/community_resilience/ingest_data/SQL": [
"t_acs_digital_equity.sql",
"c_digital_equity.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/fp_grapi_cleanup/SQL/delete": [
"application_location_answer.sql",
"application_notes.sql",
"application_request.sql",
"application_relation.sql",
"permit_application.sql",
"child_applications.sql",
"application_request_revision.sql",
"application_location.sql",
"target_applications.sql",
"application_answer.sql",
"application_activity.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage2_ingest_vendor_details/SQL": [
"texas_pca_codes.sql",
"minnesota.sql",
"texas_vendor_onboarding.sql",
"arizona.sql",
"texas_tmap_pca_codes.sql",
"virginia.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations_wip/dbt_project/models": [
"schema.yml",
"x_export_nepa_locations.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/ms": [
"x_ms_datasme2171.sql",
"x_ms_dataseme1479.sql",
"x_ms_datasme1482.sql",
"x_ms_datasme1906_awarded_v9_status.sql",
"x_ms_datasme1906_address_changed.sql",
"x_ms_data2401_mississippi_river_crossing_geometry.sql",
"x_ms_datasme1482_cat4.sql",
"x_ms_datasme1482_cat5.sql",
"x_ms_datasme1886_att_national_forest.sql",
"x_ms_datasme1482_cat2.sql",
"x_ms_datasme1378.sql",
"x_ms_datasme1906_reason_code_3_missing.sql",
"x_ms_datasme1482_cat3.sql",
"x_ms_datasme1482_cat1.sql",
"x_ms_data2401_mississippi_river_crossings.sql",
"x_ms_datasme2150_red_blue.sql",
"x_ms_datasme1940.sql",
"x_ms_datasme1886_fp_locations_national_forest.sql",
"x_ms_datasme1377.sql",
"x_ms_datasme2073_tds_eacam.sql",
"x_ms_datasme2072_rdof_awarded.sql",
"x_ms_datasme1749.sql",
"x_ms_datasme1629.sql",
"x_ms_datasme1818.sql",
"x_ms_datasme1906_latlong_changed.sql",
"x_ms_datasme1274.sql",
"x_ms_datasme1671.sql",
"x_ms_datasme2134_bead12_loc.sql",
"x_ms_datasme1971_monroe_rdof.sql",
"x_ms_datasme1869.sql",
"x_ms_datasme1662.sql",
"x_ms_datasme1846.sql",
"x_ms_datasme2153_mpulse_rdof_okolona.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage5_extra_application_answers/SQL": [
"all_update_location_counts.sql",
"all_active_location_parity.sql",
"all_places.sql",
"all_location_version_diagnostics.sql",
"all_project_answers.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage9_backfill_final_proposal/SQL/ApplicationAnswer": [
"temp.sql",
"load_lake_mn.sql",
"load_lake_az.sql",
"pg_insert.sql",
"load_lake_ms.sql",
"pg_update.sql",
"load_lake_ok.sql",
"load_lake_ok_int.sql",
],
"/home/ubuntu/airflow/dags/sbo/ms/SQL": [
"bip-cust-445.sql",
"find_location_id_unique.sql",
"find_location_id.sql",
"cpf_objection_fabric.sql",
"find_service_status.sql",
"bip-cust-412_add_missing.sql",
"cpf_add_missing.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage2_negotiate/SQL": [
"01_classify.sql",
"02_structures.sql",
],
"/home/ubuntu/airflow/dags/arc/phub_agg_div_progress/SQL": [
"pg_c_fabric_location_divisions.sql",
"town_agg.sql",
"congressional_district_agg.sql",
"state_house_district_agg.sql",
"tribal_agg.sql",
"location_divisions.sql",
"state_senate_district_agg.sql",
"county_agg.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage4_application_relation_wip/SQL": [
"r_xyup_supp_awarded_application_projects.sql"
],
"/home/ubuntu/airflow/dags/tileserver/generate_tileset/SQL": [
"c_mbdr_businesses.sql",
"c_assembly_boundaries_2025_tx.sql",
"c_national_bead_final_proposal_state.sql",
"c_senate_boundaries_2025_tx.sql",
"c_bead_area_attributes_ar.sql",
"c_national_bead_progress.sql",
"c_census_city_2023.sql",
"c_census_county_2023.sql",
"c_national_bead.sql",
"locations_npv_ok.sql",
"c_village_boundaries_gu.sql",
"c_national_bead_state.sql",
"c_town_boundaries.sql",
"c_cpuc_fire_threat_ca.sql",
"cpc_merge_p_tx.sql",
"c_cpuc_high_cost_ca.sql",
"c_national_bead_final_proposal.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage4_inbound_processor/dbt_project/models": [
"schema.yml",
"sources.yml",
],
"/home/ubuntu/airflow/dags/bedrock/data_comparison_agent/comparison/dbt_project/models/staging": [
"stg_source.sql",
"stg_target.sql",
],
"/home/ubuntu/airflow/dags/arc/upload_onboard_templates/dbt_project/models": [
".gitkeep",
"_sources.yml",
],
"/home/ubuntu/airflow/dags/arc/one_offs/SQL": [
"arc_828.sql",
"arc_494_revision_request_evidence.sql",
"arc_747_2_update_lastreimbursementnumber.sql",
"arc_441_4_applicationanswer_reportingperiod.sql",
"arc_441_1_application_submittedat.sql",
"arc_747_1_update_currentreimbursementnumber.sql",
"va_1440_fix_location_count.sql",
"arc_672_2_update_grant_remaining.sql",
"arc_672_3_update_lastreimbursementnumber.sql",
"arc_406_ar_remap_application_applicant.sql",
"xy_reset_rp_dp.sql",
"il_delete_dup_bsl_applicationlocation_20260731.sql",
"arc_672_fix_1_update_grant_requests.sql",
"arc_819_2.sql",
"ar_4_drop_old_tables.sql",
"arc_441_2_application_dueat.sql",
"arc_819_1.sql",
"arc_672_1_update_grant_requests.sql",
"arc_484_update_boone.sql",
"arc_759_1.sql",
"arc_759_3.sql",
"arc_441_3_application_name.sql",
"arc_759_2.sql",
"ar_2_restore_backup_tables.sql",
"arc_799.sql",
"arc_818_delete_version20250813.sql",
"arc_441_dueat_submittedat_name.sql",
"ar_delete_all.sql",
"ms_update_report_status.sql",
"arc_759_2a.sql",
"arc_818_dev.sql",
"arc_871_1.sql",
"la_delete_all_by_applicant.sql",
"ar_3_drop_backup_tables.sql",
"arc_827.sql",
"arc_672_revert_1_update_grant_requests.sql",
"ar_1_backup_tables.sql",
"arc_871_2.sql",
"arc_746_update_reimbursementrequestnumber.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects/SQL/ReportingProject": [
"pg_insert.sql",
"load_lake.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage6_users/dbt_project/models": [
"t_fp_stage_user_access.sql",
"t_fp_stage_users.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations_wip/SQL/one_to_one": [
"cai_ReportingProject.sql",
"bsl_DeploymentProject.sql",
"bsl_ReportingProject.sql",
"cai_DeploymentProject_VA.sql",
"cai_DeploymentProject.sql",
],
"/home/ubuntu/airflow/dags/general/bbm_export/SQL": [
"bsl_dl.sql",
"cai_dl.sql",
"towers.sql",
"fabric_service_v3.sql",
"speed_test.sql",
"cai.sql",
"bsl.sql",
"fabric_service.sql",
"lsd_cb20.sql",
"poi.sql",
"lsd.sql",
"parcel.sql",
],
"/home/ubuntu/airflow/dags/proposed_project_areas/tile/SQL": [
"indiana.sql",
"arkansas.sql",
"mississippi.sql",
"demo_base.sql",
"texas.sql",
"california.sql",
"oklahoma.sql",
],
"/home/ubuntu/airflow/dags/lsd/sbo/SQL": ["t_lsd_sbo.sql"],
"/home/ubuntu/airflow/dags/general/ctasifier/json": [
"bi_bead_project_plan_detail.json",
"ca_bi_application_answer.json",
"ca_bi_application_answer_wide.json",
"bi_bead_location_detail.json",
"ar_bi_application_cai.json",
"ca_bi_application_cai.json",
"VA_DATASME-1943_cai_corrected_tile_projection.json",
"bi_application_answer_wide.json",
"ar_bi_application_location.json",
"ar_bi_application_answer.json",
"bi_application_question_answer_mapping.json",
"ar_bi_application_question_answer_mapping.json",
"demo_bi_deployment_projects.json",
"ca_bi_applicant_contact.json",
"bi_bead_provider_sga.json",
"az_bi_application.json",
"az_bi_application_cai.json",
"bi_bead_award_overview.json",
"ca_bi_application_location.json",
"mn_bi_application_question_answer_mapping.json",
"demo_bi_application_location.json",
"bi_application_cai.json",
"VA_DATASME-1895_rp_financial_subgrant_agreements_backup.json",
"demo_bi_application_answer_wide.json",
"ApplicationLocation_backup_082626.json",
"mn_bi_application_answer_wide.json",
"ar_bi_application.json",
"VA_DATASME-1895_rp_financial_reporting_projects_backup.json",
"bi_bead_project_plan.json",
"az_bi_application_location.json",
"bi_bead_project_review_stage.json",
"bi_user_applicant_access.json",
"bi_applicant_contact.json",
"ca_cpc_funding_arc_pre_20260217.json",
"bi_bead_compliant_report_detail.json",
"bi_bead_project_permit.json",
"bi_bead_compliant_report.json",
"bi_bead_project_overview.json",
"VA_DATASME-1895_rp_financial_reporting_project_answers_backup.json",
"bi_bead_project_milestone_1.json",
"demo_bi_application_answer.json",
"demo_bi_application_cai.json",
"az_bi_application_answer.json",
"bi_application_location.json",
"bi_bead_project_activity.json",
"az_bi_application_answer_wide.json",
"VA_DATASME-1943_non_cai_hash_control.json",
"az_bi_application_question_answer_mapping.json",
"mn_bi_application_answer.json",
"demo_bi_application.json",
"demo_bi_application_question_answer_mapping.json",
"mn_bi_applicant_contact.json",
"bi_application_answer.json",
"ca_bi_application.json",
"mn_bi_application_cai.json",
"tx_economic_regions.json",
"demo_bi_applicant_contact.json",
"mn_bi_application_location.json",
"ar_bi_application_answer_wide.json",
"c_bob_merge_tile_tx_backup_082626.json",
"ca_bi_application_question_answer_mapping.json",
"bi_bead_project_budget.json",
"ar_bi_applicant_contact.json",
"mn_bi_application.json",
"bi_application.json",
"VA_DATASME-1895_rp_financial_subgrant_agreement_answers_backup.json",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/fp_sync_lake_from_grapi/dbt_project/models": [
"schema.yml",
"t_fp_application_rp.sql",
"t_fp_application_sa.sql",
"x_fp_deployment_reporting.sql",
"t_fp_reporting_projects.sql",
"x_fp_reporting_project_cai.sql",
"t_fp_application_rp_wip.sql",
"t_fp_cai.sql",
"x_fp_locations.sql",
"t_fp_deployment_projects_answers.sql",
"t_fp_subgrant_agreements.sql",
"x_fp_subgrant_agreements.sql",
"t_fp_subgrantees.sql",
"t_fp_reporting_project_cai.sql",
"t_fp_deployment_projects.sql",
"x_fp_deployment_projects.sql",
"x_fp_reporting_project_locations.sql",
"x_fp_subgrantees.sql",
"t_fp_locations.sql",
"t_fp_application_sa_wip.sql",
"x_fp_reporting_projects.sql",
"t_fp_subgrant_agreement_projects_answers.sql",
"t_fp_subgrant_agreement_dp_map.sql",
"t_fp_reporting_projects_answers.sql",
"t_fp_application_dp_wip.sql",
"t_fp_deployment_reporting.sql",
"t_fp_reporting_project_locations.sql",
"x_fp_cai.sql",
"t_fp_no_bead_locations.sql",
"x_fp_no_bead_locations.sql",
"t_fp_application_dp.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/gu": [
"x_gu_datasme2033_supp_reporting_projects.sql",
"x_gu_datasme2033_supp_deployment_reporting.sql",
],
"/home/ubuntu/airflow/dags/rad/negotiator/stage2_negotiate/dbt_project/models": [
"schema.yml",
"t_rad_negotiate_classify.sql",
"t_rad_structures.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations_wip/SQL/n_to_m": [
"cai_ReportingProject.sql",
"bsl_ReportingProject.sql",
"cai_ReportingProject_CA.sql",
"cai_ReportingProject_VA.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage4_inbound_processor/dbt_project/models/staging": [
"stg_payment_confirmations.sql",
"stg_payment_relationships.sql",
],
"/home/ubuntu/airflow/dags/bead/sdpn_challenge/dbt_project/models": [
"schema.yml",
"c_sdpn_merge.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/breakfix/in_joink_ocremc_restore/SQL": [
"update_derived_columns.sql",
"update_status.sql",
"source_files.sql",
"source_locations.sql",
"verify.sql",
"source_applications.sql",
"repair_array_columns.sql",
"source_answers.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/al": [
"x_al_datasme_1468_scabcd_report_locations.sql",
"x_al_datasme_1468_scabcd_report_cai.sql",
"x_al_datasme_1468_scabcd_report_locations_class12.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/tx": [
"x_tx_datasme1894_eupa_debug.sql",
"x_tx_datasme1539_budget.sql",
"x_tx_datasme2002_application_log.sql",
"x_tx_datasme1539_activities_non_leo.sql",
"x_tx_datasme1539_additional.sql",
"x_tx_datasme1596.sql",
"x_tx_datasme1392.sql",
"x_tx_datasme2084_remaining_research_list.sql",
"x_tx_datasme2084_county_summary.sql",
"x_tx_datasme1674_appdata.sql",
"x_tx_datasme1674_budget.sql",
"x_tx_datasme1370.sql",
"x_tx_datasme1991.sql",
"x_tx_datasme1674_nonleo.sql",
"x_tx_datasme1674_leo.sql",
"x_tx_datasme2084.sql",
"x_tx_datasme1674_permitting.sql",
"x_tx_datasme1410.sql",
"x_tx_datasme1925_bead_locations_missing_v9.sql",
"x_tx_datasme1539_activities_leo.sql",
"x_tx_datasme1539_permits.sql",
"x_tx_datasme1674_apploc.sql",
],
"/home/ubuntu/airflow/dags/arc/financial_integration/stage3b_outbound_summary/dbt_project/models/tx": [
"c_outbound_summary_tx.sql"
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage8_bead_phub/dbt_project/models": [
"schema.yml",
"c_cpc_merge_tile_final_proposal_grapi.sql",
"phub_merge.sql",
"phub_speedrank_qaqc.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/breakfix/fix_version_date/SQL": [
"update_version_date.sql",
"census.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/ar": [
"x_ar_datasme1567.sql",
"x_ar_datasme1937_subgrantee.sql",
"x_ar_datasme1937_dp_export.sql",
"x_ar_datasme1992.sql",
"x_ar_datasme1934.sql",
"x_ar_datasme1667.sql",
"x_ar_datasme1338.sql",
"x_ar_datasme1924_locations.sql",
"x_ar_datasme1850.sql",
"x_ar_datasme1677.sql",
"x_ar_datasme2020.sql",
"x_ar_datasme2009.sql",
"x_ar_datasme1337.sql",
"x_ar_datasme1937_dp_export_real_value.sql",
"x_ar_datasme1861.sql",
"x_ar_datasme1491.sql",
"x_ar_datasme1648_locations.sql",
"x_ar_datasme1782.sql",
"x_ar_datasme1924_cais.sql",
"x_ar_datasme1648_cais.sql",
],
"/home/ubuntu/airflow/dags/bedrock/data_comparison_agent/comparison/SQL": [
"create_temp_table.sql",
"drop_temp_table.sql",
],
"/home/ubuntu/airflow/templates/sql/CET": [
"r_inup_unserved.sql",
"r_mtup_fed_dedup_bdc_121223.sql",
"r_mtup_funding_all_grant_served_locations.sql",
"r_msup_provider_common_names.sql",
"r_ksup_12_08_23_BSL_CAI_Eligibility.sql",
"r_mtup_post_challenge_cai_summit_lightbox.sql",
"r_nyup_underserved.sql",
"r_dcup_raw_cai_correction.sql",
"r_ksup_BSL_List_Eligibility_12_06_23.sql",
"r_ndup_underserved.sql",
"r_ksup_bsl_list_eligible.sql",
"r_ohup_underserved.sql",
"r_cpc_area_challenge_filtered_va.sql",
"r_inup_underserved.sql",
"r_ohup_unserved.sql",
"r_cpc_challenge_addresses_va.sql",
"r_caup_cpuc_cai_manual_removal.sql",
"r_wyup_ntia_schema_revised_april_2024_v4.sql",
"r_laup_gumbo2_data_final.sql",
"r_deup_unserved.sql",
"r_ksup_BSL_List_Eligibility_12_01_23.sql",
"r_nyup_unserved.sql",
"r_ms_cpf_awarded_locations.sql",
"r_ksup_cai_list_provider_final.sql",
"r_ndup_unservfed.sql",
"r_ksup_state_and_fed_dedup_bdc.sql",
"r_wvup_fed_dedup_bdc.sql",
"r_ksup_providers.sql",
"r_deup_state_and_fed_dedup_bdc.sql",
"r_nyup_state_and_fed_dedup_bdc.sql",
"r_deup_underserved.sql",
"r_mtup_funding_local_grants_served_locations.sql",
"r_okup_supplemenrtal_providers.sql",
"r_dcup_raw_cai_challenges_override_CUST2761.sql",
"r_ksup_cai_11_21_23.sql",
],
"/home/ubuntu/airflow/dags/bbm/audit/stage_0_fabric_address_stats/SQL": [
"t_bbm_audit_location_census_v3.sql",
"t_bbm_audit_location_census_v4.sql",
"t_bbm_audit_fa_stats_v3.sql",
"t_bbm_audit_fa_stats_v4.sql",
"t_bbm_audit_location_cb_v4.sql",
"c_fcc_fabric_address_v4.sql",
"t_bbm_audit_location_cb_v3.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage6_post_challenge_summary/SQL": [
"athena_challenges_by_tenant.sql"
],
"/home/ubuntu/airflow/dags/census/demographics_data_ingest/SQL": [
"cbg_to_cb_interpolate.sql",
"cbg_to_cb_lookup.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage2_load_provider_tech_map/SQL": [
"MS_load_ffa.sql",
"CA_load_ffa.sql",
"TX_load_ffa.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations/SQL/one_to_one": [
"cai_ReportingProject.sql",
"bsl_DeploymentProject.sql",
"bsl_ReportingProject.sql",
"cai_DeploymentProject_VA.sql",
"cai_DeploymentProject.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/az": [
"x_az_datasme1719_spacex_consolidation_locations.sql",
"x_az_appsme2215_rp.sql",
"x_az_datasme1956_bead_locations_missing_v9.sql",
"x_az_datasme2146_funding_fabric_version.sql",
"x_az_appsme2215_dp.sql",
"x_az_datasme2109_fp_locations_bsl_v8_v9.sql",
"x_az_datasme2048_nepa_location_md5_mapping.sql",
],
"/home/ubuntu/airflow/dags/datalake/load_location_lake_table/SQL": [
"DE_post_challenge_tile.sql",
"XZ_ulfw_tile.sql",
"TX_final_proposal_tile.sql",
"PA_post_challenge_tile.sql",
"NM_fabric_v4_tile.sql",
"XZ_bead_tile.sql",
"XZ_tile_dsl_mod_pre.sql",
"CA_tile.sql",
"MP_final_proposal_tile.sql",
"HI_post_challenge_adj_tile.sql",
"NJ_tile.sql",
"OR_tile.sql",
"NV_post_challenge_tile.sql",
"UT_final_proposal_tile.sql",
"MN_final_proposal_tile.sql",
"WY_tile.sql",
"IN_final_proposal_tile.sql",
"AR_fabric_v4_tile.sql",
"CT_tile.sql",
"NC_post_challenge_tile.sql",
"PA_tile.sql",
"AZ_bead_r1_tile.sql",
"OK_post_challenge_adj_tile.sql",
"XY_bead_tile.sql",
"MS_post_challenge_tile.sql",
"GU_bob_tile.sql",
"NY_fabric_v4_tile.sql",
"LA_post_challenge_tile.sql",
"AR_bead_tile.sql",
"MN_bead_tile.sql",
"NY_tile.sql",
"OK_tile.sql",
"GU_final_proposal_tile.sql",
"IN_post_challenge_adj_tile.sql",
"CA_bob_r3_tile.sql",
"MN_arc_mission_control_tile.sql",
"AR_post_challenge_adj_tile.sql",
"OR_post_challenge_adj_tile.sql",
"MS_cpf_awardedlocationspoints_tile.sql",
"OK_final_proposal_tile.sql",
"OH_post_challenge_tile.sql",
"IN_bead_tile.sql",
"MS_bob_tile.sql",
"MS_cpf_tile.sql",
"MS_cpf_awardedlocations_tile.sql",
"NM_tile.sql",
"MT_post_challenge_tile.sql",
"MS_objection_tile.sql",
"OK_bob_breakfix_tile.sql",
"LA_final_proposal_tile.sql",
"MS_final_proposal_tile.sql",
"VA_vati_tile.sql",
"CA_bob_tile.sql",
"AZ_bob_tile.sql",
"MS_ulfw_tile.sql",
"TX_bob_tile.sql",
"NE_final_proposal_tile.sql",
"CA_bead_tile.sql",
"GU_fabric_v5_tile.sql",
"ID_final_proposal_tile.sql",
"XY_tile.sql",
"GU_tile.sql",
"MS_bead_tile.sql",
"GU_post_challenge_adj_tile.sql",
"AL_scabcd_tile.sql",
"CA_ulfw_tile.sql",
"NV_tile.sql",
"AZ_final_proposal_tile.sql",
"IN_final_proposal_datasme1907_tile.sql",
"XZ_post_challenge_adj_tile.sql",
"TX_bead_tile.sql",
"AL_post_challenge_tile.sql",
"LA_tile.sql",
"CA_post_challenge_tile.sql",
"CA_fabric_v4_tile.sql",
"HI_tile.sql",
"MN_bob_tile.sql",
"HI_fabric_v4_tile.sql",
"NM_post_challenge_tile.sql",
"MS_tile.sql",
"LA_fabric_v3_tile.sql",
"TX_fabric_v4_tile.sql",
"XZ_post_challenge_tile.sql",
"AZ_bead_tile.sql",
"VA_final_proposal_tile.sql",
"IN_bob_tile.sql",
"AZ_bead_r2_tile.sql",
"ND_fabric_v4_tile.sql",
"DE_accepted_tile.sql",
"OK_bead_tile.sql",
"NC_tile.sql",
"CT_post_challenge_tile.sql",
"OK_ulfw_tile.sql",
"OK_bob_tile.sql",
"KS_final_proposal_tile.sql",
"OK_cpf_tile.sql",
"IN_tile.sql",
"KS_tile.sql",
"VA_arc_mission_control_tile.sql",
"DE_tile.sql",
"MS_fabric_v5_tile.sql",
"MS_fabric_v4_tile.sql",
"ZZ_tile.sql",
"NH_tile.sql",
"NJ_post_challenge_tile.sql",
"ND_tile.sql",
"AR_tile.sql",
"XZ_tile_no_mod_pre.sql",
"TX_tile.sql",
"XZ_final_proposal_tile.sql",
"IL_final_proposal_tile.sql",
"DC_tile.sql",
"MS_post_challenge_adj_tile.sql",
"WV_tile.sql",
"CA_post_challenge_adj_tile.sql",
"CA_final_proposal_tile.sql",
"AR_final_proposal_tile.sql",
"XZ_post_challenge_tile_no_mod.sql",
"XY_post_challenge_tile.sql",
"MI_Detroit_tile.sql",
"TX_post_challenge_adj_tile.sql",
"AL_tile.sql",
"MS_post_challenge_v5_tile.sql",
"ND_post_challenge_adj_tile.sql",
"OH_tile.sql",
"MT_tile.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage2_projects_wip/SQL": [
"delete_project.sql",
"guard_unhandled_children.sql",
"rename_project.sql",
],
"/home/ubuntu/airflow/dags/general/canopy_cover_analysis/gap_analysis/SQL": [
"gap_analysis_export.sql"
],
"/home/ubuntu/airflow/dags/bead/tx_permit_bulk_load/SQL": [
"apply.sql",
"manifest.sql",
],
"/home/ubuntu/airflow/dags/bead/export_complete_application/dbt_project/models/standard": [
"schema.yml",
"c_complete_export_application_answer.sql",
"c_complete_export_applicant_profile.sql",
"c_complete_export_application_note.sql",
"c_complete_export_application_relation.sql",
"c_complete_export_application_request_revision_fcc_fabric_location.sql",
"c_complete_export_application_location_answer.sql",
"c_complete_export_application_review_stage.sql",
"c_complete_export_application_inventory.sql",
"c_complete_export_application_request.sql",
"c_complete_export_file_metadata.sql",
"c_complete_export_applicant_profile_contact.sql",
"c_complete_export_application_node.sql",
"c_complete_export_application_resource.sql",
"c_complete_export_application_location_resource.sql",
"c_complete_export_applicant.sql",
"c_complete_export_application_review_stage_answer.sql",
"c_complete_export_application_activity.sql",
"c_complete_export_application_request_revision.sql",
"c_complete_export_application_location.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/breakfix/va_baba_report_attachment_backup/SQL": [
"baba_attachments.sql"
],
"/home/ubuntu/airflow/dags/general/map_image_generator/sql": [
"az_datasme1719_spacex_consolidation.sql"
],
"/home/ubuntu/airflow/dags/general/pg_sql_breakfixer/SQL": [
"AR_DATASME-1892p_archive_superseded_records_stage1.sql",
"UT_DATASME-2029_preset_nn21_rp_to_ter.sql",
"AZ_DATASME-1870_fix_dp_sga_financial_fanout.sql",
"MS_DATASME-1887_fix_sa_legacy_id.sql",
"AR_DATASME-2030_remove_superseded_comcast_sga.sql",
"test.sql",
"VA_DATASME-1943_prod_rollback_stale_location_generations.sql",
"VA_DATASME-1895_remove_stale_apps_and_orphan_status.sql",
"VA_DATASME-1519_restore_stage_users_with_preferences.sql",
"UT_DATASME-1647_fix_marina_user_record.sql",
"VA_DATASME-1895_reset_changed_20260709_cai_apploc.sql",
"AR_DATASME-1892_archive_crossprovider_spacex.sql",
"TX_DATASME-1126_update_cai_address.sql",
"AR_DATASME-1892p_archive_superseded_records_stage2.sql",
"XY_DATASME-2159_backup_mode_smoke.sql",
"AR_DATASME-1892_backup_stale_null_versiondate_apploc.sql",
"GU_DATASME-2033_dev_realign_bead_app_locations.sql",
"UT_DATASME-1647_delete_null_address_apploc.sql",
"AR_DATASME-1892_fix_natc_sa_dp_relation.sql",
"VA_DATASME-1943_stage_rollback_cai_repair.sql",
"MS_DATASME-1887_archive_stale_reporting_projects_stage2.sql",
"IN_DATASME-2018_repoint_nested_project_plans.sql",
"VA_DATASME-1895_drop_amazon_sga_financial_backups.sql",
"AR_DATASME-1873_fix_rp_subgrantee_match_answer.sql",
"MN_DATASME-1964_dev_fix_demo_project_nepa_answers.sql",
"VA_DATASME-1943_dev_delete_stale_location_generations_stage2.sql",
"MS_DATASME-1887_drop_stale_reporting_project_backups_stage3.sql",
"TX_DATASME-1709_fix_dp_sga_answer_fanout.sql",
"VA_DATASME-1895_drop_historical_only_apploc_backups.sql",
"VA_DATASME-1895_remove_historical_only_apploc.sql",
"AR_DATASME-1892p_backup_affected_records.sql",
"VA_DATASME-1895_drop_retained_dp_financial_backups.sql",
"VA_DATASME-1546_populate_sga_financial_fields.sql",
"MN_DATASME-1748_create_demo_applicant.sql",
"IN_DATASME-1874_fix_dp_sga_answer_fanout.sql",
"VA_DATASME-1943_prod_delete_stale_location_generations_stage2.sql",
"VA_DATASME-1943_stage_snapshot_cai_repair_stage1.sql",
"VA_DATASME-1696_revert_unintended_rp_sgas.sql",
"VA_DATASME-1895_drop_comcast_sga_financial_backups.sql",
"GU_DATASME-1878_fix_dp_sga_answer_fanout.sql",
"VA_DATASME-1895_remove_misassigned_amazon_rp_locations.sql",
"MN_DATASME-1877_fix_dp_sga_financial_fanout.sql",
"CA_DATASME-1945_backfill_bob_round_3_kuiper_metadata.sql",
"VA_DATASME-2095_reset_llus.sql",
"VA_DATASME-1696_normalize_dp_sga_legacy_ids.sql",
"AZ_DATASME-1730_spacex_consolidation_prod_cleanup.sql",
"CA_DATASME-2152_dev_delete_fp_test_artifacts.sql",
"VA_DATASME-1860_fix_dp_sga_financial_fanout.sql",
"VA_DATASME-2014_fix_invalid_pit_speedrank.sql",
"IN_DATASME-2018_unlink_mainstream_parent_sga_dp_relations.sql",
"OK_DATASME-1872_fix_dp_sga_financial_fanout.sql",
"MS_DATASME-1887_backup_stale_reporting_projects_stage1.sql",
"AZ_DATASME-1870_fix_rp_subgrantee_match_answer.sql",
"VA_DATASME-1895_reconcile_comcast_dp_based_sga_answer.sql",
"VA_DATASME_1346_clean_stage.sql",
"GU_DATASME-1811_clean_pit_unicode_whitespace.sql",
"ID_DATASME-2028_align_sga_legacy_ids_to_project_num.sql",
"AR_DATASME-1873_fix_dp_sga_financial_fanout.sql",
"VA_DATASME-1943_stage_rollback_stale_location_generations.sql",
"AR_DATASME-1892_archive_att_consolidation.sql",
"IN_DATASME-2018_remove_duplicate_sgas.sql",
"MS_DATASME-1887_fix_rp_legacy_ids.sql",
"VA_DATASME-1943_prod_snapshot_stale_location_generations_stage1.sql",
"AR_DATASME-2030_align_sga_legacy_ids.sql",
"VA_DATASME-1843_backfill_pop_cai_technology.sql",
"GU_DATASME-2033_stage_realign_gta_bsl_locations.sql",
"VA_DATASME-1943_stage_snapshot_stale_location_generations_stage1.sql",
"VA_DATASME-2136_prod_delete_baba_reports.sql",
"MN_DATASME-1748_create_demo_projects.sql",
"VA_DATASME-1943_dev_rollback_stale_location_generations.sql",
"VA_DATASME-1943_dev_snapshot_cai_repair.sql",
"VA_DATASME-1943_drop_cai_repair_backups.sql",
"VA_DATASME-1943_stage_delete_stale_location_generations_stage2.sql",
"ID_DATASME-2035_backfill_bsl_addresses_from_pit.sql",
"VA_DATASME-1829_delete_null_technology_cai_apploc.sql",
"OK_DATASME-1872_fix_dp_subgrantee_match_answer.sql",
"VA_DATASME-1943_dev_apply_cai_repair_stage2.sql",
"AZ_DATASME-1870_fix_sga_subgrantee_match_answer.sql",
"XY_DATA-2306_seed_cpf_applications.sql",
"CA_DATASME-2102_reset_sga_submission_status.sql",
"VA_DATASME-1895_reconcile_retained_dp_financials.sql",
"VA_DATASME-1895_reconcile_rp_financial_rebuild.sql",
"AZ_DATASME-1866_fix_navajo_rp_reallocation.sql",
"TX_DATASME-1979_dev_reset_llu_test_artifacts.sql",
"VA_DATASME-1895_remove_source_absent_20260709_cai_apploc.sql",
"UT_DATASME-2029_fix_rp_display_names.sql",
"TX_DATASME-1126_post_deploy_fix.sql",
"VA_DATASME-1895_drop_archive_delta_cai_backups.sql",
"IN_DATASME-2008_remove_surf_berrycomm_arc.sql",
"VA_DATASME-1895_reconcile_amazon_dp_based_sga_financials.sql",
"GU_DATASME-1878_fix_dp_sga_financial_fanout.sql",
"AR_DATASME-1873_fix_dp_subgrantee_match_answer.sql",
"VA_DATASME-1895_drop_cai_apploc_backups.sql",
"AR_DATASME-1892_recalc_dp_rp_location_counts.sql",
"IN_DATASME-1897_backup_south_central_remc_arc.sql",
"AR_DATASME-1892_archive_leo_superseded_dps.sql",
"AR_DATASME-1873_fix_dp_sga_answer_fanout.sql",
"DATA-1944_rename_fcc_address_search.sql",
"IN_DATASME-1897_drop_south_central_remc_backup.sql",
"KS_DATASME-2159_remove_test_ehp_milestone_submission.sql",
"IN_DATASME-1897_remove_south_central_remc_arc.sql",
"CA_DATASME-1875_fix_dp_sga_answer_fanout.sql",
"CA_DATASME-1875_fix_dp_sga_financial_fanout.sql",
"AR_DATASME-1892_archive_superseded_records_stage2.sql",
"VA_DATASME-1943_stage_apply_cai_repair_stage2.sql",
"VA_DATASME-1546_swap_sga_dp_relation_direction.sql",
"UT_DATASME-1876_fix_dp_sga_answer_fanout.sql",
"VA_DATASME-1546_fix_sga_legacy_ids.sql",
"AR_DATASME-1892_backup_crossprovider_spacex.sql",
"VA_DATASME-2136_dev_delete_baba_reports.sql",
"AR_DATASME-1892_backup_leo_dp_collapse.sql",
"ID_DATASME-1891_remove_stale_sga_applications.sql",
"VA_DATASME-1943_dev_rollback_cai_repair.sql",
"VA_DATASME-1829_backfill_dp_rp_cai_technology.sql",
"AR_DATASME-1892_archive_superseded_records_stage1.sql",
"OK_DATASME-1872_fix_sga_miles_jobs_answer_fanout.sql",
"MS_DATASME-2123_move_conexon_llu_locations.sql",
"OK_DATASME-1872_fix_rp_subgrantee_match_answer.sql",
"AR_DATASME-1892_backup_affected_records.sql",
"TX_DATASME-2145_drop_orphan_fts_stage_table.sql",
"AZ_DATASME-1870_fix_sga_miles_jobs_answer_fanout.sql",
"AZ_DATASME-1972_remove_excluded_trico_cai_locations.sql",
"OK_DATASME-1872_fix_sga_subgrantee_match_answer.sql",
"IN_DATASME-1874_fix_dp_sga_financial_fanout.sql",
"AR_DATASME-1892_drop_backup_temp_tables.sql",
"VA_DATASME-1895_drop_rp_financial_rebuild_backups.sql",
"ALL_DATASME-1654_fix_rp_application_name.sql",
"AZ_DATASME-1730_spacex_consolidation.sql",
"VA_DATASME-1895_drop_stale_app_backups.sql",
"AR_DATASME-1892_delete_stale_null_versiondate_apploc.sql",
"AR_DATASME-1892_backup_att_consolidation.sql",
"AR_DATASME-1892_drop_staleal_backup_temp_tables.sql",
"MN_DATASME-1877_fix_dp_sga_answer_fanout.sql",
"UT_DATASME-1876_fix_dp_sga_financial_fanout.sql",
"MS_DATASME-2116_repoint_public_gcp_files_to_s3_private.sql",
"CA_DATASME-2102_prod_wipe_bead_projects.sql",
"UT_DATASME-2028_align_sga_legacy_ids_to_project_num.sql",
"VA_DATASME-1943_dev_snapshot_stale_location_generations_stage1.sql",
"AR_DATASME-1892_repoint_leo_aggregates.sql",
"MS_DATASME-1684_remove_stale_fp_projects.sql",
"AR_DATASME-1892_backup_leo_repoint.sql",
"ID_DATASME-1891_drop_stale_sga_backup_tables.sql",
"VA_DATASME-1943_drop_stale_location_generations_backups.sql",
"TX_DATASME-1709_fix_dp_sga_financial_fanout.sql",
"AR_DATASME-1892_remove_natc_duplicate_sga.sql",
"IN_DATASME-2018_repoint_project_ids_to_affiliate_tokens.sql",
"VA_DATASME-2136_stage_delete_baba_reports.sql",
"AZ_DATASME-1870_fix_dp_subgrantee_match_answer.sql",
"VA_DATASME-1546_missing_sga_dp_relations.sql",
"VA_DATASME-1895_drop_amazon_reassignment_backups.sql",
"TX_DATASME-1979_delete_pristine_llus.sql",
],
"/home/ubuntu/airflow/dags/general/test/dbt_intro/majid/dbt_project/models/staging/athena": [
"test_dbt_cross_db_query.sql",
"test_dbt_athena__permutations.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/ee_validate_files/SQL/version_comparison": [
"sample_removed.sql",
"sample_added.sql",
"count_rows.sql",
"count_removed.sql",
"project_breakdown_modified.sql",
"count_added.sql",
"project_breakdown_full.sql",
"project_breakdown_removed.sql",
"sample_modified.sql",
"project_breakdown_added.sql",
"count_modified.sql",
],
"/home/ubuntu/airflow/templates/sql/CTAS": [
"c_cpc_merge_tile_ks_new_funding.sql",
"c_cpc_ks_program_name_mapping.sql",
"t_arup_state_and_fed_dedup_bdc.sql",
"t_okup_post_challenge_locations.sql",
"r_orup_bead_post_disposition.sql",
"t_cpc_challenge_addresses_va.sql",
"t_nvup_cqa_v6_fcc_many_cats.sql",
"r_vaup_underserved.sql",
"r_vaup_unserved_cai.sql",
"t_okup_arpa.sql",
"t_wvup_fed_dedup_bdc.sql",
"t_fabric_sbo_v2_primary.sql",
"pg_cai_v5.sql",
"t_nvup_cqa_v6_fcc_many_cats_oct2023_dedupe.sql",
"r_vaup_unserved.sql",
],
"/home/ubuntu/airflow/dags/arc/final_proposal_ingest/stage3_locations_wip/SQL/lookups": [
"pg_select_app_ids_by_status.sql",
"pg_select_app_locations.sql",
"pg_select_app_location_answers.sql",
"ath_select_matched_applicants.sql",
],
"/home/ubuntu/airflow/dags/arc/demo_tenant/stage0_mock_data/dbt_project/models": [
"c_xy_fpmock_tile.sql",
"c_xy_fpmock_subgrantees.sql",
"c_xy_fpmock_supp_grantor_users.sql",
"c_xy_fpmock_supp_subgrant_agreements.sql",
"c_xy_fpmock_supp_reporting_projects.sql",
"c_xy_fpmock_supp_users.sql",
"c_xy_fpmock_no_bead_locations.sql",
"c_xy_fpmock_supp_deployment_reporting.sql",
"c_xy_fpmock_supp_reporting_project_cai.sql",
"c_xy_fpmock_locations.sql",
"c_xy_fpmock_deployment_projects_internal.sql",
"c_xy_fpmock_supp_reporting_project_locations.sql",
"c_xy_fpmock_cai.sql",
"c_xy_fpmock_deployment_projects.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/ut": [
"x_ut_datasme1755.sql"
],
"/home/ubuntu/airflow/dags/cpc/stage8_final_proposal_export/SQL/fp_no_bead_locations": [
"OK_customized_20260413.sql",
"OK_customized_20260416.sql",
"OK_customized_20260210.sql",
"OK_customized_20260317.sql",
"TX.sql",
"template.sql",
"OK_customized_20260506.sql",
"AZ.sql",
"MN.sql",
"OK_customized_20260515.sql",
"OK_customized.sql",
"MS.sql",
"AR.sql",
"IN_customized_20260409.sql",
"OK_customized_20260326.sql",
"IN.sql",
],
"/home/ubuntu/airflow/dags/bead/national_bead_aggregation/SQL": [
"upsert_db_table.sql",
"create_data_lake_table_county.sql",
"create_data_lake_table_state.sql",
"create_data_lake_table_congressional_district.sql",
"create_db_table.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/post_challenge_locations": [
"NM_post_challenges.sql",
"DE_post_challenge.sql",
"AR_post_challenges.sql",
"CT_post_challenge.sql",
"GU_post_challenge_no_latency.sql",
"XZ_post_challenges.sql",
"no_selection.sql",
"AL_post_challenge.sql",
"MS_post_challenges.sql",
"CA_post_challenge.sql",
"NV_post_challenge.sql",
"LA_post_challenge.sql",
],
"/home/ubuntu/airflow/dags/cpc/stage5_ntia_post_challenge/SQL/challenge_cai": [
"CT_challenge_cai.sql",
"DE_challenge_cai.sql",
"XZ_challenge_cai.sql",
"XZ_challenge_cai_no_trueup.sql",
"DC_challenge_cai.sql",
"MS_challenge_cai.sql",
"LA_challenge_cai.sql",
"OR_challenge_cai.sql",
"no_selection.sql",
"AR_challenge_cai.sql",
"GU_challenge_cai_no_latency.sql",
"ND_challenge_cai.sql",
"CA_challenge_cai.sql",
"OK_challenge_cai.sql",
"TX_challenge_cai.sql",
"NC_challenge_cai.sql",
],
"/home/ubuntu/airflow/dags/bedrock/data_comparison_agent/comparison/dbt_project/models/comparison": [
"comp_row_level.sql",
"comp_duplicates.sql",
"comp_row_counts.sql",
"comp_schema_diff.sql",
],
"/home/ubuntu/airflow/dags/superset/SQL": [
"superset_v3_v4_trueup_comparison.sql",
"superset_ffa_version_data_comparison.sql",
"superset_ffa_version_numbers.sql",
],
"/home/ubuntu/airflow/dags/tileserver/generate_public_map_tiles/SQL": [
"MS_latest_ffa_tile.sql",
"LA_latest_ffa_tile.sql",
],
"/home/ubuntu/airflow/dags/general/flat_file_exporter_dbt/dbt_project/models/ok": [
"x_ok_datasme_1438_project_cost_per_adding_net_id.sql",
"x_ok_datasme_1462_applications_per_net.sql",
"x_ok_datasme1433_missing_ppa_cai.sql",
"x_ok_datasme_1438_fp_cai.sql",
"x_ok_datasme2034_nepa_template.sql",
"x_ok_datasme1970.sql",
"x_ok_datasme_1524_fp_cai.sql",
"x_ok_datasme_1438_project_cost_per_ppa.sql",
"x_ok_datasme1422_funded_cai.sql",
"x_ok_datasme_1732_check_project_id.sql",
"x_ok_datasme_1438_deployment_projects.sql",
"x_ok_datasme_1513_check_project_id.sql",
"x_ok_datasme_1558_check_project_id.sql",
"x_ok_datasme_1521_check_project_id.sql",
"x_ok_datasme_1712_check_project_id.sql",
"x_ok_datasme_1524_fp_no_bead_locations.sql",
"x_ok_datasme_1524_fp_locations.sql",
"x_ok_datasme_1438_fp_locations.sql",
"x_ok_datasme_1524_fp_deployment_projects.sql",
"x_ok_datasme_2105_bead12.sql",
"x_ok_datasme1433_datavalidation.sql_",
"x_ok_datasme_1438_dup_location.sql",
"x_ok_datasme1422_eligible_cai.sql",
"x_ok_datasme_1531_check_project_integrity.sql",
"x_ok_datasme1422_eligible_locations.sql",
"x_ok_datasame_1438_identify_other_loc.sql",
],
"/home/ubuntu/airflow/dags/bedrock/data_comparison_agent/cleanup/SQL": [
"find_expired_tables.sql"
],
}
[docs]
def get_dag_sql_list(self, path: str, prefix: bool = False):
"""
Get the list of SQL files for a given DAG path. This is used for choosing an SQL query in the parameters.
:param path: The DAG path to look up.
:param prefix: If this is True, it will concatenate all paths that begin with the path instead of checking an exact match.
"""
if prefix:
return [
file
for key, files in self.SQL_FILES.items()
if key.startswith(path.rstrip("/"))
for file in files
]
return self.SQL_FILES.get(path.rstrip("/"), [])