Path	Lines of Code
CODE_OF_CONDUCT.md	6
CONTRIBUTING.md	9
GRAVEYARD.md	58
README.md	38
bigeye_credentials.ini	4
bigquery_etl/alchemer/response.schema.json	134
bigquery_etl/stripe/payout_reconciliation.itemized.5.schema.json	154
bigquery_etl/stripe/tax.transactions.itemized.1.schema.json	154
pytest.ini	25
requirements.txt	2535
script/glam/README.md	85
script/legacy/2019-05-14-armagaddon/README.md	2
script/legacy/2020-05-28-firefox-accounts-refactor/README.md	1
sql/moz-fx-data-shared-prod/static/README.md	16
sql/moz-fx-data-shared-prod/udf/pseudonymize_ad_id/README.md	6
sql/moz-fx-data-shared-prod/udf_legacy/README.md	2
sql/mozfun/README.md	2
sql/mozfun/addons/is_adblocker/README.md	15
sql/mozfun/bits28/README.md	14
sql/mozfun/bits28/active_in_range/README.md	1
sql/mozfun/bits28/days_since_seen/README.md	1
sql/mozfun/bits28/examples/bits28_days_since_seen.sql	2
sql/mozfun/bits28/examples/extract_week_specific_bits.sql	7
sql/mozfun/bits28/examples/string_bit_patterns.sql	2
sql/mozfun/bits28/from_string/README.md	1
sql/mozfun/bits28/range/README.md	1
sql/mozfun/bits28/retention/README.md	1
sql/mozfun/bits28/to_dates/README.md	1
sql/mozfun/bits28/to_string/README.md	1
sql/mozfun/bytes/README.md	1
sql/mozfun/bytes/bit_pos_to_byte_pos/README.md	1
sql/mozfun/bytes/extract_bits/README.md	1
sql/mozfun/bytes/zero_right/README.md	1
sql/mozfun/event_analysis/README.md	16
sql/mozfun/event_analysis/aggregate_match_strings/README.md	1
sql/mozfun/event_analysis/create_count_steps_query/README.md	1
sql/mozfun/event_analysis/create_events_view/README.md	185
sql/mozfun/event_analysis/create_funnel_regex/README.md	1
sql/mozfun/event_analysis/create_funnel_steps_query/README.md	1
sql/mozfun/event_analysis/escape_metachars/README.md	1
sql/mozfun/event_analysis/event_index_to_match_string/README.md	1
sql/mozfun/event_analysis/event_property_index_to_match_string/README.md	1
sql/mozfun/event_analysis/event_property_value_to_match_string/README.md	1
sql/mozfun/event_analysis/extract_event_counts/README.md	12
sql/mozfun/event_analysis/extract_event_counts_with_properties/README.md	17
sql/mozfun/event_analysis/get_count_sql/README.md	1
sql/mozfun/event_analysis/get_funnel_steps_sql/README.md	1
sql/mozfun/ga/nullify_string/README.md	1
sql/mozfun/glam/README.md	1
sql/mozfun/glam/build_hour_to_datetime/README.md	1
sql/mozfun/glam/build_seconds_to_hour/README.md	1
sql/mozfun/glam/fenix_build_to_build_hour/README.md	1
sql/mozfun/glam/histogram_bucket_from_value/README.md	1
sql/mozfun/glam/histogram_buckets_cast_string_array/README.md	1
sql/mozfun/glam/histogram_cast_json/README.md	1
sql/mozfun/glam/histogram_cast_struct/README.md	1
sql/mozfun/glam/histogram_fill_buckets/README.md	1
sql/mozfun/glam/histogram_fill_buckets_dirichlet/README.md	1
sql/mozfun/glam/histogram_filter_high_values/README.md	1
sql/mozfun/glam/histogram_from_buckets_uniform/README.md	1
sql/mozfun/glam/histogram_generate_exponential_buckets/README.md	1
sql/mozfun/glam/histogram_generate_functional_buckets/README.md	1
sql/mozfun/glam/histogram_generate_linear_buckets/README.md	1
sql/mozfun/glam/histogram_generate_scalar_buckets/README.md	1
sql/mozfun/glam/histogram_normalized_sum/README.md	1
sql/mozfun/glam/histogram_normalized_sum_with_original/README.md	1
sql/mozfun/glam/map_from_array_offsets/README.md	1
sql/mozfun/glam/map_from_array_offsets_precise/README.md	1
sql/mozfun/glam/percentile/README.md	1
sql/mozfun/glean/README.md	2
sql/mozfun/glean/legacy_compatible_experiments/README.md	2
sql/mozfun/glean/parse_datetime/README.md	1
sql/mozfun/glean/timespan_nanos/README.md	1
sql/mozfun/glean/timespan_seconds/README.md	1
sql/mozfun/google_ads/extract_segments_from_campaign_name/README.md	8
sql/mozfun/google_search_console/README.md	2
sql/mozfun/google_search_console/classify_site_query/README.md	1
sql/mozfun/google_search_console/extract_url_country_code/README.md	1
sql/mozfun/google_search_console/extract_url_domain_name/README.md	1
sql/mozfun/google_search_console/extract_url_language_code/README.md	1
sql/mozfun/google_search_console/extract_url_locale/README.md	1
sql/mozfun/google_search_console/extract_url_path/README.md	1
sql/mozfun/google_search_console/extract_url_path_segment/README.md	1
sql/mozfun/hist/README.md	2
sql/mozfun/hist/count/README.md	2
sql/mozfun/hist/examples/full_hist_extract.sql	4
sql/mozfun/hist/examples/use_counter_hist_extract.sql	2
sql/mozfun/hist/extract/README.md	13
sql/mozfun/hist/extract_histogram_sum/README.md	1
sql/mozfun/hist/extract_keyed_hist_sum/README.md	8
sql/mozfun/hist/mean/README.md	1
sql/mozfun/hist/merge/README.md	1
sql/mozfun/hist/normalize/README.md	1
sql/mozfun/hist/percentiles/README.md	1
sql/mozfun/hist/string_to_json/README.md	1
sql/mozfun/hist/threshold_count/README.md	1
sql/mozfun/iap/README.md	1
sql/mozfun/iap/derive_apple_subscription_interval/README.md	1
sql/mozfun/iap/parse_android_receipt/README.md	1
sql/mozfun/iap/parse_apple_event/README.md	1
sql/mozfun/iap/parse_apple_receipt/README.md	1
sql/mozfun/iap/scrub_apple_receipt/README.md	1
sql/mozfun/json/README.md	2
sql/mozfun/json/extract_int_map/README.md	1
sql/mozfun/json/from_map/README.md	1
sql/mozfun/json/from_map_json/README.md	1
sql/mozfun/json/from_nested_map/README.md	2
sql/mozfun/json/js_extract_string_map/README.md	1
sql/mozfun/json/mode_last/README.md	1
sql/mozfun/map/README.md	2
sql/mozfun/map/extract_keyed_scalar_sum/README.md	6
sql/mozfun/map/get_key/README.md	1
sql/mozfun/map/get_key_with_null/README.md	1
sql/mozfun/map/mode_last/README.md	1
sql/mozfun/map/set_key/README.md	6
sql/mozfun/map/sum/README.md	1
sql/mozfun/marketing/parse_ad_group_name/README.md	9
sql/mozfun/marketing/parse_campaign_name/README.md	8
sql/mozfun/marketing/parse_creative_name/README.md	9
sql/mozfun/mobile_search/normalize_app_name/README.md	3
sql/mozfun/newtab/scheduled_surface_id_v1/README.md	8
sql/mozfun/norm/README.md	2
sql/mozfun/norm/app_channel/README.md	3
sql/mozfun/norm/browser_version_info/README.md	1
sql/mozfun/norm/diff_months/README.md	1
sql/mozfun/norm/examples/fenix_app_info.sql	32
sql/mozfun/norm/extract_version/README.md	15
sql/mozfun/norm/fenix_app_info/README.md	1
sql/mozfun/norm/fenix_build_to_datetime/README.md	1
sql/mozfun/norm/get_earliest_value/README.md	5
sql/mozfun/norm/get_windows_info/README.md	44
sql/mozfun/norm/glean_baseline_client_info/README.md	1
sql/mozfun/norm/glean_client_info_attribution/README.md	2
sql/mozfun/norm/glean_ping_info/README.md	1
sql/mozfun/norm/metadata/README.md	1
sql/mozfun/norm/os/README.md	1
sql/mozfun/norm/partnership/README.md	1
sql/mozfun/norm/product_info/README.md	19
sql/mozfun/norm/result_type_to_product_name/README.md	1
sql/mozfun/norm/truncate_version/README.md	1
sql/mozfun/norm/vpn_attribution/README.md	1
sql/mozfun/norm/windows_version_info/README.md	1
sql/mozfun/serp_events/README.md	2
sql/mozfun/serp_events/ad_blocker_inferred/README.md	1
sql/mozfun/serp_events/is_ad_component/README.md	1
sql/mozfun/stats/README.md	2
sql/mozfun/stats/mode_last/README.md	1
sql/mozfun/stats/mode_last_retain_nulls/README.md	1
sql/mozfun/utils/diff_query_schemas/README.md	12
sql/mozfun/utils/extract_utm_from_url/README.md	2
sql/mozfun/utils/get_url_path/README.md	3
sql/mozfun/vpn/README.md	2
sql/mozfun/vpn/acquisition_channel/README.md	1
sql/mozfun/vpn/channel_group/README.md	1
sql/mozfun/vpn/normalize_utm_parameters/README.md	1
sql/mozfun/vpn/pricing_plan/README.md	1
sql_generators/README.md	6
sql_generators/desktop_crashes/README.md	5
sql_generators/funnels/README.md	162
sql_generators/glean_usage/README.md	35
sql_generators/usage_reporting/README.md	38
tests/README.md	1
tests/data/all_datasets.json	26
tests/data/incremental_query_gcs_metadata.json	5
tests/data/non_incremental_query_gcs_metadata.json	3
tests/data/test_docs/generated_docs/README.md	1
tests/data/test_docs/generated_docs/test_dataset1/README.md	2
tests/data/test_docs/generated_docs/test_dataset1/examples/example1.sql	4
tests/data/test_docs/generated_docs/test_dataset1/examples/example2.sql	4
tests/data/test_docs/generated_docs/test_dataset1/udf1/README.md	1
tests/data/test_docs/generated_docs/test_dataset1/udf2/README.md	1
tests/sql/glam-fenix-dev/glam_etl/README.md	93
tests/sql/glam-fenix-dev/glam_etl/dependencies.json	266
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/moz-fx-data-shared-prod.org_mozilla_fenix.events.schema.json	468
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/moz-fx-data-shared-prod.org_mozilla_firefox.events.schema.json	468
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/moz-fx-data-shared-prod.org_mozilla_firefox_beta.events.schema.json	468
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/moz-fx-data-shared-prod.fenix.baseline_clients_daily.schema.json	63
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/moz-fx-data-shared-prod.fenix.first_session.schema.json	104
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/moz-fx-data-shared-prod.fenix.metrics.schema.json	60
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/moz-fx-data-shared-prod.fenix.new_profile_activation.schema.json	14
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.schema.json	224
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/moz-fx-data-marketing-prod.65789850.ga_sessions_20230331.schema.json	225
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/moz-fx-data-marketing-prod.65789850.ga_sessions_intraday_20230331.schema.json	225
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/moz-fx-data-shared-prod.org_mozilla_fenix_derived.baseline_clients_first_seen_v1.schema.json	70
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.schema.json	862
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/moz-fx-data-shared-prod.org_mozilla_fenix_derived.baseline_clients_first_seen_v1.schema.json	70
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.schema.json	862
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/moz-fx-data-shared-prod.org_mozilla_fenix_stable.migration_v1.schema.json	1332
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.schema.json	10
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/moz-fx-data-shared-prod.org_mozilla_fenix.metrics.schema.json	43
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/moz-fx-data-shared-prod.org_mozilla_fenix_nightly.metrics.schema.json	43
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/moz-fx-data-shared-prod.org_mozilla_fennec_aurora.metrics.schema.json	43
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_ios_firefox_derived.baseline_clients_first_seen_v1.schema.json	70
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.baseline_v1.schema.json	831
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_init/moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.baseline_v1.schema.json	831
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v1.schema.json	162
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v2.schema.json	162
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v1.schema.json	152
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/moz-fx-data-shared-prod.search_derived.mobile_search_clients_last_seen_v1.schema.json	163
tests/sql/moz-fx-data-shared-prod/search_derived/search_aggregates_v8/moz-fx-data-shared-prod.search.acer_cohor.schema.json	7
tests/sql/moz-fx-data-shared-prod/search_derived/search_aggregates_v8/moz-fx-data-shared-prod.search_derived.search_clients_daily_v8.schema.json	217
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/moz-fx-data-shared-prod.telemetry.clients_daily.schema.json	1231
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	60
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_last_seen_v1/moz-fx-data-shared-prod.search_derived.search_clients_daily_v8.schema.json	40
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/moz-fx-stubattribut-prod-32a5.stubattribution_prod.stdout.schema.json	51
tests/sql/moz-fx-data-shared-prod/telemetry_derived/addon_aggregates_v2/moz-fx-data-shared-prod.telemetry.main.schema.json	127
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/moz-fx-data-shared-prod.telemetry.buildhub2.schema.json	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_boolean_aggregates_v1/moz-fx-data-shared-prod.telemetry.buildhub2.schema.json	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_boolean_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	218
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_histogram_aggregates_v1/moz-fx-data-shared-prod.telemetry.buildhub2.schema.json	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_histogram_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	5257
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/moz-fx-data-shared-prod.telemetry.buildhub2.schema.json	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	1164
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/moz-fx-data-shared-prod.telemetry.buildhub2.schema.json	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	1640
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6/README.md	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/moz-fx-data-shared-prod.telemetry.first_shutdown.schema.json	276
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/moz-fx-data-shared-prod.telemetry.new_profile.schema.json	276
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.schema.json	172
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2.schema.json	184
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_histogram_probe_counts_v1/moz-fx-data-shared-prod.telemetry_derived.clients_histogram_bucket_counts_v1.schema.json	96
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.schema.json	80
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1/moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v1.schema.json	17
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1/moz-fx-data-shared-prod.telemetry_derived.clients_last_seen_v1.schema.json	163
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_scalar_probe_counts_v1/moz-fx-data-shared-prod.telemetry_derived.clients_scalar_aggregates_v1.schema.json	69
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_daily_v1/moz-fx-data-shared-prod.telemetry.core.schema.json	427
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_daily_v1/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.schema.json	10
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/moz-fx-data-shared-prod.telemetry.core.schema.json	427
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.schema.json	10
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_last_seen_v1/moz-fx-data-shared-prod.telemetry_derived.core_clients_daily_v1.schema.json	42
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_last_seen_v1/moz-fx-data-shared-prod.telemetry_derived.core_clients_last_seen_v1.schema.json	47
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry.core.schema.json	66
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry_derived.core_live.schema.json	66
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry_live.crash_v4.schema.json	116
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry_live.main_v5.schema.json	130
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.crash_v4.schema.json	116
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	130
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/moz-fx-data-shared-prod.firefox_desktop_stable.newtab_v1.schema.json	583
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/moz-fx-data-shared-prod.telemetry.desktop_active_users.schema.json	157
tests/sql/moz-fx-data-shared-prod/telemetry_derived/ssl_ratios_v1/moz-fx-data-shared-prod.telemetry_stable.main_v5.schema.json	105
tests/sql/moz-fx-data-shared-prod/telemetry_derived/urlbar_clients_daily_v1/moz-fx-data-shared-prod.telemetry_derived.clients_daily_joined_v1.schema.json	381
tests/validation/data/hmac_sha256_validation.json	1585