Path	Lines of Code
bigquery_etl/pytest_plugin/sql_test.py	230
script/glam/test/test_glean_firefox_desktop_glam_nightly.sh	40
sql/moz-fx-data-shared-prod/burnham_derived/test_results_v1/metadata.yaml	14
sql/moz-fx-data-shared-prod/burnham_derived/test_results_v1/schema.yaml	29
sql_generators/events_daily/tests/test_generate_queries.py	10
sql_generators/events_daily/tests/test_templated_dir.py	27
sql_generators/funnels/tests/test_funnels.py	24
tests/__init__.py	1
tests/alchemer/test_survey.py	431
tests/backfill/backfill.yaml	9
tests/backfill/test_date_range.py	71
tests/backfill/test_dir_depends_on_past/backfill.yaml	9
tests/backfill/test_dir_depends_on_past/metadata.yaml	9
tests/backfill/test_dir_multiple/backfill.yaml	18
tests/backfill/test_dir_valid/backfill.yaml	9
tests/backfill/test_dir_valid/metadata.yaml	7
tests/backfill/test_dir_valid_1/backfill.yaml	9
tests/backfill/test_dir_valid_1/metadata.yaml	8
tests/backfill/test_parse_backfill.py	418
tests/backfill/test_shredder_mitigation.py	1596
tests/backfill/test_validate_backfill.py	361
tests/checks/accepted_values.jinja	18
tests/checks/in_range.jinja	40
tests/checks/is_unique.jinja	24
tests/checks/matches_pattern.jinja	17
tests/checks/min_row_count.jinja	15
tests/checks/not_null.jinja	23
tests/checks/revenue_period_over_period_change.jinja	79
tests/checks/row_count_within_past_partitions_avg.jinja	46
tests/checks/value_length.jinja	12
tests/cli/test_cli_alchemer.py	31
tests/cli/test_cli_backfill.py	1793
tests/cli/test_cli_check.py	47
tests/cli/test_cli_dag.py	203
tests/cli/test_cli_dependency.py	28
tests/cli/test_cli_format.py	29
tests/cli/test_cli_metadata.py	775
tests/cli/test_cli_monitoring.py	468
tests/cli/test_cli_query.py	865
tests/cli/test_cli_routine.py	225
tests/cli/test_cli_static.py	57
tests/cli/test_cli_utils.py	56
tests/dags_config/test_dag_names.py	8
tests/data/bqetl_project.yaml	7
tests/data/dags.yaml	19
tests/data/metadata.yaml	19
tests/data/test_docs/generated_docs/test_dataset1/udf1/udf.sql	3
tests/data/test_docs/generated_docs/test_dataset1/udf2/udf.sql	3
tests/data/test_sql/moz-fx-data-test-project-2/test_2/test_query_v1/metadata.yaml	16
tests/data/test_sql/moz-fx-data-test-project-2/test_2/test_query_v1/query.sql	14
tests/data/test_sql/moz-fx-data-test-project/procedure/append_hello/stored_procedure.sql	13
tests/data/test_sql/moz-fx-data-test-project/procedure/test_procedure/stored_procedure.sql	5
tests/data/test_sql/moz-fx-data-test-project/test/dataset_metadata.yaml	14
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_non_incremental_export_v1/metadata.yaml	16
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_non_incremental_export_v1/query.sql	14
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_non_incremental_export_v1/schema.yaml	10
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_v1/metadata.yaml	26
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_v1/query.sql	14
tests/data/test_sql/moz-fx-data-test-project/test/incremental_query_v1/schema.yaml	10
tests/data/test_sql/moz-fx-data-test-project/test/multipart_query_v1/metadata.yaml	14
tests/data/test_sql/moz-fx-data-test-project/test/multipart_query_v1/part1.sql	2
tests/data/test_sql/moz-fx-data-test-project/test/multipart_query_v1/part2.sql	2
tests/data/test_sql/moz-fx-data-test-project/test/no_metadata_query_v1/query.sql	2
tests/data/test_sql/moz-fx-data-test-project/test/non_incremental_query_v1/metadata.yaml	22
tests/data/test_sql/moz-fx-data-test-project/test/non_incremental_query_v1/query.sql	14
tests/data/test_sql/moz-fx-data-test-project/test/python_script_query_v1/metadata.yaml	14
tests/data/test_sql/moz-fx-data-test-project/test/python_script_query_v1/query.py	4
tests/data/test_sql/moz-fx-data-test-project/test/simple_view/view.sql	5
tests/data/test_sql/moz-fx-data-test-project/test/view_with_metadata/metadata.yaml	23
tests/data/test_sql/moz-fx-data-test-project/test/view_with_metadata/view.sql	7
tests/data/test_sql/moz-fx-data-test-project/udf/test_bitmask_lowest_28/metadata.yaml	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_bitmask_lowest_28/udf.sql	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_js_udf/metadata.yaml	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_js_udf/udf.sql	7
tests/data/test_sql/moz-fx-data-test-project/udf/test_safe_crc32_uuid/metadata.yaml	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_safe_crc32_uuid/udf.sql	77
tests/data/test_sql/moz-fx-data-test-project/udf/test_safe_sample_id/metadata.yaml	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_safe_sample_id/udf.sql	15
tests/data/test_sql/moz-fx-data-test-project/udf/test_shift_28_bits_one_day/metadata.yaml	3
tests/data/test_sql/moz-fx-data-test-project/udf/test_shift_28_bits_one_day/udf.sql	8
tests/format_sql/capitalize_builtin_functions/expect.sql	330
tests/format_sql/capitalize_builtin_functions/input.sql	330
tests/format_sql/capitalize_keywords/expect.sql	205
tests/format_sql/capitalize_keywords/input.sql	205
tests/format_sql/case_statements/expect.sql	43
tests/format_sql/conftest.py	31
tests/format_sql/jinja_example/expect.sql	12
tests/format_sql/scripting_example/expect.sql	53
tests/metadata/test_parse_metadata.py	188
tests/metadata/test_publish_metadata.py	65
tests/metadata/test_validate_metadata.py	65
tests/public_data/test_publish_gcs_metadata.py	255
tests/public_data/test_publish_json.py	155
tests/public_data/test_publish_public_data_json_script.py	220
tests/query_scheduling/test_dag.py	189
tests/query_scheduling/test_dag_collection.py	774
tests/query_scheduling/test_formatters.py	48
tests/query_scheduling/test_generate_airflow_dags.py	18
tests/query_scheduling/test_task.py	701
tests/query_scheduling/test_utils.py	9
tests/routine/test_parse_routine.py	259
tests/routine/test_publish_routine.py	60
tests/schema/test_schema.py	368
tests/shredder/test_config.py	414
tests/shredder/test_delete.py	118
tests/sql/glam-fenix-dev/glam_etl/bootstrap.py	179
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1.schema.yaml	47
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1.schema.yaml	6
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1.schema.yaml	50
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/data.py	96
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/expect.yaml	19
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1.yaml	19
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1.yaml	2
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1.yaml	18
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_incremental_aggregate/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/data.py	86
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/expect.yaml	17
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1.yaml	8
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1.yaml	2
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1.yaml	18
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1.schema.yaml	37
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1.schema.yaml	6
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1.schema.yaml	40
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/data.py	112
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/expect.yaml	27
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1.yaml	7
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1.yaml	2
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1.yaml	23
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1.schema.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/test_minimal/data.py	38
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/test_minimal/expect.yaml	7
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1.yaml	6
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1.schema.yaml	47
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/test_minimal/data.py	63
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/test_minimal/expect.yaml	208
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1.schema.yaml	46
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/test_minimal/data.py	66
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/test_minimal/expect.yaml	20
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1.yaml	26
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1.schema.yaml	40
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/test_minimal/data.py	32
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/test_minimal/expect.yaml	2
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1.yaml	48
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1.schema.yaml	37
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/test_minimal/data.py	64
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/test_minimal/expect.yaml	112
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/test_minimal/query_params.yaml	12
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1.schema.yaml	45
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/test_minimal/data.py	55
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/test_minimal/expect.yaml	18
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/test_minimal/glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1.yaml	15
tests/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/test_minimal/query_params.yaml	12
tests/sql/moz-fx-data-shared-prod/account_ecosystem_derived/ecosystem_user_id_lookup_v1/test_script/moz-fx-data-shared-prod.telemetry_stable.account_ecosystem_v4.yaml	5
tests/sql/moz-fx-data-shared-prod/braze_derived/newsletters_v1/test_braze_newsletters/expect.yaml	55
tests/sql/moz-fx-data-shared-prod/braze_derived/newsletters_v1/test_braze_newsletters/moz-fx-data-shared-prod.braze_derived.users_v1.yaml	5
tests/sql/moz-fx-data-shared-prod/braze_derived/newsletters_v1/test_braze_newsletters/moz-fx-data-shared-prod.ctms_braze.ctms_newsletters.yaml	91
tests/sql/moz-fx-data-shared-prod/braze_derived/products_v1/test_braze_products/expect.yaml	145
tests/sql/moz-fx-data-shared-prod/braze_derived/products_v1/test_braze_products/moz-fx-data-shared-prod.braze_derived.users_v1.yaml	4
tests/sql/moz-fx-data-shared-prod/braze_derived/products_v1/test_braze_products/moz-fx-data-shared-prod.ctms_braze.ctms_fxa.yaml	7
tests/sql/moz-fx-data-shared-prod/braze_derived/products_v1/test_braze_products/moz-fx-data-shared-prod.subscription_platform.logical_subscriptions.yaml	152
tests/sql/moz-fx-data-shared-prod/braze_derived/subscriptions_v1/test_braze_subscriptions/expect.yaml	61
tests/sql/moz-fx-data-shared-prod/braze_derived/subscriptions_v1/test_braze_subscriptions/moz-fx-data-shared-prod.braze_derived.subscriptions_map_v1.yaml	33
tests/sql/moz-fx-data-shared-prod/braze_derived/subscriptions_v1/test_braze_subscriptions/moz-fx-data-shared-prod.braze_derived.user_profiles_v1.yaml	43
tests/sql/moz-fx-data-shared-prod/braze_derived/user_profiles_v1/test_braze_user_profiles/expect.yaml	63
tests/sql/moz-fx-data-shared-prod/braze_derived/user_profiles_v1/test_braze_user_profiles/moz-fx-data-shared-prod.braze_derived.newsletters_v1.yaml	15
tests/sql/moz-fx-data-shared-prod/braze_derived/user_profiles_v1/test_braze_user_profiles/moz-fx-data-shared-prod.braze_derived.products_v1.yaml	16
tests/sql/moz-fx-data-shared-prod/braze_derived/user_profiles_v1/test_braze_user_profiles/moz-fx-data-shared-prod.braze_derived.users_v1.yaml	30
tests/sql/moz-fx-data-shared-prod/braze_derived/user_profiles_v1/test_braze_user_profiles/moz-fx-data-shared-prod.braze_derived.waitlists_v1.yaml	9
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/expect.yaml	128
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.braze_derived.subscriptions_map_v1.yaml	7
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.ctms_braze.ctms_emails.yaml	217
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.ctms_braze.ctms_fxa.yaml	29
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.ctms_braze.ctms_newsletters.yaml	58
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.ctms_braze.ctms_waitlists.yaml	37
tests/sql/moz-fx-data-shared-prod/braze_derived/users_v1/test_braze_users/moz-fx-data-shared-prod.marketing_suppression_list_derived.main_suppression_list_v1.yaml	2
tests/sql/moz-fx-data-shared-prod/braze_derived/waitlists_v1/test_braze_waitlists/expect.yaml	27
tests/sql/moz-fx-data-shared-prod/braze_derived/waitlists_v1/test_braze_waitlists/moz-fx-data-shared-prod.braze_derived.users_v1.yaml	4
tests/sql/moz-fx-data-shared-prod/braze_derived/waitlists_v1/test_braze_waitlists/moz-fx-data-shared-prod.ctms_braze.ctms_waitlists.yaml	56
tests/sql/moz-fx-data-shared-prod/braze_external/changed_users_v1/test_braze_changed_users/expect.yaml	39
tests/sql/moz-fx-data-shared-prod/braze_external/changed_users_v1/test_braze_changed_users/moz-fx-data-shared-prod.braze_derived.users_v1.yaml	37
tests/sql/moz-fx-data-shared-prod/braze_external/changed_users_v1/test_braze_changed_users/moz-fx-data-shared-prod.braze_external.users_previous_day_snapshot_v1.yaml	42
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/expect.yaml	82
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-ads-prod.adm.blocks.yaml	8
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.contextual_services.quicksuggest_click.yaml	17
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.contextual_services.quicksuggest_impression.yaml	17
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.contextual_services.topsites_click.yaml	14
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.contextual_services.topsites_impression.yaml	20
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.fenix.fx_suggest.yaml	26
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.firefox_desktop.quick_suggest.yaml	30
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.firefox_desktop.top_sites.yaml	40
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.firefox_ios.fx_suggest.yaml	17
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_firefox.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_firefox_beta.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_ios_firefox.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/expect.yaml	81
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-ads-prod.adm.blocks.yaml	8
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.contextual_services.quicksuggest_click.yaml	70
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.contextual_services.quicksuggest_impression.yaml	70
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.contextual_services.topsites_click.yaml	67
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.contextual_services.topsites_impression.yaml	67
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.fenix.fx_suggest.yaml	75
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.firefox_desktop.quick_suggest.yaml	141
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.firefox_desktop.top_sites.yaml	138
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.firefox_ios.fx_suggest.yaml	73
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.org_mozilla_fenix.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.org_mozilla_firefox.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.org_mozilla_firefox_beta.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.org_mozilla_ios_firefox.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta.topsites_impression.yaml	19
tests/sql/moz-fx-data-shared-prod/contextual_services_derived/event_aggregates_v1/test_overactive_filter/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_init/expect.yaml	78
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_init/moz-fx-data-shared-prod.org_mozilla_fenix.events.yaml	27
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_init/moz-fx-data-shared-prod.org_mozilla_firefox.events.yaml	57
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_init/moz-fx-data-shared-prod.org_mozilla_firefox_beta.events.yaml	27
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/expect.yaml	119
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/moz-fx-data-shared-prod.fenix_derived.event_types_history_v1.yaml	78
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/moz-fx-data-shared-prod.org_mozilla_fenix.events.yaml	16
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/moz-fx-data-shared-prod.org_mozilla_firefox.events.yaml	40
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/moz-fx-data-shared-prod.org_mozilla_firefox_beta.events.yaml	16
tests/sql/moz-fx-data-shared-prod/fenix_derived/event_types_history_v1/test_new_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/expect.yaml	30
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/moz-fx-data-shared-prod.fenix.event_types.yaml	81
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/moz-fx-data-shared-prod.org_mozilla_fenix.events.yaml	50
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/moz-fx-data-shared-prod.org_mozilla_firefox.events.yaml	50
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/moz-fx-data-shared-prod.org_mozilla_firefox_beta.events.yaml	50
tests/sql/moz-fx-data-shared-prod/fenix_derived/events_daily_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/expect.yaml	67
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/moz-fx-data-shared-prod.fenix.baseline_clients_daily.yaml	23
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/moz-fx-data-shared-prod.fenix.first_session.yaml	23
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/moz-fx-data-shared-prod.fenix.metrics.yaml	11
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/moz-fx-data-shared-prod.fenix.new_profile_activation.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.yaml	13
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_channels/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/expect.yaml	49
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/moz-fx-data-shared-prod.fenix.baseline_clients_daily.yaml	9
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/moz-fx-data-shared-prod.fenix.first_session.yaml	11
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/moz-fx-data-shared-prod.fenix.metrics.yaml	13
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/moz-fx-data-shared-prod.fenix.new_profile_activation.yaml	7
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.yaml	15
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_baseline_no_first_session_with_activations/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/expect.yaml	52
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/moz-fx-data-shared-prod.fenix.baseline_clients_daily.yaml	15
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/moz-fx-data-shared-prod.fenix.first_session.yaml	23
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/moz-fx-data-shared-prod.fenix.metrics.yaml	7
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/moz-fx-data-shared-prod.fenix.new_profile_activation.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.yaml	13
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_no_baseline/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/expect.yaml	58
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/moz-fx-data-shared-prod.fenix.baseline_clients_daily.yaml	15
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/moz-fx-data-shared-prod.fenix.first_session.yaml	63
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/moz-fx-data-shared-prod.fenix.metrics.yaml	7
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/moz-fx-data-shared-prod.fenix.new_profile_activation.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.yaml	14
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_first_session_seq/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/expect.yaml	49
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/moz-fx-data-shared-prod.fenix.baseline_clients_daily.yaml	9
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/moz-fx-data-shared-prod.fenix.first_session.yaml	11
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/moz-fx-data-shared-prod.fenix.metrics.yaml	14
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/moz-fx-data-shared-prod.fenix.new_profile_activation.yaml	4
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1.yaml	12
tests/sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/test_only_metrics_ping/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_matching_destinations/expect.yaml	28
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_matching_destinations/moz-fx-data-shared-prod.fivetran_costs_derived.destinations_v1.yaml	3
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_matching_destinations/moz-fx-data-shared-prod.fivetran_costs_derived.incremental_mar_v1.yaml	35
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_matching_destinations/moz-fx-data-shared-prod.fivetran_costs_derived.monthly_costs_v1.yaml	4
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_mothly_costs/expect.yaml	24
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_mothly_costs/moz-fx-data-shared-prod.fivetran_costs_derived.destinations_v1.yaml	3
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_mothly_costs/moz-fx-data-shared-prod.fivetran_costs_derived.incremental_mar_v1.yaml	35
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_no_mothly_costs/moz-fx-data-shared-prod.fivetran_costs_derived.monthly_costs_v1.yaml	4
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_one_destination_one_month/expect.yaml	29
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_one_destination_one_month/moz-fx-data-shared-prod.fivetran_costs_derived.destinations_v1.yaml	3
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_one_destination_one_month/moz-fx-data-shared-prod.fivetran_costs_derived.incremental_mar_v1.yaml	35
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/daily_connector_costs_v1/test_one_destination_one_month/moz-fx-data-shared-prod.fivetran_costs_derived.monthly_costs_v1.yaml	4
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/destinations_v1/test_renaming/expect.yaml	16
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/destinations_v1/test_renaming/moz-fx-data-bq-fivetran.fivetran_log.destination.yaml	16
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/incremental_mar_v1/test_date_trunc_and_string_manipulation/expect.yaml	57
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/incremental_mar_v1/test_date_trunc_and_string_manipulation/moz-fx-data-bq-fivetran.fivetran_log.incremental_mar.yaml	49
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/monthly_costs_v1/test_join/expect.yaml	28
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/monthly_costs_v1/test_join/moz-fx-data-bq-fivetran.fivetran_log.credits_used.yaml	16
tests/sql/moz-fx-data-shared-prod/fivetran_costs_derived/monthly_costs_v1/test_join/moz-fx-data-bq-fivetran.fivetran_log.usage_cost.yaml	16
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/expect.yaml	29
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/moz-fx-data-shared-prod.acoustic_external.suppression_list_v1.yaml	10
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/moz-fx-data-shared-prod.braze_external.braze_currents_firefox_hard_bounces_v1.yaml	7
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/moz-fx-data-shared-prod.braze_external.braze_currents_firefox_unsubscribe_v1.yaml	9
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/moz-fx-data-shared-prod.braze_external.braze_currents_mozilla_hard_bounces_v1.yaml	3
tests/sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/test_main_suppression_list/moz-fx-data-shared-prod.marketing_suppression_list_external.campaign_monitor_suppression_list_v1.yaml	6
tests/sql/moz-fx-data-shared-prod/monitoring_derived/event_counts_glean_v1/test_aggregation/expect.yaml	32
tests/sql/moz-fx-data-shared-prod/monitoring_derived/event_counts_glean_v1/test_aggregation/moz-fx-data-shared-prod.monitoring_derived.event_monitoring_aggregates_v1.yaml	38
tests/sql/moz-fx-data-shared-prod/monitoring_derived/event_counts_glean_v1/test_aggregation/query_params.yaml	3
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/moz-fx-data-shared-prod.mozilla_org_derived.ga_clients_v1.schema.yaml	95
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/moz-fx-data-shared-prod.mozilla_org_derived.ga_sessions_v1.schema.yaml	126
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/test_single_day/expect.yaml	18
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/test_single_day/moz-fx-data-shared-prod.mozilla_org_derived.ga_clients_v1.yaml	11
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/test_single_day/moz-fx-data-shared-prod.mozilla_org_derived.ga_sessions_v1.yaml	20
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_clients_v1/test_single_day/query_params.yaml	3
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/test_single_day/expect.yaml	62
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/test_single_day/moz-fx-data-marketing-prod.65789850.ga_sessions_20230331.yaml	102
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/test_single_day/moz-fx-data-marketing-prod.65789850.ga_sessions_intraday_20230331.yaml	61
tests/sql/moz-fx-data-shared-prod/mozilla_org_derived/ga_sessions_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_aggregation/expect.yaml	21
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_derived.baseline_clients_first_seen_v1.yaml	12
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.yaml	26
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_init/expect.yaml	31
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_init/moz-fx-data-shared-prod.org_mozilla_fenix_derived.baseline_clients_first_seen_v1.yaml	12
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_init/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.yaml	30
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_daily_v1/test_init/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/expect.yaml	36
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_derived.baseline_clients_first_seen_v1.yaml	25
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.yaml	13
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_stable.migration_v1.yaml	8
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.yaml	3
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_init/expect.yaml	34
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_init/moz-fx-data-shared-prod.org_mozilla_fenix_stable.baseline_v1.yaml	49
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_init/moz-fx-data-shared-prod.org_mozilla_fenix_stable.migration_v1.yaml	8
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/baseline_clients_first_seen_v1/test_init/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.yaml	5
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/bootstrap.py	59
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/test_aggregation/expect.yaml	1012
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix.metrics.yaml	13
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fenix_nightly.metrics.yaml	313
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/test_aggregation/moz-fx-data-shared-prod.org_mozilla_fennec_aurora.metrics.yaml	13
tests/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/geckoview_version_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_aggregation/expect.yaml	37
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.yaml	25
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.yaml	25
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/org_mozilla_ios_firefox_derived/baseline_clients_first_seen_v1/test_init/expect.yaml	23
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.yaml	37
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/test_aggregation/expect.yaml	120
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v1.yaml	213
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v2.yaml	213
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_aggregates_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/test_day_bit_shifting/expect.yaml	67
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/test_day_bit_shifting/moz-fx-data-shared-prod.search_derived.mobile_search_clients_daily_v1.yaml	48
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/test_day_bit_shifting/moz-fx-data-shared-prod.search_derived.mobile_search_clients_last_seen_v1.yaml	61
tests/sql/moz-fx-data-shared-prod/search_derived/mobile_search_clients_last_seen_v1/test_day_bit_shifting/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_derived/search_aggregates_v8/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/expect.yaml	326
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/moz-fx-data-shared-prod.revenue.monetization_blocking_addons.yaml	8
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/moz-fx-data-shared-prod.telemetry.clients_daily.yaml	164
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.yaml	9
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	30
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_access_point_probes/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/expect.yaml	123
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/moz-fx-data-shared-prod.revenue.monetization_blocking_addons.yaml	8
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/moz-fx-data-shared-prod.telemetry.clients_daily.yaml	70
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.yaml	9
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	30
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_derived/search_clients_last_seen_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v2_external/test_single_day/expect.yaml	57
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v2_external/test_single_day/moz-fx-data-shared-prod.contextual_services_stable.quicksuggest_impression_v1.yaml	60
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v2_external/test_single_day/moz-fx-data-shared-prod.search_terms_derived.remotesettings_suggestions_v1.yaml	10
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v2_external/test_single_day/query_params.yaml	3
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v2_external/test_single_day/suggest-searches-prod-a30f.logs.stdout.yaml	24
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v3/test_single_day/expect.yaml	118
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v3/test_single_day/moz-fx-data-shared-prod.contextual_services_stable.quicksuggest_impression_v1.yaml	60
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v3/test_single_day/moz-fx-data-shared-prod.firefox_desktop_stable.quick_suggest_v1.yaml	104
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v3/test_single_day/moz-fx-data-shared-prod.search_terms_derived.merino_log_sanitized_v3.yaml	66
tests/sql/moz-fx-data-shared-prod/search_terms_derived/suggest_impression_sanitized_v3/test_single_day/query_params.yaml	3
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/moz-fx-data-shared-prod.stub_attribution_service_derived.dl_token_ga_attribution_lookup_v1.schema.yaml	16
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/test_single_day/expect.yaml	20
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/test_single_day/moz-fx-data-shared-prod.stub_attribution_service_derived.dl_token_ga_attribution_lookup_v1.yaml	16
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/test_single_day/moz-fx-stubattribut-prod-32a5.stubattribution_prod.stdout.yaml	40
tests/sql/moz-fx-data-shared-prod/stub_attribution_service_derived/dl_token_ga_attribution_lookup_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry/test_longitudinal.py	62
tests/sql/moz-fx-data-shared-prod/telemetry_derived/addon_aggregates_v2/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	17
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_build_id_filter/expect.yaml	69
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_build_id_filter/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_build_id_filter/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	35
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_parent_v1/test_build_id_filter/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_boolean_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_boolean_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	28
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_boolean_aggregates_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_histogram_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_histogram_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	25
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_histogram_aggregates_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/metadata.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	28
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_keyed_scalar_aggregates_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/metadata.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	24
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_build_id_filter/expect.yaml	6518
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_build_id_filter/moz-fx-data-shared-prod.telemetry.buildhub2.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_build_id_filter/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	32
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1/test_build_id_filter/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6/checks.sql	13
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_v6/metadata.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/expect.yaml	51
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/moz-fx-data-shared-prod.telemetry.first_shutdown.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/moz-fx-data-shared-prod.telemetry.new_profile.yaml	24
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.yaml	20
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2.yaml	39
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_seen_dates/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/expect.yaml	34
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/moz-fx-data-shared-prod.telemetry.first_shutdown.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/moz-fx-data-shared-prod.telemetry.new_profile.yaml	9
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/moz-fx-data-shared-prod.telemetry_derived.clients_daily_v6.yaml	26
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2.yaml	13
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/test_source_pings/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_histogram_probe_counts_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_derived.clients_histogram_bucket_counts_v1.yaml	112
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_histogram_probe_counts_v1/test_aggregation/query_params.yaml	10
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1/test_empty_input.yaml	12
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_last_seen_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_scalar_probe_counts_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_derived.clients_scalar_aggregates_v1.yaml	5200
tests/sql/moz-fx-data-shared-prod/telemetry_derived/clients_scalar_probe_counts_v1/test_aggregation/query_params.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_daily_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_aggregation/expect.yaml	3
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.core.yaml	7
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_derived.core_clients_first_seen_v1.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_init/expect.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_first_seen_v1/test_init/moz-fx-data-shared-prod.telemetry.core.yaml	10
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_last_seen_v1/test_empty_input.yaml	12
tests/sql/moz-fx-data-shared-prod/telemetry_derived/core_clients_last_seen_v1/test_single_day/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/dataset_metadata.yaml	16
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/test_live_date_filter/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/error_aggregates_v1/test_stable_date_filter/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_aggregation/expect.yaml	90
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_aggregation/moz-fx-data-shared-prod.firefox_desktop_stable.newtab_v1.yaml	91
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_aggregation/moz-fx-data-shared-prod.telemetry.desktop_active_users.yaml	5
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_ignore_preloaded/expect.yaml	2
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_ignore_preloaded/moz-fx-data-shared-prod.firefox_desktop_stable.newtab_v1.yaml	10
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_ignore_preloaded/moz-fx-data-shared-prod.telemetry.desktop_active_users.yaml	2
tests/sql/moz-fx-data-shared-prod/telemetry_derived/newtab_visits_v1/test_ignore_preloaded/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/ssl_ratios_v1/test_aggregation/moz-fx-data-shared-prod.telemetry_stable.main_v5.yaml	64
tests/sql/moz-fx-data-shared-prod/telemetry_derived/ssl_ratios_v1/test_aggregation/query_params.yaml	4
tests/sql/moz-fx-data-shared-prod/telemetry_derived/urlbar_clients_daily_v1/test_overactive_filter/expect.yaml	133
tests/sql/moz-fx-data-shared-prod/telemetry_derived/urlbar_clients_daily_v1/test_overactive_filter/moz-fx-data-shared-prod.telemetry_derived.clients_daily_joined_v1.yaml	50
tests/sql/moz-fx-data-shared-prod/telemetry_derived/urlbar_clients_daily_v1/test_overactive_filter/query_params.yaml	4
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/composite_active_users/view.sql	64
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/composite_active_users_aggregates/view.sql	96
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/usage_reporting_active_users/view.sql	57
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/usage_reporting_active_users_aggregates/view.sql	13
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/usage_reporting_clients_daily/view.sql	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/usage_reporting_clients_first_seen/view.sql	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix/usage_reporting_clients_last_seen/view.sql	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix_derived/usage_reporting_active_users_aggregates_v1/metadata.yaml	25
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix_derived/usage_reporting_active_users_aggregates_v1/query.sql	35
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/fenix_derived/usage_reporting_active_users_aggregates_v1/schema.yaml	89
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/composite_active_users/view.sql	66
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/composite_active_users_aggregates/view.sql	100
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/usage_reporting_active_users/view.sql	77
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/usage_reporting_active_users_aggregates/view.sql	33
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/usage_reporting_clients_daily/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/usage_reporting_clients_first_seen/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop/usage_reporting_clients_last_seen/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_active_users_aggregates_v1/metadata.yaml	25
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_active_users_aggregates_v1/query.sql	37
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_active_users_aggregates_v1/schema.yaml	94
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_daily_v1/metadata.yaml	23
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_daily_v1/query.sql	67
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_daily_v1/schema.yaml	65
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_first_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_first_seen_v1/query.sql	52
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_first_seen_v1/schema.yaml	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_last_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_last_seen_v1/query.sql	48
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_desktop_derived/usage_reporting_clients_last_seen_v1/schema.yaml	31
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/composite_active_users/view.sql	64
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/composite_active_users_aggregates/view.sql	96
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/usage_reporting_active_users/view.sql	53
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/usage_reporting_active_users_aggregates/view.sql	13
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/usage_reporting_clients_daily/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/usage_reporting_clients_first_seen/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios/usage_reporting_clients_last_seen/view.sql	9
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios_derived/usage_reporting_active_users_aggregates_v1/metadata.yaml	25
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios_derived/usage_reporting_active_users_aggregates_v1/query.sql	35
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/firefox_ios_derived/usage_reporting_active_users_aggregates_v1/schema.yaml	89
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox/usage_reporting_clients_daily/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox/usage_reporting_clients_first_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox/usage_reporting_clients_last_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta/usage_reporting_clients_daily/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta/usage_reporting_clients_first_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta/usage_reporting_clients_last_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_daily_v1/metadata.yaml	23
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_daily_v1/query.sql	61
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_daily_v1/schema.yaml	65
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_first_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_first_seen_v1/query.sql	52
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_first_seen_v1/schema.yaml	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_last_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_last_seen_v1/query.sql	48
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/usage_reporting_clients_last_seen_v1/schema.yaml	31
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_daily_v1/metadata.yaml	23
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_daily_v1/query.sql	61
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_daily_v1/schema.yaml	65
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_first_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_first_seen_v1/query.sql	52
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_first_seen_v1/schema.yaml	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_last_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_last_seen_v1/query.sql	48
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_firefox_derived/usage_reporting_clients_last_seen_v1/schema.yaml	31
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta/usage_reporting_clients_daily/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta/usage_reporting_clients_first_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta/usage_reporting_clients_last_seen/view.sql	7
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_daily_v1/metadata.yaml	23
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_daily_v1/query.sql	58
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_daily_v1/schema.yaml	65
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_first_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_first_seen_v1/query.sql	52
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_first_seen_v1/schema.yaml	16
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_last_seen_v1/metadata.yaml	20
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_last_seen_v1/query.sql	48
tests/sql_generators/usage_reporting/expected/moz-fx-data-shared-prod/org_mozilla_ios_firefoxbeta_derived/usage_reporting_clients_last_seen_v1/schema.yaml	31
tests/sql_generators/usage_reporting/test_config.yaml	135
tests/sql_generators/usage_reporting/test_usage_reporting.py	216
tests/templates/event_types/query.sql	1
tests/templates/event_types/templating.yaml	4
tests/test_config.py	29
tests/test_dependency.py	14
tests/test_deploy.py	136
tests/test_dryrun.py	104
tests/test_entrypoint.py	114
tests/test_run_query.py	212
tests/util/test_common.py	232
tests/util/test_mozfun_docs_functions.py	182
tests/util/test_snake_casing.py	16
tests/validation/__init__.py	1
tests/validation/hmac_sha256.py	37
tests/view/test_view.py	178