mozilla / bigquery-backfill - File Age & Freshness

File age measurements show the distribution of file ages (days since the first commit) and the file freshness (days since the latest commit).

Summary

Number of files: 143
Daily file updates (only one update per file and date counted): 302
First update: 2020-01-16
Latest update: 2025-01-24
Days between first and latest update: 1,836 (262 weeks, estimated 1,310 working days)
Active days (at least one file change): 108
Data:

Organized per file

File Change History Overall

File Age Distribution Overall

Days since first update

There are 143 files with 13,656 lines of code in files.

118 files that are 366+ days old (11,207 lines of code)
22 files that are 181-365 days old (2,090 lines of code)
3 files that are 91-180 days old (359 lines of code)
0 files that are 31-90 days old (0 lines of code)
0 files that are 1-30 days old (0 lines of code)

Legend:

366+

181-365

91-180

31-90

1-30

explore: grouped by folders | grouped by age

File Freshness Distribution Overall

Days since last update

There are 143 files with 13,656 lines of code in files.

111 files have been last changed 366+ days ago (10,583 lines of code)
29 files have been last changed 181-365 days ago (2,714 lines of code)
3 files have been last changed 91-180 days ago (359 lines of code)
0 files have been last changed 31-90 days ago (0 lines of code)
0 files have been last changed 1-30 days ago (0 lines of code)

Legend:

366+

181-365

91-180

31-90

1-30

explore: grouped by folders | grouped by freshness

File Change History per File Extension

sql, md, yaml, sh, py, txt, json, diff

File Age Distribution per Extension

Days since first update

366+

181-365

91-180

31-90

1-30

File Freshness Distribution per Extension

Days since last update

366+

181-365

91-180

31-90

1-30

File Change History per Logical Decomposition

primary

primary (file age distribution)

Days since first update

366+

181-365

91-180

31-90

1-30

primary (file freshness distribution)

Days since last update

366+

181-365

91-180

31-90

1-30

Oldest Files (Top 50)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
append_to_prod.sql in backfill/2020-01-12-crash-ping	40	-	2020-01-16	2020-01-16	1	1	jeff@klukas.net	jeff@klukas.net
crash_v4_with_missing_fields.sql in backfill/2020-02-24-crash-ping	21	-	2020-02-27	2020-02-27	1	1	wlachance@mozilla.com	wlachance@mozilla.com
query.sql in backfill/2020-03-19-replay-payload-bytes-decoded	36	-	2020-03-26	2020-03-31	2	1	jeff@klukas.net	jeff@klukas.net
verify_activity_stream_events.sql in backfill/2020-03-30-gcs-error	41	-	2020-04-01	2020-04-01	1	1	amiyaguchi@mozilla.com	amiyaguchi@mozilla.com
query.sql in backfill/2020-04-14-copy-dedupe-failure	36	-	2020-04-15	2020-04-15	1	1	jeff@klukas.net	jeff@klukas.net
desktop_query.sql in backfill/2022-01-27-sanitize-search-engines	51	-	2022-01-28	2022-03-09	2	2	jeff@klukas.net	jklukas@mozilla.com
org_mozilla_fenix.sql in backfill/2022-01-27-sanitize-search-engines	146	-	2022-02-16	2022-03-09	4	2	jeff@klukas.net	jklukas@mozilla.com
org_mozilla_firefox_incremental.sql in backfill/2022-01-27-sanitize-search-engines	143	-	2022-02-17	2022-03-09	2	2	jeff@klukas.net	jklukas@mozilla.com
backfill.py in backfill/2022-08-15-clients-first-seen	57	2	2022-08-15	2022-08-16	2	1	anna@scholtzan.net	anna@scholtzan.net
query.sql in backfill/2023-08-03-firefox_desktop_active_users_aggregates_v1	123	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
query.sql in backfill/2023-08-03-firefox_ios_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
query.sql in backfill/2023-08-03-fenix_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	3	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
bigquery_etl_cli_query.py in backfill/2023-09-26-initialize-clients_first_seen_v2	1808	27	2023-09-26	2023-11-03	2	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	2023-09-26	2023-11-03	4	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	2024-03-23	2024-03-27	4	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	162	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	80	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	76	-	2024-03-23	2024-03-26	3	2	alvargasa@gmail.com	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/firefox_desktop_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	55	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...

Files Not Recently Changed (Top 50)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
append_to_prod.sql in backfill/2020-01-12-crash-ping	40	-	2020-01-16	2020-01-16	1	1	jeff@klukas.net	jeff@klukas.net
crash_v4_with_missing_fields.sql in backfill/2020-02-24-crash-ping	21	-	2020-02-27	2020-02-27	1	1	wlachance@mozilla.com	wlachance@mozilla.com
query.sql in backfill/2020-03-19-replay-payload-bytes-decoded	36	-	2020-03-26	2020-03-31	2	1	jeff@klukas.net	jeff@klukas.net
verify_activity_stream_events.sql in backfill/2020-03-30-gcs-error	41	-	2020-04-01	2020-04-01	1	1	amiyaguchi@mozilla.com	amiyaguchi@mozilla.com
query.sql in backfill/2020-04-14-copy-dedupe-failure	36	-	2020-04-15	2020-04-15	1	1	jeff@klukas.net	jeff@klukas.net
desktop_query.sql in backfill/2022-01-27-sanitize-search-engines	51	-	2022-01-28	2022-03-09	2	2	jeff@klukas.net	jklukas@mozilla.com
org_mozilla_firefox_incremental.sql in backfill/2022-01-27-sanitize-search-engines	143	-	2022-02-17	2022-03-09	2	2	jeff@klukas.net	jklukas@mozilla.com
org_mozilla_fenix.sql in backfill/2022-01-27-sanitize-search-engines	146	-	2022-02-16	2022-03-09	4	2	jeff@klukas.net	jklukas@mozilla.com
backfill.py in backfill/2022-08-15-clients-first-seen	57	2	2022-08-15	2022-08-16	2	1	anna@scholtzan.net	anna@scholtzan.net
query.sql in backfill/2023-08-03-fenix_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	3	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
query.sql in backfill/2023-08-03-firefox_ios_active_users_aggregates_v1	116	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
query.sql in backfill/2023-08-03-firefox_desktop_active_users_aggregates_v1	123	-	2023-08-03	2023-09-26	2	2	akommasani@mozilla.com	88394696+alekhyamoz@users.n...
telemetry_derived_clients_first_seen_v2_query.sql in backfill/2023-09-26-initialize-clients_first_seen_v2	341	-	2023-09-26	2023-11-03	4	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
bigquery_etl_cli_query.py in backfill/2023-09-26-initialize-clients_first_seen_v2	1808	27	2023-09-26	2023-11-03	2	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2023-11-03-active_users_aggregates	113	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2023-11-03-active_users_aggregates	117	-	2023-11-03	2024-01-09	3	2	lvargas@mozilla.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	28	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefoxbeta_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_firefox_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_fennec_derived_baseline_clients_last_seen_v1_20240322	56	-	2024-03-23	2024-03-23	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
klar_android_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/klar_android	8	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
focus_ios_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_ios	8	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
klar_ios_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/klar_ios	8	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_focus_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_android	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_focus_beta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_android	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_focus_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_android	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_klar_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/klar_android	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_focus_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/focus_ios	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_fennec_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_firefox_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_firefoxbeta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_ios_klar_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/klar_ios	18	-	2024-03-25	2024-03-25	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_klar_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_firefox_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_klar_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_nightly_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_focus_beta_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_ios_focus_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fennec_aurora_derived_baseline_clients_last_seen_v1_20240322	19	-	2024-03-23	2024-03-25	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...

Most Recently Created Files (Top 50)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
null_field_ratio.sql in backfill/2025-01-22-firefox-installer schema-error	317	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
duplicates2.sql in backfill/2025-01-22-firefox-installer schema-error	34	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
duplicates1.sql in backfill/2025-01-22-firefox-installer schema-error	8	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
insert_to_prod.py in backfill/2024-11-06-metrics-pings-metric-labels-over-max-length	78	4	2024-11-08	2024-11-08	1	1	anna@scholtzan.net	anna@scholtzan.net
query.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	564	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
schema.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	190	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
checks.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	26	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
metadata.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	9	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
convert_frontend.sql in backfill/2024-04-29-fxa_events/frontend	83	-	2024-07-31	2024-07-31	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
backfill_frontend_events.py in backfill/2024-04-29-fxa_events/frontend	22	1	2024-07-31	2024-07-31	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
query.sql in backfill/2024-07-29-clients-first-seen-v3	255	-	2024-07-29	2024-07-30	2	2	mhirose@mozilla.com	92952117+marlene-m-hirose@u...
fenix_query_before_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query_after_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
mobile_schema.yaml in backfill/2024-07-15-fenix_active_users_aggregates_v3	85	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
mobile_schema.yaml in backfill/2024-04-26-active_users_aggregates	85	-	2024-05-17	2024-05-28	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_schema.yaml in backfill/2024-04-26-active_users_aggregates	79	-	2024-05-17	2024-05-21	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
clients_last_seen_v2_days_active_bits.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	45	-	2024-05-15	2024-05-15	1	1	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
users_services_daily_v2.sql in backfill/2024-04-29-fxa_events/backend	117	-	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
convert_backend.sql in backfill/2024-04-29-fxa_events/backend	64	-	2024-05-14	2024-05-15	2	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
query.sql in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	45	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
backfill_accounts_backend_events_v1.py in backfill/2024-04-29-fxa_events	22	1	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
backfill_backend_users_services_daily.py in backfill/2024-04-29-fxa_events/backend	22	1	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
backfill_backend_events.py in backfill/2024-04-29-fxa_events/backend	22	1	2024-05-14	2024-05-15	2	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	20	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
schema.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	13	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
dedupe_pings.sql in backfill/2024-05-07-telemetry-pings-os-distro	372	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
final_insert.sql in backfill/2024-05-07-telemetry-pings-os-distro	96	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
generate_statements.py in backfill/2024-05-07-telemetry-pings-os-distro	24	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
consolidate_all_sample_ids_kw.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	156	-	2024-05-02	2024-05-08	5	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
consolidate_all_sample_ids.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	32	-	2024-05-01	2024-07-11	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	2024-04-26	2024-07-11	9	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
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	2024-04-17	2024-04-17	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	80	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	56	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	28	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	19	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
backfill_clients_last_seen_v2.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	151	3	2024-03-27	2024-04-03	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	42	-	2024-03-27	2024-04-03	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
org_mozilla_fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_firefox_beta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_firefox_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_fennec_aurora_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-04-09	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
view.sql in backfill/2024-03-23-clients_last_seen/active_users	181	-	2024-03-25	2024-04-14	5	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
firefox_ios.baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	20	-	2024-03-25	2024-04-09	2	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com

Most Recently Changed Files (Top 50)

File	# lines	# units	created	last modified	# changes (days)	# contributors	first contributor	latest contributor
null_field_ratio.sql in backfill/2025-01-22-firefox-installer schema-error	317	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
duplicates2.sql in backfill/2025-01-22-firefox-installer schema-error	34	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
duplicates1.sql in backfill/2025-01-22-firefox-installer schema-error	8	-	2025-01-24	2025-01-24	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
insert_to_prod.py in backfill/2024-11-06-metrics-pings-metric-labels-over-max-length	78	4	2024-11-08	2024-11-08	1	1	anna@scholtzan.net	anna@scholtzan.net
query.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	564	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
schema.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	190	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
checks.sql in backfill/2024_10_10_kwindau_clients_first_seen_v2	26	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
metadata.yaml in backfill/2024_10_10_kwindau_clients_first_seen_v2	9	-	2024-10-16	2024-10-16	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
convert_frontend.sql in backfill/2024-04-29-fxa_events/frontend	83	-	2024-07-31	2024-07-31	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
backfill_frontend_events.py in backfill/2024-04-29-fxa_events/frontend	22	1	2024-07-31	2024-07-31	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
query.sql in backfill/2024-07-29-clients-first-seen-v3	255	-	2024-07-29	2024-07-30	2	2	mhirose@mozilla.com	92952117+marlene-m-hirose@u...
fenix_query_before_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query_after_2024.sql in backfill/2024-07-15-fenix_active_users_aggregates_v3	122	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
mobile_schema.yaml in backfill/2024-07-15-fenix_active_users_aggregates_v3	85	-	2024-07-15	2024-07-16	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_query.sql in backfill/2024-04-26-active_users_aggregates	122	-	2024-04-26	2024-07-11	9	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_query.sql in backfill/2024-04-26-active_users_aggregates	100	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_android_query.sql in backfill/2024-04-26-active_users_aggregates	96	-	2024-04-26	2024-07-11	7	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
firefox_ios_query.sql in backfill/2024-04-26-active_users_aggregates	94	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
klar_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
focus_ios_query.sql in backfill/2024-04-26-active_users_aggregates	90	-	2024-04-26	2024-07-11	6	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
consolidate_all_sample_ids.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	32	-	2024-05-01	2024-07-11	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
mobile_schema.yaml in backfill/2024-04-26-active_users_aggregates	85	-	2024-05-17	2024-05-28	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
desktop_schema.yaml in backfill/2024-04-26-active_users_aggregates	79	-	2024-05-17	2024-05-21	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
convert_backend.sql in backfill/2024-04-29-fxa_events/backend	64	-	2024-05-14	2024-05-15	2	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
clients_last_seen_v2_days_active_bits.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	45	-	2024-05-15	2024-05-15	1	1	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
backfill_backend_events.py in backfill/2024-04-29-fxa_events/backend	22	1	2024-05-14	2024-05-15	2	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
users_services_daily_v2.sql in backfill/2024-04-29-fxa_events/backend	117	-	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
query.sql in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	45	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
backfill_accounts_backend_events_v1.py in backfill/2024-04-29-fxa_events	22	1	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
backfill_backend_users_services_daily.py in backfill/2024-04-29-fxa_events/backend	22	1	2024-05-14	2024-05-14	1	2	akkomar@users.noreply.githu...	akomarzewski@mozilla.com
metadata.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	20	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
schema.yaml in backfill/2024-03-23-clients_last_seen/kwindau_testing_20240514/Step2/kwindau_days_active_bits	13	-	2024-05-14	2024-05-14	1	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
dedupe_pings.sql in backfill/2024-05-07-telemetry-pings-os-distro	372	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
final_insert.sql in backfill/2024-05-07-telemetry-pings-os-distro	96	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
generate_statements.py in backfill/2024-05-07-telemetry-pings-os-distro	24	-	2024-05-10	2024-05-10	1	1	12437227+benwu@users.norepl...	12437227+benwu@users.norepl...
consolidate_all_sample_ids_kw.sql in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	156	-	2024-05-02	2024-05-08	5	1	153020235+kwindau@users.nor...	153020235+kwindau@users.nor...
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	2024-04-17	2024-04-17	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
view.sql in backfill/2024-03-23-clients_last_seen/active_users	181	-	2024-03-25	2024-04-14	5	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
checks.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	80	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
query.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	56	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
metadata.yaml in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	28	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322	26	-	2024-03-23	2024-04-09	4	2	alvargasa@gmail.com	alvargasa@gmail.com
firefox_ios.baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/firefox_ios	20	-	2024-03-25	2024-04-09	2	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
init.sql in backfill/2024-03-23-clients_last_seen/org_mozilla_fenix_nightly_derived_baseline_clients_last_seen_v1_20240322_active_bits	19	-	2024-04-04	2024-04-09	2	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
org_mozilla_fenix_nightly_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-04-09	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
backfill_clients_last_seen_v2.py in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	151	3	2024-03-27	2024-04-03	4	2	alvargasa@gmail.com	30448600+lucia-vargas-a@use...
fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	42	-	2024-03-27	2024-04-03	3	2	30448600+lucia-vargas-a@use...	30448600+lucia-vargas-a@use...
schema.yaml in backfill/2024-03-23-clients_last_seen/telemetry_derived_clients_last_seen_v2_20240322	2397	-	2024-03-23	2024-03-27	4	2	alvargasa@gmail.com	alvargasa@gmail.com
org_mozilla_fenix_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com
org_mozilla_firefox_beta_baseline_clients_last_seen_20240325.sql in backfill/2024-03-23-clients_last_seen/fenix	18	-	2024-03-27	2024-03-27	1	2	30448600+lucia-vargas-a@use...	alvargasa@gmail.com