mozilla / bigquery-etl
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
File Change History Overall
File Age Distribution Overall
Days since first update
  • There are 4,708 files with 252,454 lines of code in files.
    • 3,365 files that are 366+ days old (194,681 lines of code)
    • 474 files that are 181-365 days old (27,441 lines of code)
    • 618 files that are 91-180 days old (19,576 lines of code)
    • 216 files that are 31-90 days old (9,887 lines of code)
    • 35 files that are 1-30 days old (869 lines of code)
77% | 10% | 7% | 3% | <1%
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 4,708 files with 252,454 lines of code in files.
    • 2,422 files have been last changed 366+ days ago (97,776 lines of code)
    • 862 files have been last changed 181-365 days ago (79,104 lines of code)
    • 948 files have been last changed 91-180 days ago (39,129 lines of code)
    • 378 files have been last changed 31-90 days ago (27,190 lines of code)
    • 98 files have been last changed 1-30 days ago (9,255 lines of code)
38% | 31% | 15% | 10% | 3%
Legend:
366+
181-365
91-180
31-90
1-30

explore: grouped by folders | grouped by freshness
File Change History per File Extension
yaml, sql, py, md, json, jinja, toml, sh, js, html, ini, txt, dockerignore, zsh, in, cfg, gitignore
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
sql79% | 10% | 7% | 2% | <1%
yaml76% | 10% | 8% | 4% | <1%
py76% | 14% | 3% | 5% | 0%
toml45% | 29% | 24% | 0% | 0%
js100% | 0% | 0% | 0% | 0%
in100% | 0% | 0% | 0% | 0%
jinja0% | 0% | 0% | 100% | 0%
File Freshness Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
sql41% | 36% | 15% | 4% | 1%
yaml40% | 29% | 16% | 9% | 3%
py24% | 15% | 13% | 36% | 9%
js100% | 0% | 0% | 0% | 0%
toml1% | 59% | 0% | 25% | 12%
jinja0% | 0% | 0% | 97% | 2%
in0% | 0% | 0% | 100% | 0%
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
sql76% | 10% | 8% | 4% | <1%
bigquery_etl89% | 10% | 0% | <1% | 0%
sql_generators66% | 15% | 11% | 5% | <1%
ROOT100% | 0% | 0% | 0% | 0%
script100% | 0% | 0% | 0% | 0%
primary (file freshness distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
sql43% | 34% | 14% | 6% | 1%
bigquery_etl21% | 15% | 15% | 36% | 11%
sql_generators14% | 25% | 23% | 27% | 9%
script100% | 0% | 0% | 0% | 0%
ROOT2% | 0% | 0% | 2% | 94%
Oldest Files (Top 50)
File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
__init__.py
in bigquery_etl
 4 - 2019-06-07 2024-02-19 4 4 anna@scholtzan.net 30448600+lucia-vargas-a@use...
64 7 2019-10-01 2023-05-17 15 2 dthorn@mozilla.com dthorn@mozilla.com
sql.py
in bigquery_etl/pytest_plugin
 173 8 2019-10-08 2024-04-10 26 9 dthorn@mozilla.com anna@scholtzan.net
flake8.py
in bigquery_etl/pytest_plugin/script_lint
 14 1 2019-10-08 2020-09-02 2 1 dthorn@mozilla.com dthorn@mozilla.com
docstyle.py
in bigquery_etl/pytest_plugin/script_lint
 12 1 2019-10-08 2021-02-24 3 1 dthorn@mozilla.com dthorn@mozilla.com
mypy.py
in bigquery_etl/pytest_plugin/script_lint
 9 2 2019-10-08 2021-02-24 3 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/pytest_plugin/script_lint
 7 1 2019-10-08 2019-10-08 1 1 dthorn@mozilla.com dthorn@mozilla.com
black.py
in bigquery_etl/pytest_plugin/script_lint
 6 1 2019-10-08 2020-09-02 2 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/pytest_plugin
 1 - 2019-10-08 2019-10-08 1 1 dthorn@mozilla.com dthorn@mozilla.com
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...
formatter.py
in bigquery_etl/format_sql
 249 10 2020-01-07 2024-02-07 12 5 dthorn@mozilla.com 1994030+sean-rose@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...
delete.py
in bigquery_etl/shredder
 710 14 2020-01-23 2025-02-27 39 6 dthorn@mozilla.com akkomar@users.noreply.githu...
search.py
in bigquery_etl/shredder
 96 3 2020-01-23 2021-02-24 3 1 dthorn@mozilla.com dthorn@mozilla.com
client_queue.py
in bigquery_etl/util
 34 3 2020-01-23 2024-09-16 3 2 dthorn@mozilla.com 12437227+benwu@users.norepl...
clients_scalar_aggregates_v1.sql
in bigquery_etl/glam/templates
 111 - 2020-02-12 2025-03-12 12 4 amiyaguchi@mozilla.com edugomfilho@gmail.com
60 - 2020-02-12 2025-03-13 70 14 dthorn@mozilla.com 153020235+kwindau@users.nor...
bigquery_id.py
in bigquery_etl/util
 8 3 2020-02-18 2020-05-20 2 1 dthorn@mozilla.com dthorn@mozilla.com
probe_counts_v1.sql
in bigquery_etl/glam/templates
 138 - 2020-02-19 2024-12-06 14 3 amiyaguchi@mozilla.com edugomfilho@gmail.com
latest_versions_v1.sql
in bigquery_etl/glam/templates
 20 - 2020-02-19 2023-06-14 7 2 amiyaguchi@mozilla.com linhnguyen@mozilla.com
clients_scalar_aggregates_v1.init.sql
in bigquery_etl/glam/templates
 12 - 2020-02-19 2022-06-13 4 2 amiyaguchi@mozilla.com akkomar@users.noreply.githu...
132 5 2020-02-26 2024-08-26 12 6 amiyaguchi@mozilla.com edugomfilho@gmail.com
clients_daily_scalar_aggregates_v1.sql
in bigquery_etl/glam/templates
 111 - 2020-02-26 2023-10-13 5 4 amiyaguchi@mozilla.com edugomfilho@gmail.com
clients_daily_histogram_aggregates_v1.sql
in bigquery_etl/glam/templates
 132 - 2020-03-18 2024-12-04 8 4 amiyaguchi@mozilla.com edugomfilho@gmail.com
114 4 2020-03-18 2024-12-04 9 6 amiyaguchi@mozilla.com edugomfilho@gmail.com
clients_histogram_aggregates_v1.sql
in bigquery_etl/glam/templates
 102 - 2020-03-18 2025-03-12 12 5 amiyaguchi@mozilla.com edugomfilho@gmail.com
utils.py
in bigquery_etl/glam
 78 5 2020-03-18 2024-12-06 8 3 amiyaguchi@mozilla.com edugomfilho@gmail.com
clients_histogram_aggregates_v1.init.sql
in bigquery_etl/glam/templates
 26 - 2020-03-18 2020-10-22 4 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
exceptions.py
in bigquery_etl/util
 5 1 2020-03-18 2020-03-18 1 1 dthorn@mozilla.com dthorn@mozilla.com
standard_args.py
in bigquery_etl/util
 148 15 2020-03-25 2023-07-11 7 2 dthorn@mozilla.com anna@scholtzan.net
bigquery_tables.py
in bigquery_etl/util
 43 2 2020-03-30 2020-09-02 2 2 anna@scholtzan.net dthorn@mozilla.com
publish_public_data_views.py
in bigquery_etl/public_data
 35 2 2020-03-30 2023-07-11 3 2 anna@scholtzan.net anna@scholtzan.net
generate.py
in bigquery_etl/glam
 260 2 2020-04-03 2024-09-04 33 8 amiyaguchi@mozilla.com edugomfilho@gmail.com
publish_gcs_metadata.py
in bigquery_etl/public_data
 176 9 2020-04-03 2023-07-11 14 3 anna@scholtzan.net anna@scholtzan.net
models.py
in bigquery_etl/glam
 120 7 2020-04-03 2024-07-25 14 4 amiyaguchi@mozilla.com edugomfilho@gmail.com
clients_scalar_aggregates_v1.udf.sql
in bigquery_etl/glam/templates
 70 - 2020-04-03 2020-05-28 2 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
view_clients_daily_scalar_aggregates_v1.sql
in bigquery_etl/glam/templates
 9 - 2020-04-03 2020-10-22 3 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
9 - 2020-04-03 2020-10-22 3 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
publish_json.py
in bigquery_etl/public_data
 253 8 2020-04-14 2024-04-25 14 3 anna@scholtzan.net 12437227+benwu@users.norepl...
extract_probe_counts_v1.sql
in bigquery_etl/glam/templates
 131 - 2020-04-14 2024-07-26 17 4 amiyaguchi@mozilla.com edugomfilho@gmail.com
view_user_counts_v1.sql
in bigquery_etl/glam/templates
 31 - 2020-04-14 2024-05-08 5 2 amiyaguchi@mozilla.com edugomfilho@gmail.com
extract_user_counts_v1.sql
in bigquery_etl/glam/templates
 21 - 2020-04-14 2020-11-04 6 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
view_probe_counts_v1.sql
in bigquery_etl/glam/templates
 19 - 2020-04-14 2024-07-25 4 2 amiyaguchi@mozilla.com edugomfilho@gmail.com
task.py
in bigquery_etl/query_scheduling
 545 31 2020-04-20 2025-01-13 88 14 anna@scholtzan.net anna@scholtzan.net
dag.py
in bigquery_etl/query_scheduling
 197 20 2020-04-20 2025-04-16 37 12 anna@scholtzan.net 12437227+benwu@users.norepl...
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...
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...
parse_metadata.py
in bigquery_etl/metadata
 355 22 2020-04-29 2025-02-20 38 15 anna@scholtzan.net 153020235+kwindau@users.nor...
validate_metadata.py
in bigquery_etl/metadata
 349 12 2020-04-29 2025-02-25 22 11 anna@scholtzan.net anna@scholtzan.net
publish_metadata.py
in bigquery_etl/metadata
 114 3 2020-04-29 2024-11-27 14 6 anna@scholtzan.net cmorales@mozilla.com
Files Not Recently Changed (Top 50)
File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
__init__.py
in bigquery_etl/pytest_plugin
 1 - 2019-10-08 2019-10-08 1 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/pytest_plugin/script_lint
 7 1 2019-10-08 2019-10-08 1 1 dthorn@mozilla.com dthorn@mozilla.com
exceptions.py
in bigquery_etl/util
 5 1 2020-03-18 2020-03-18 1 1 dthorn@mozilla.com dthorn@mozilla.com
bigquery_id.py
in bigquery_etl/util
 8 3 2020-02-18 2020-05-20 2 1 dthorn@mozilla.com dthorn@mozilla.com
clients_scalar_aggregates_v1.udf.sql
in bigquery_etl/glam/templates
 70 - 2020-04-03 2020-05-28 2 1 amiyaguchi@mozilla.com amiyaguchi@mozilla.com
__init__.py
in bigquery_etl/public_data
 1 - 2020-09-02 2020-09-02 1 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/metadata
 1 - 2020-09-02 2020-09-02 1 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/query_scheduling
 1 - 2020-09-02 2020-09-02 1 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/shredder
 1 - 2020-09-02 2020-09-02 1 1 dthorn@mozilla.com dthorn@mozilla.com
__init__.py
in bigquery_etl/glam
 1 - 2020-09-02 2020-09-02 1 1 dthorn@mozilla.com dthorn@mozilla.com
black.py
in bigquery_etl/pytest_plugin/script_lint
 6 1 2019-10-08 2020-09-02 2 1 dthorn@mozilla.com dthorn@mozilla.com
flake8.py
in bigquery_etl/pytest_plugin/script_lint
 14 1 2019-10-08 2020-09-02 2 1 dthorn@mozilla.com dthorn@mozilla.com
bigquery_tables.py
in bigquery_etl/util
 43 2 2020-03-30 2020-09-02 2 2 anna@scholtzan.net dthorn@mozilla.com
udf.sql
in sql/moz-fx-data-shared-prod/udf/histogram_merge
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/bitmask_lowest_7
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/bitmask_365
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/map_sum
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/mode_last
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/json_extract_histogram
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/zero_as_365_bits
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/json_mode_last
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/histogram_to_mean
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/json_extract_int_map
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/one_as_365_bits
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/histogram_to_threshold_count
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/bitmask_lowest_28
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/array_of_12_zeroes
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/mode_last_retain_nulls
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/normalize_glean_ping_info
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/normalize_metadata
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/normalize_os
 3 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/glean_timespan_seconds
 5 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/glean_timespan_nanos
 5 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
to_iso8601.sql
in sql/moz-fx-data-shared-prod/udf_legacy
 6 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
date_format.sql
in sql/moz-fx-data-shared-prod/udf_legacy
 6 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/histogram_percentiles
 6 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
udf.sql
in sql/moz-fx-data-shared-prod/udf/normalize_glean_baseline_client_info
 6 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/messaging_system/cfr_users_daily
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/messaging_system/snippets_users_daily
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/messaging_system/onboarding_users_daily
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/search/search_clients_last_seen
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/pocket/pocket_reach_mau
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/ssl_ratios
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/crash_aggregates_v1
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/telemetry_ip_privacy_parquet
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/crash_summary
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/buildhub2
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/events
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/telemetry/addon_names
 7 - 2020-09-30 2020-09-30 1 1 anna@scholtzan.net anna@scholtzan.net
Most Recently Created Files (Top 50)
File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 133 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
view.sql
in sql/moz-fx-data-shared-prod/glean_telemetry/active_users_aggregates
 75 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 57 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 24 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 24 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 23 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 22 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
view.sql
in sql/moz-fx-data-shared-prod/telemetry/active_users_rollup_shredder
 19 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
udf.sql
in sql/mozfun/norm/partnership
 14 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
view.sql
in sql/moz-fx-data-shared-prod/telemetry/ech_adoption_rate
 7 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
metadata.yaml
in sql/mozfun/norm/partnership
 4 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/glean_telemetry
 11 - 2025-05-08 2025-05-08 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee
 9 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_employee_id_to_team
 6 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
event_monitoring_live_v1.script.sql
in sql_generators/glean_usage/templates
 3 - 2025-05-07 2025-05-07 1 1 12437227+benwu@users.norepl... 12437227+benwu@users.norepl...
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_employee_id_to_team
 2 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee
 2 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 113 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
query.sql
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 44 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 23 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/mozsoc_ml_prod_articles_zyte_cache
 16 - 2025-05-05 2025-05-07 2 1 jpetto@users.noreply.github... jpetto@users.noreply.github...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/mozsoc_ml_prod_rss_news
 16 - 2025-05-05 2025-05-07 2 1 jpetto@users.noreply.github... jpetto@users.noreply.github...
backfill.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 9 - 2025-05-05 2025-05-06 2 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
udf.sql
in sql/mozfun/json/from_map_json
 28 - 2025-04-21 2025-04-21 1 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
metadata.yaml
in sql/mozfun/json/from_map_json
 3 - 2025-04-21 2025-04-21 1 1 1994030+sean-rose@users.nor... 1994030+sean-rose@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/nimbus_recorded_targeting_context_v1
 60 - 2025-04-16 2025-04-17 2 1 chumphreys@mozilla.com chumphreys@mozilla.com
query.sql
in sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/nimbus_recorded_targeting_context_v1
 45 - 2025-04-16 2025-04-16 1 1 chumphreys@mozilla.com chumphreys@mozilla.com
view.sql
in sql/moz-fx-data-shared-prod/org_mozilla_fenix/nimbus_recorded_targeting_context
 23 - 2025-04-16 2025-04-21 2 1 chumphreys@mozilla.com chumphreys@mozilla.com
view.sql
in sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox/nimbus_recorded_targeting_context
 23 - 2025-04-16 2025-04-21 2 1 chumphreys@mozilla.com chumphreys@mozilla.com
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_cost_center_to_steering_committee
 12 - 2025-04-16 2025-04-17 2 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee_to_group_name
 9 - 2025-04-16 2025-04-17 2 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
metadata.yaml
in sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/nimbus_recorded_targeting_context_v1
 3 - 2025-04-16 2025-04-16 1 1 chumphreys@mozilla.com chumphreys@mozilla.com
metadata.yaml
in sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/nimbus_recorded_targeting_context_v1
 3 - 2025-04-16 2025-04-16 1 1 chumphreys@mozilla.com chumphreys@mozilla.com
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee_to_group_name
 2 - 2025-04-16 2025-04-16 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_cost_center_to_steering_committee
 2 - 2025-04-16 2025-04-16 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
usage_reporting_clients_last_seen_v1.bigconfig.yml.jinja
in sql_generators/usage_reporting/templates
 27 - 2025-04-11 2025-04-11 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/health_twilio_v1
 25 - 2025-04-11 2025-04-11 1 1 wclouser@mozilla.com wclouser@mozilla.com
usage_reporting_clients_daily_v1.bigconfig.yml.jinja
in sql_generators/usage_reporting/templates
 24 - 2025-04-11 2025-04-11 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
usage_reporting_clients_first_seen_v1.bigconfig.yml.jinja
in sql_generators/usage_reporting/templates
 22 - 2025-04-11 2025-04-11 1 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
usage_reporting_active_users_aggregates_v1.bigconfig.yml.jinja
in sql_generators/usage_reporting/templates
 21 - 2025-04-11 2025-04-22 2 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_accounts_derived/health_twilio_v1
 12 - 2025-04-11 2025-04-11 1 1 wclouser@mozilla.com wclouser@mozilla.com
event_monitoring_aggregates_v1.schema.yaml
in sql_generators/glean_usage/templates
 40 - 2025-04-10 2025-04-10 1 1 12437227+benwu@users.norepl... 12437227+benwu@users.norepl...
udf.sql
in sql/mozfun/norm/glean_client_info_attribution
 54 - 2025-04-08 2025-04-08 1 1 12437227+benwu@users.norepl... 12437227+benwu@users.norepl...
metadata.yaml
in sql/mozfun/norm/glean_client_info_attribution
 4 - 2025-04-08 2025-04-08 1 1 12437227+benwu@users.norepl... 12437227+benwu@users.norepl...
udf.sql
in sql/mozfun/newtab/scheduled_surface_id_v1
 93 - 2025-04-07 2025-04-07 1 1 gkatre@users.noreply.github... gkatre@users.noreply.github...
query.sql
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/newtab_items_daily_v1
 84 - 2025-04-07 2025-04-07 1 1 gkatre@users.noreply.github... gkatre@users.noreply.github...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/newtab_items_daily_v1
 79 - 2025-04-07 2025-04-07 1 1 gkatre@users.noreply.github... gkatre@users.noreply.github...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/newtab_items_daily_v1
 27 - 2025-04-07 2025-04-07 1 1 gkatre@users.noreply.github... gkatre@users.noreply.github...
metadata.yaml
in sql/mozfun/newtab/scheduled_surface_id_v1
 2 - 2025-04-07 2025-04-07 1 1 gkatre@users.noreply.github... gkatre@users.noreply.github...
backfill.yaml
in sql/moz-fx-data-shared-prod/focus_android_derived/usage_reporting_active_users_aggregates_v1
 8 - 2025-04-03 2025-04-09 2 1 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
Most Recently Changed Files (Top 50)
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.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 133 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
view.sql
in sql/moz-fx-data-shared-prod/glean_telemetry/active_users_aggregates
 75 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 57 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 24 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/active_users_rollup_shredder_v1
 24 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 23 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
schema.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/ech_adoption_rate_v1
 22 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
view.sql
in sql/moz-fx-data-shared-prod/telemetry/active_users_rollup_shredder
 19 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
udf.sql
in sql/mozfun/norm/partnership
 14 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
view.sql
in sql/moz-fx-data-shared-prod/telemetry/ech_adoption_rate
 7 - 2025-05-09 2025-05-09 1 1 edugomfilho@gmail.com edugomfilho@gmail.com
metadata.yaml
in sql/mozfun/norm/partnership
 4 - 2025-05-09 2025-05-09 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
baseline_clients_first_seen_v1.query.sql
in sql_generators/glean_usage/templates
 222 - 2021-12-10 2025-05-08 12 5 anna@scholtzan.net 153020235+kwindau@users.nor...
baseline_clients_first_seen_v1.schema.yaml
in sql_generators/glean_usage/templates
 55 - 2024-04-10 2025-05-08 3 2 anna@scholtzan.net 153020235+kwindau@users.nor...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/glean_telemetry
 11 - 2025-05-08 2025-05-08 1 1 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
479 - 2023-07-06 2025-05-07 126 26 anna@scholtzan.net 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...
usage_reporting.py
in sql_generators/usage_reporting
 247 5 2025-03-20 2025-05-07 5 2 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
events_stream_v1.query.sql
in sql_generators/glean_usage/templates
 150 - 2024-01-16 2025-05-07 14 6 anna@scholtzan.net anna@scholtzan.net
event_monitoring_live_v1.materialized_view.sql
in sql_generators/glean_usage/templates
 69 - 2024-03-28 2025-05-07 7 3 anna@scholtzan.net 12437227+benwu@users.norepl...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v1
 22 - 2025-02-21 2025-05-07 3 2 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
event_monitoring_live_v1.metadata.yaml
in sql_generators/glean_usage/templates
 19 - 2023-11-01 2025-05-07 3 2 anna@scholtzan.net 12437227+benwu@users.norepl...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/mozsoc_ml_prod_articles_zyte_cache
 16 - 2025-05-05 2025-05-07 2 1 jpetto@users.noreply.github... jpetto@users.noreply.github...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/mozsoc_ml_prod_rss_news
 16 - 2025-05-05 2025-05-07 2 1 jpetto@users.noreply.github... jpetto@users.noreply.github...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry/socorro_crash_v2
 14 - 2023-12-07 2025-05-07 4 4 frank.bertsch@gmail.com 102263964+mikewilli@users.n...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry/socorro_crash
 14 - 2023-12-07 2025-05-07 4 4 frank.bertsch@gmail.com 102263964+mikewilli@users.n...
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee
 9 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
udf.sql
in sql/moz-fx-data-shared-prod/udf/hr_employee_id_to_team
 6 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
event_monitoring_live_v1.script.sql
in sql_generators/glean_usage/templates
 3 - 2025-05-07 2025-05-07 1 1 12437227+benwu@users.norepl... 12437227+benwu@users.norepl...
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_employee_id_to_team
 2 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
metadata.yaml
in sql/moz-fx-data-shared-prod/udf/hr_steering_committee
 2 - 2025-05-07 2025-05-07 1 1 92952117+marlene-m-hirose@u... 92952117+marlene-m-hirose@u...
view.sql
in sql/moz-fx-data-shared-prod/firefox_desktop/baseline_active_users_aggregates
 33 - 2025-02-21 2025-05-06 5 3 153020235+kwindau@users.nor... 197825729+ogzillla@users.no...
backfill.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 9 - 2025-05-05 2025-05-06 2 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
schema.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 113 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
query.sql
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 44 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_desktop_derived/baseline_active_users_aggregates_v2
 23 - 2025-05-05 2025-05-05 1 1 197825729+ogzillla@users.no... 197825729+ogzillla@users.no...
metadata.yaml
in sql/moz-fx-data-shared-prod/telemetry_derived/sponsored_tiles_clients_daily_v1
 5 - 2022-10-31 2025-05-05 9 7 16420065+skahmann3@users.no... cmorales@mozilla.com
android_onboarding.toml
in sql_generators/funnels/configs
 277 - 2023-12-14 2025-05-02 5 4 leifdoines@gmail.com anna@scholtzan.net
view.sql
in sql/moz-fx-data-shared-prod/firefox_desktop/baseline_active_users
 124 - 2025-02-07 2025-05-02 6 3 gkatre@users.noreply.github... 153020235+kwindau@users.nor...
baseline_clients_last_seen_v1.schema.yaml
in sql_generators/glean_usage/templates
 121 - 2024-05-23 2025-05-02 7 4 42538694+kik-kik@users.nore... 153020235+kwindau@users.nor...
baseline_clients_last_seen_v1.query.sql
in sql_generators/glean_usage/templates
 94 - 2021-12-10 2025-05-02 14 6 anna@scholtzan.net 153020235+kwindau@users.nor...
baseline_clients_daily_v1.query.sql
in sql_generators/glean_usage/templates
 197 - 2021-12-10 2025-05-01 16 7 anna@scholtzan.net 153020235+kwindau@users.nor...
baseline_clients_daily_v1.schema.yaml
in sql_generators/glean_usage/templates
 132 - 2024-05-23 2025-05-01 7 4 42538694+kik-kik@users.nore... 153020235+kwindau@users.nor...
dataset_metadata.yaml
in sql/moz-fx-data-shared-prod/crash_ping_ingest_external
 15 - 2025-03-11 2025-05-01 2 2 whd@users.noreply.github.com alex.franchuk@gmail.com
view.sql
in sql/moz-fx-data-shared-prod/org_mozilla_broken_site_report/user_reports_live
 75 - 2024-03-22 2025-04-28 4 3 kberezina@mozilla.com dschubert@mozilla.com
view.sql
in sql/moz-fx-data-shared-prod/telemetry/desktop_active_users
 65 - 2024-05-24 2025-04-28 5 2 153020235+kwindau@users.nor... 153020235+kwindau@users.nor...
query.sql
in sql/moz-fx-data-shared-prod/fivetran_costs_derived/incremental_mar_v1
 26 - 2023-01-31 2025-04-28 4 2 33942105+lelilia@users.nore... 1994030+sean-rose@users.nor...
metadata.yaml
in sql/moz-fx-data-shared-prod/firefox_ios_derived/clients_activation_v1
 27 - 2023-12-05 2025-04-25 4 2 42538694+kik-kik@users.nore... 42538694+kik-kik@users.nore...
config.py
in bigquery_etl
 27 4 2023-07-06 2025-04-24 2 2 anna@scholtzan.net 42538694+kik-kik@users.nore...
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...