mozilla / bigquery-etl
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 4,708 files with 252,454 lines of code.
    • 4 files changed more than 100 times (5,082 lines of code)
    • 4 files changed 51-100 times (3,132 lines of code)
    • 34 files changed 21-50 times (20,118 lines of code)
    • 387 files changed 6-20 times (49,904 lines of code)
    • 4,279 files changed 1-5 times (174,218 lines of code)
2% | 1% | 7% | 19% | 69%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 4,708 files with 252,454 lines of code.
    • 3 files changed by more than 25 contributors (3,121 lines of code)
    • 18 files changed by 11-25 contributors (18,351 lines of code)
    • 97 files changed by 6-10 contributors (13,416 lines of code)
    • 1,692 files changed by 2-5 contributors (106,599 lines of code)
    • 2,898 files changed by 1 contributor (110,967 lines of code)
1% | 7% | 5% | 42% | 43%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
yaml, sql, py, md, json, jinja, toml, sh, js, html, ini, txt, dockerignore, zsh, in, cfg, gitignore
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
yaml2% | 0% | 11% | 6% | 79%
py8% | 4% | 24% | 33% | 29%
sql0% | 1% | <1% | 28% | 69%
in0% | 100% | 0% | 0% | 0%
toml0% | 0% | 0% | 12% | 87%
jinja0% | 0% | 0% | 0% | 100%
js0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
ROOT94% | 2% | 0% | 3% | 0%
bigquery_etl12% | 7% | 32% | 37% | 10%
sql0% | <1% | 6% | 17% | 75%
sql_generators0% | 0% | 4% | 23% | 71%
script0% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 50)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)
# contributorsfirst
contributor
latest
contributor
dags.yaml
in root
2168 - 2020-05-13 2025-05-09 228 50 anna@scholtzan.net edugomfilho@gmail.com
query.py
in bigquery_etl/cli
1961 30 2020-07-23 2025-02-20 164 24 anna@scholtzan.net 153020235+kwindau@users.nor...
dryrun.py
in bigquery_etl
474 18 2020-07-03 2025-02-18 149 30 anna@scholtzan.net 12437227+benwu@users.norepl...
479 - 2023-07-06 2025-05-07 126 26 anna@scholtzan.net 12437227+benwu@users.norepl...
task.py
in bigquery_etl/query_scheduling
545 31 2020-04-20 2025-01-13 88 14 anna@scholtzan.net anna@scholtzan.net
config.py
in bigquery_etl/shredder
852 16 2020-01-23 2025-03-28 83 17 dthorn@mozilla.com 153020235+kwindau@users.nor...
60 - 2020-02-12 2025-03-13 70 14 dthorn@mozilla.com 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
1675 - 2020-09-30 2025-01-29 53 15 anna@scholtzan.net 88394696+alekhyamoz@users.n...
utils.py
in bigquery_etl/cli
194 13 2020-08-21 2024-11-20 42 14 anna@scholtzan.net anna@scholtzan.net
delete.py
in bigquery_etl/shredder
710 14 2020-01-23 2025-02-27 39 6 dthorn@mozilla.com akkomar@users.noreply.githu...
__init__.py
in bigquery_etl/cli
68 1 2020-07-23 2024-09-12 38 10 anna@scholtzan.net anna@scholtzan.net
parse_metadata.py
in bigquery_etl/metadata
355 22 2020-04-29 2025-02-20 38 15 anna@scholtzan.net 153020235+kwindau@users.nor...
common.py
in sql_generators/glean_usage
403 14 2021-12-10 2025-02-13 38 10 anna@scholtzan.net akkomar@users.noreply.githu...
stage.py
in bigquery_etl/cli
482 8 2023-02-22 2024-11-08 38 8 anna@scholtzan.net 12437227+benwu@users.norepl...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
2348 - 2021-02-10 2024-08-07 38 13 anna@scholtzan.net 153020235+kwindau@users.nor...
dag.py
in bigquery_etl/query_scheduling
197 20 2020-04-20 2025-04-16 37 12 anna@scholtzan.net 12437227+benwu@users.norepl...
backfill.py
in bigquery_etl/cli
709 11 2023-06-01 2025-03-12 35 6 10429026+wwyc@users.noreply... 12437227+benwu@users.norepl...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_joined_v1
2151 - 2021-05-06 2024-08-08 35 13 anna@scholtzan.net 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_joined_v1
2384 - 2021-05-05 2024-08-07 35 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
__init__.py
in bigquery_etl/view
335 22 2021-07-22 2024-10-29 34 9 anna@scholtzan.net anna@scholtzan.net
query.sql
in sql/moz-fx-data-shared-prod/mozilla_vpn_derived/all_subscriptions_v1
375 - 2021-04-22 2024-01-11 34 3 dthorn@mozilla.com 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1
2397 - 2021-05-05 2024-08-07 34 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
generate_airflow_dags.py
in bigquery_etl/query_scheduling
124 2 2020-04-20 2024-10-10 33 8 anna@scholtzan.net 42538694+kik-kik@users.nore...
generate.py
in bigquery_etl/glam
260 2 2020-04-03 2024-09-04 33 8 amiyaguchi@mozilla.com edugomfilho@gmail.com
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v1
2350 - 2021-05-05 2024-08-07 32 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
dag.py
in bigquery_etl/cli
211 5 2020-08-21 2025-02-24 31 9 anna@scholtzan.net 197825729+ogzillla@users.no...
dependency.py
in bigquery_etl
207 8 2021-02-17 2024-10-31 30 9 dthorn@mozilla.com anna@scholtzan.net
dag_collection.py
in bigquery_etl/query_scheduling
123 11 2020-04-21 2024-10-03 29 7 anna@scholtzan.net 42538694+kik-kik@users.nore...
__init__.py
in bigquery_etl/schema
313 20 2021-02-10 2024-10-31 27 6 anna@scholtzan.net anna@scholtzan.net
dryrun.py
in bigquery_etl/cli
126 2 2020-08-24 2025-01-29 26 6 anna@scholtzan.net 12437227+benwu@users.norepl...
sql.py
in bigquery_etl/pytest_plugin
173 8 2019-10-08 2024-04-10 26 9 dthorn@mozilla.com anna@scholtzan.net
common.py
in bigquery_etl/util
247 10 2020-06-03 2025-01-06 26 9 msamuel@mozilla.com 12437227+benwu@users.norepl...
tokenizer.py
in bigquery_etl/format_sql
739 4 2020-01-07 2025-04-21 26 4 dthorn@mozilla.com 1994030+sean-rose@users.nor...
format.py
in bigquery_etl/format_sql
95 4 2020-08-26 2025-04-17 25 12 anna@scholtzan.net 1994030+sean-rose@users.nor...
view.py
in bigquery_etl/cli
337 11 2020-10-19 2024-10-30 25 6 amiyaguchi@mozilla.com anna@scholtzan.net
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
43 - 2020-09-30 2025-02-05 24 13 anna@scholtzan.net 88394696+alekhyamoz@users.n...
glean_app_ping_views.py
in sql_generators/glean_usage
182 3 2021-12-10 2025-03-27 24 4 anna@scholtzan.net 12437227+benwu@users.norepl...
query.sql
in sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1
607 - 2022-12-13 2024-06-27 23 6 30448600+lucia-vargas-a@use... anna@scholtzan.net
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1
42 - 2020-09-30 2025-04-08 22 12 anna@scholtzan.net akkomar@users.noreply.githu...
__init__.py
in sql_generators/glean_usage
165 2 2021-12-10 2024-12-04 22 6 anna@scholtzan.net 42538694+kik-kik@users.nore...
__init__.py
in sql_generators/stable_views
317 3 2021-12-21 2025-04-08 22 7 anna@scholtzan.net 12437227+benwu@users.norepl...
validate_metadata.py
in bigquery_etl/metadata
349 12 2020-04-29 2025-02-25 22 11 anna@scholtzan.net anna@scholtzan.net
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/unified_metrics_v1
352 - 2021-10-12 2024-06-27 20 5 anna@scholtzan.net anna@scholtzan.net
query.py
in sql/moz-fx-data-experiments/monitoring/experimenter_experiments_v1
182 5 2020-10-09 2025-02-19 19 8 anna@scholtzan.net 102263964+mikewilli@users.n...
__init__.py
in bigquery_etl/stripe
198 3 2020-09-24 2024-03-21 19 3 dthorn@mozilla.com anicholson@mozilla.com
utils.py
in bigquery_etl/backfill
274 15 2023-06-09 2025-03-12 19 5 10429026+wwyc@users.noreply... 12437227+benwu@users.norepl...
event_monitoring_live.py
in sql_generators/glean_usage
288 5 2023-11-01 2025-05-07 19 5 anna@scholtzan.net 12437227+benwu@users.norepl...
query.sql
in sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8
353 - 2020-09-30 2024-08-19 19 11 anna@scholtzan.net 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1
615 - 2023-05-25 2025-01-30 19 6 anicholson@mozilla.com 107562575+m-d-bowerman@user...
view.sql
in sql/moz-fx-data-shared-prod/firefox_accounts/fxa_content_auth_stdout_events
60 - 2021-11-18 2024-02-28 18 6 dthorn@mozilla.com 1994030+sean-rose@users.nor...
Files With Most Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)
# contributorsfirst
contributor
latest
contributor
dags.yaml
in root
2168 - 2020-05-13 2025-05-09 228 50 anna@scholtzan.net edugomfilho@gmail.com
dryrun.py
in bigquery_etl
474 18 2020-07-03 2025-02-18 149 30 anna@scholtzan.net 12437227+benwu@users.norepl...
479 - 2023-07-06 2025-05-07 126 26 anna@scholtzan.net 12437227+benwu@users.norepl...
query.py
in bigquery_etl/cli
1961 30 2020-07-23 2025-02-20 164 24 anna@scholtzan.net 153020235+kwindau@users.nor...
config.py
in bigquery_etl/shredder
852 16 2020-01-23 2025-03-28 83 17 dthorn@mozilla.com 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
1675 - 2020-09-30 2025-01-29 53 15 anna@scholtzan.net 88394696+alekhyamoz@users.n...
parse_metadata.py
in bigquery_etl/metadata
355 22 2020-04-29 2025-02-20 38 15 anna@scholtzan.net 153020235+kwindau@users.nor...
task.py
in bigquery_etl/query_scheduling
545 31 2020-04-20 2025-01-13 88 14 anna@scholtzan.net anna@scholtzan.net
60 - 2020-02-12 2025-03-13 70 14 dthorn@mozilla.com 153020235+kwindau@users.nor...
utils.py
in bigquery_etl/cli
194 13 2020-08-21 2024-11-20 42 14 anna@scholtzan.net anna@scholtzan.net
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
2348 - 2021-02-10 2024-08-07 38 13 anna@scholtzan.net 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_joined_v1
2151 - 2021-05-06 2024-08-08 35 13 anna@scholtzan.net 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_joined_v1
2384 - 2021-05-05 2024-08-07 35 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1
2397 - 2021-05-05 2024-08-07 34 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v1
2350 - 2021-05-05 2024-08-07 32 13 jklukas@mozilla.com 153020235+kwindau@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6
43 - 2020-09-30 2025-02-05 24 13 anna@scholtzan.net 88394696+alekhyamoz@users.n...
dag.py
in bigquery_etl/query_scheduling
197 20 2020-04-20 2025-04-16 37 12 anna@scholtzan.net 12437227+benwu@users.norepl...
format.py
in bigquery_etl/format_sql
95 4 2020-08-26 2025-04-17 25 12 anna@scholtzan.net 1994030+sean-rose@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1
42 - 2020-09-30 2025-04-08 22 12 anna@scholtzan.net akkomar@users.noreply.githu...
validate_metadata.py
in bigquery_etl/metadata
349 12 2020-04-29 2025-02-25 22 11 anna@scholtzan.net anna@scholtzan.net
query.sql
in sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8
353 - 2020-09-30 2024-08-19 19 11 anna@scholtzan.net 153020235+kwindau@users.nor...
common.py
in sql_generators/glean_usage
403 14 2021-12-10 2025-02-13 38 10 anna@scholtzan.net akkomar@users.noreply.githu...
__init__.py
in bigquery_etl/cli
68 1 2020-07-23 2024-09-12 38 10 anna@scholtzan.net anna@scholtzan.net
metadata.yaml
in sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8
29 - 2020-09-30 2025-02-04 14 10 anna@scholtzan.net 88394696+alekhyamoz@users.n...
__init__.py
in bigquery_etl/view
335 22 2021-07-22 2024-10-29 34 9 anna@scholtzan.net anna@scholtzan.net
dag.py
in bigquery_etl/cli
211 5 2020-08-21 2025-02-24 31 9 anna@scholtzan.net 197825729+ogzillla@users.no...
dependency.py
in bigquery_etl
207 8 2021-02-17 2024-10-31 30 9 dthorn@mozilla.com anna@scholtzan.net
sql.py
in bigquery_etl/pytest_plugin
173 8 2019-10-08 2024-04-10 26 9 dthorn@mozilla.com anna@scholtzan.net
common.py
in bigquery_etl/util
247 10 2020-06-03 2025-01-06 26 9 msamuel@mozilla.com 12437227+benwu@users.norepl...
metadata.yaml
in sql/moz-fx-data-shared-prod/search_derived/search_clients_last_seen_v1
33 - 2020-09-30 2025-02-04 14 9 anna@scholtzan.net 88394696+alekhyamoz@users.n...
metadata.yaml
in sql/moz-fx-data-shared-prod/search_derived/search_aggregates_v8
19 - 2020-09-30 2024-12-11 13 9 anna@scholtzan.net cmorales@mozilla.com
stage.py
in bigquery_etl/cli
482 8 2023-02-22 2024-11-08 38 8 anna@scholtzan.net 12437227+benwu@users.norepl...
generate.py
in bigquery_etl/glam
260 2 2020-04-03 2024-09-04 33 8 amiyaguchi@mozilla.com edugomfilho@gmail.com
generate_airflow_dags.py
in bigquery_etl/query_scheduling
124 2 2020-04-20 2024-10-10 33 8 anna@scholtzan.net 42538694+kik-kik@users.nore...
query.py
in sql/moz-fx-data-experiments/monitoring/experimenter_experiments_v1
182 5 2020-10-09 2025-02-19 19 8 anna@scholtzan.net 102263964+mikewilli@users.n...
query.sql
in sql/moz-fx-data-shared-prod/search_derived/search_revenue_levers_daily_v1
366 - 2023-02-01 2024-10-02 18 8 cmorales@mozilla.com 107562575+m-d-bowerman@user...
query.sql
in sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1
390 - 2021-05-05 2024-06-27 18 8 12437227+benwu@users.norepl... anna@scholtzan.net
metadata.yaml
in sql/moz-fx-data-shared-prod/internet_outages/global_outages_v1
61 - 2020-09-30 2024-07-26 13 8 anna@scholtzan.net 33942105+lelilia@users.nore...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/events_daily_v1
23 - 2020-11-12 2025-02-05 13 8 fbertsch@mozilla.com 88394696+alekhyamoz@users.n...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/urlbar_clients_daily_v1
174 - 2021-09-01 2024-08-21 12 8 teon.brooks@gmail.com 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_scalar_probe_counts_v1
349 - 2020-09-30 2024-05-13 12 8 anna@scholtzan.net edugomfilho@gmail.com
metadata.yaml
in sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1
29 - 2020-09-30 2025-02-04 11 8 anna@scholtzan.net 88394696+alekhyamoz@users.n...
view.sql
in sql/moz-fx-data-shared-prod/search/mobile_search_clients_engines_sources_daily
144 - 2021-05-19 2025-04-23 11 8 jeff@klukas.net 42538694+kik-kik@users.nore...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/addon_aggregates_v2
23 - 2020-09-30 2025-02-04 10 8 anna@scholtzan.net 88394696+alekhyamoz@users.n...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_joined_v1
33 - 2021-01-25 2025-02-05 10 8 jklukas@mozilla.com 88394696+alekhyamoz@users.n...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/addons_v2
25 - 2020-09-30 2025-02-04 9 8 anna@scholtzan.net 88394696+alekhyamoz@users.n...
dag_collection.py
in bigquery_etl/query_scheduling
123 11 2020-04-21 2024-10-03 29 7 anna@scholtzan.net 42538694+kik-kik@users.nore...
__init__.py
in sql_generators/stable_views
317 3 2021-12-21 2025-04-08 22 7 anna@scholtzan.net 12437227+benwu@users.norepl...
routine.py
in bigquery_etl/cli
331 9 2020-10-15 2024-01-24 18 7 anna@scholtzan.net 1994030+sean-rose@users.nor...
generate.py
in bigquery_etl/cli
109 2 2021-12-10 2025-04-09 18 7 anna@scholtzan.net 12437227+benwu@users.norepl...
Files With Least Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)
# contributorsfirst
contributor
latest
contributor
templating.yaml
in sql_generators/use_counters/templates
2584 - 2023-12-29 2025-03-19 2 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
view.sql
in sql/moz-fx-data-shared-prod/telemetry/rocket_android_events_v1
1406 - 2020-09-30 2024-06-27 2 1 anna@scholtzan.net anna@scholtzan.net
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/nonprod_fxa_gcp_stderr_events_v1
1361 - 2023-09-21 2023-09-21 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/docker_fxa_customs_sanitized_v2
1137 - 2023-09-29 2023-09-29 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_gcp_stderr_events_v1
1134 - 2023-09-13 2023-09-13 1 1 akkomar@users.noreply.githu... akkomar@users.noreply.githu...
schema.yaml
in sql/moz-fx-data-shared-prod/sumo_ga_derived/ga3_events_v1
1063 - 2024-09-12 2024-09-12 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
shredder_mitigation.py
in bigquery_etl/backfill
779 13 2024-08-05 2024-12-03 7 1 30448600+lucia-vargas-a@use... 30448600+lucia-vargas-a@use...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/nonprod_fxa_auth_events_v1
727 - 2023-06-21 2023-06-21 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
query.sql
in sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_nightly__clients_daily_histogram_aggregates_metrics_v1
682 - 2020-10-22 2021-07-13 4 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
query.sql
in sql/glam-fenix-dev/glam_etl/org_mozilla_fennec_aurora__clients_daily_histogram_aggregates_metrics_v1
682 - 2020-10-22 2021-08-20 4 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
schema.yaml
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_subscriptions_history_v2
622 - 2023-06-30 2024-03-08 5 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/docker_fxa_customs_sanitized_v1
596 - 2023-09-29 2023-09-29 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_subscriptions_v2
580 - 2023-12-14 2024-03-08 2 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/search_derived/search_dau_aggregates_v1
574 - 2024-08-14 2024-08-14 1 1 88394696+alekhyamoz@users.n... 88394696+alekhyamoz@users.n...
script.sql
in sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v2
562 - 2024-02-05 2024-09-10 6 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/internet_outages/global_outages_v2
513 - 2024-07-26 2024-07-26 1 1 33942105+lelilia@users.nore... 33942105+lelilia@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_content_events_v1
511 - 2023-06-22 2023-06-22 1 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/subscription_platform_derived/service_subscription_events_v1
485 - 2025-03-20 2025-03-20 1 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/nonprod_fxa_gcp_stdout_events_v1
481 - 2023-09-21 2023-09-21 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_subscriptions_history_v1
478 - 2023-06-02 2024-10-25 8 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/nonprod_fxa_content_events_v1
466 - 2023-06-21 2023-06-21 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_gcp_stdout_events_v1
463 - 2023-09-13 2023-09-13 1 1 akkomar@users.noreply.githu... akkomar@users.noreply.githu...
schema.yaml
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_subscriptions_revised_changelog_v1
447 - 2023-06-30 2024-03-08 4 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_subscriptions_revised_changelog_v1
441 - 2023-06-30 2024-11-07 8 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/subscription_platform_derived/logical_subscription_events_v1
438 - 2023-08-18 2024-11-14 2 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
view.sql
in sql/moz-fx-data-shared-prod/telemetry/first_shutdown_summary_v4
415 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
schema.yaml
in sql/moz-fx-data-shared-prod/stripe_external/subscriptions_changelog_v1
407 - 2023-07-11 2023-08-04 2 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/fx_accounts_active_daily_clients_v1
377 - 2025-02-21 2025-04-09 3 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/nonprod_fxa_stdout_events_v1
376 - 2023-06-21 2023-06-21 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
query.sql
in sql/moz-fx-data-shared-prod/mozilla_org_derived/downloads_with_attribution_v2
373 - 2024-07-17 2024-07-17 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_ios_derived/feature_usage_events_v1
373 - 2023-12-15 2024-04-08 3 1 39603590+rhythmofrain63@use... 39603590+rhythmofrain63@use...
udf.sql
in sql/moz-fx-data-shared-prod/udf/main_summary_scalars
353 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
query.py
in sql/moz-fx-data-shared-prod/cloudflare_derived/browser_usage_v1
348 4 2024-06-08 2025-03-24 9 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.py
in sql/moz-fx-data-shared-prod/cloudflare_derived/device_usage_v1
346 7 2024-06-11 2025-03-21 7 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/nonprod_stripe_subscriptions_history_v1
342 - 2023-06-02 2024-10-25 4 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/cohort_weekly_statistics_v1
334 - 2025-03-04 2025-03-21 3 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/mozilla_org_derived/downloads_with_attribution_v1
331 - 2024-07-17 2024-07-17 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/mozilla_org_derived/www_site_page_metrics_v1
327 - 2024-07-15 2024-07-15 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/mozilla_org_derived/www_site_hits_v2
319 - 2024-08-07 2024-08-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
query.sql
in sql/moz-fx-data-shared-prod/mozilla_vpn_derived/site_metrics_summary_v2
311 - 2024-03-18 2024-03-18 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_logical_subscriptions_history_v1
310 - 2023-08-18 2024-11-14 4 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.py
in sql/moz-fx-data-shared-prod/cloudflare_derived/os_usage_v1
304 4 2024-06-13 2024-10-03 6 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
attribution_clients.query.sql
in sql_generators/mobile_kpi_support_metrics/templates
298 - 2024-07-30 2024-10-16 4 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
query.sql
in sql/moz-fx-data-shared-prod/stripe_external/subscriptions_changelog_v1
298 - 2023-07-11 2024-11-14 6 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/fenix_derived/feature_usage_metrics_v2
290 - 2025-01-21 2025-01-29 2 1 vsabino@mozilla.com vsabino@mozilla.com
export_to_parquet.py
in script/legacy
289 3 2022-07-07 2022-07-07 1 1 anna@scholtzan.net anna@scholtzan.net
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/service_subscriptions_history_v1
283 - 2025-03-20 2025-03-20 1 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_customers_revised_changelog_v1
283 - 2023-07-31 2024-11-07 3 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
udf.sql
in sql/mozfun/iap/parse_apple_receipt
274 - 2021-02-04 2022-12-16 2 1 dthorn@mozilla.com dthorn@mozilla.com
query.sql
in sql/moz-fx-data-shared-prod/firefox_ios_derived/feature_usage_metrics_v2
261 - 2025-01-21 2025-01-29 2 1 vsabino@mozilla.com vsabino@mozilla.com