path	# lines of code
backfill/2023-11-03-active_users_aggregates/focus_android_query.sql	113
backfill/2023-11-03-active_users_aggregates/klar_ios_query.sql	113
backfill/2023-11-03-active_users_aggregates/fenix_query.sql	117
backfill/2023-11-03-active_users_aggregates/firefox_ios_query.sql	117
backfill/2023-11-03-active_users_aggregates/focus_ios_query.sql	113
backfill/2023-09-26-initialize-clients_first_seen_v2/bigquery_etl_cli_query.py	1808
backfill/2023-09-26-initialize-clients_first_seen_v2/telemetry_derived_clients_first_seen_v2_query.sql	341
backfill/2023-08-03-firefox_ios_active_users_aggregates_v1/query.sql	116
backfill/2024-11-06-metrics-pings-metric-labels-over-max-length/insert_to_prod.py	78
backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/active_users/view.sql	181
backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322/init.sql	26
backfill/2024-03-23-clients_last_seen/klar_ios/klar_ios_baseline_clients_last_seen_20240325.sql	8
backfill/2024-03-23-clients_last_seen/klar_ios/org_mozilla_ios_klar_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/fenix/org_mozilla_fenix_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/fenix/org_mozilla_firefox_beta_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/fenix/org_mozilla_firefox_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/fenix/org_mozilla_fennec_aurora_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/fenix/fenix_baseline_clients_last_seen_20240325.sql	42
backfill/2024-03-23-clients_last_seen/fenix/org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/firefox_ios/org_mozilla_ios_firefoxbeta_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/firefox_ios/org_mozilla_ios_firefox_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/firefox_ios/org_mozilla_ios_fennec_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/firefox_ios/firefox_ios.baseline_clients_last_seen_20240325.sql	20
backfill/2024-03-23-clients_last_seen/focus_ios/focus_ios_baseline_clients_last_seen_20240325.sql	8
backfill/2024-03-23-clients_last_seen/focus_ios/org_mozilla_ios_focus_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/checks.sql	76
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/query.sql	162
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/clients_last_seen_v2_days_active_bits.sql	45
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/consolidate_all_sample_ids_kw.sql	156
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/consolidate_all_sample_ids.sql	32
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/metadata.yaml	55
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/backfill_clients_last_seen_v2_in_BQproject_backfill_1.py	167
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/schema.yaml	2397
backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322/backfill_clients_last_seen_v2.py	151
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322/checks.sql	49
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/klar_android/klar_android_baseline_clients_last_seen_20240325.sql	8
backfill/2024-03-23-clients_last_seen/klar_android/org_mozilla_ios_klar_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/focus_android/focus_android_baseline_clients_last_seen_20240325.sql	20
backfill/2024-03-23-clients_last_seen/focus_android/org_mozilla_focus_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/focus_android/org_mozilla_focus_beta_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/focus_android/org_mozilla_focus_nightly_baseline_clients_last_seen_20240325.sql	18
backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits/query.sql	45
backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits/metadata.yaml	20
backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits/schema.yaml	13
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322/checks.sql	80
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322/query.sql	56
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322/init.sql	19
backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322/metadata.yaml	28
backfill/2020-01-12-crash-ping/append_to_prod.sql	40
backfill/2023-08-03-fenix_active_users_aggregates_v1/query.sql	116
backfill/2024-07-15-fenix_active_users_aggregates_v3/mobile_schema.yaml	85
backfill/2024-07-15-fenix_active_users_aggregates_v3/fenix_query_before_2024.sql	122
backfill/2024-07-15-fenix_active_users_aggregates_v3/fenix_query_after_2024.sql	122
backfill/2025-01-22-firefox-installer schema-error/duplicates1.sql	8
backfill/2025-01-22-firefox-installer schema-error/null_field_ratio.sql	317
backfill/2025-01-22-firefox-installer schema-error/duplicates2.sql	34
backfill/2022-01-27-sanitize-search-engines/desktop_query.sql	51
backfill/2022-01-27-sanitize-search-engines/org_mozilla_firefox_incremental.sql	143
backfill/2022-01-27-sanitize-search-engines/org_mozilla_fenix.sql	146
backfill/2020-03-19-replay-payload-bytes-decoded/query.sql	36
backfill/2020-03-30-gcs-error/verify_activity_stream_events.sql	41
backfill/2020-02-24-crash-ping/crash_v4_with_missing_fields.sql	21
backfill/2024-04-26-active_users_aggregates/desktop_schema.yaml	79
backfill/2024-04-26-active_users_aggregates/mobile_schema.yaml	85
backfill/2024-04-26-active_users_aggregates/focus_android_query.sql	96
backfill/2024-04-26-active_users_aggregates/klar_ios_query.sql	90
backfill/2024-04-26-active_users_aggregates/fenix_query.sql	122
backfill/2024-04-26-active_users_aggregates/desktop_query.sql	100
backfill/2024-04-26-active_users_aggregates/firefox_ios_query.sql	94
backfill/2024-04-26-active_users_aggregates/focus_ios_query.sql	90
backfill/2024-04-29-fxa_events/backfill_accounts_backend_events_v1.py	22
backfill/2024-04-29-fxa_events/frontend/backfill_frontend_events.py	22
backfill/2024-04-29-fxa_events/frontend/convert_frontend.sql	83
backfill/2024-04-29-fxa_events/backend/users_services_daily_v2.sql	117
backfill/2024-04-29-fxa_events/backend/backfill_backend_users_services_daily.py	22
backfill/2024-04-29-fxa_events/backend/backfill_backend_events.py	22
backfill/2024-04-29-fxa_events/backend/convert_backend.sql	64
backfill/2023-08-03-firefox_desktop_active_users_aggregates_v1/query.sql	123
backfill/2024-05-07-telemetry-pings-os-distro/generate_statements.py	24
backfill/2024-05-07-telemetry-pings-os-distro/dedupe_pings.sql	372
backfill/2024-05-07-telemetry-pings-os-distro/final_insert.sql	96
backfill/2024-07-29-clients-first-seen-v3/query.sql	255
backfill/2020-04-14-copy-dedupe-failure/query.sql	36
backfill/2022-08-15-clients-first-seen/backfill.py	57
backfill/2024_10_10_kwindau_clients_first_seen_v2/checks.sql	26
backfill/2024_10_10_kwindau_clients_first_seen_v2/query.sql	564
backfill/2024_10_10_kwindau_clients_first_seen_v2/metadata.yaml	9
backfill/2024_10_10_kwindau_clients_first_seen_v2/schema.yaml	190