• File size measurements show the distribution of size of files.
• Files are classified in four categories based on their size (lines of code): 1-100 (very small files), 101-200 (small files), 201-500 (medium size files), 501-1000 (long files), 1001+(very long files).
• It is a good practice to keep files small. Long files may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

• There are 143 files with 13,656 lines of code.
• 2 very long files (4,205 lines of code)
• 1 long files (564 lines of code)
• 4 medium size files (1,285 lines of codeclsfd_ftr_w_mp_ins)
• 20 small files (2,707 lines of code)
• 116 very small files (4,895 lines of code)

There are 59 files with lines longer than 120 characters. In total, there are 152 long lines.

File	# lines	# units	# long lines
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	44
schema.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	190	-	12
convert_frontend.sql in backfill/2024-04-29-fxa_events/frontend	83	-	4
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	80	-	3
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	80	-	3
fenix_query_before_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	3
fenix_query_after_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	3
desktop_query.sql in backfill/2022-01-27-sanitize-search-engines	51	-	3
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	3
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	3
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322	26	-	2
consolidate_all_sample_ids_kw.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	156	-	2
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322	49	-	2
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2
convert_backend.sql in backfill/2024-04-29-fxa_events/backend	64	-	2
checks.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	80	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	19	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	19	-	1
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	80	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	1
org_mozilla_ios_klar_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/klar_ios	18	-	1
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	19	-	1
org_mozilla_firefox_beta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	1
org_mozilla_fennec_aurora_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	1
org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	1
org_mozilla_ios_firefoxbeta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	1
org_mozilla_ios_firefox_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	1
org_mozilla_ios_fennec_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	1
org_mozilla_ios_focus_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_ios	18	-	1
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	56	-	1
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	19	-	1
backfill_clients_last_seen_v2_in_BQproject_backfill_1.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	167	3	1
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	1