bigquery-etl/sql/moz-fx-data-shared-prod
Marlene Hirose 26ae738d8f
change types ofr created_at and job_created_at from STRING to DATE (#6536)
2024-11-20 18:07:48 +00:00
..
accounts_backend DENG-2095 Add accounts_backend.users_services_last_seen_v1 (#5112) 2024-02-27 12:07:07 +01:00
accounts_backend_derived Bug 1915724 - Update accounts events SQL check (#6165) 2024-09-10 12:12:21 +02:00
accounts_backend_external Remove referenced_tables usages (#4834) 2024-01-22 12:41:05 -08:00
accounts_db DENG-2228 Add table to monitor total numbers of Mozilla Accounts (#4746) 2023-12-28 13:49:24 +01:00
accounts_db_derived Deng-2845: Remove default deprecated false (#5118) 2024-02-27 10:33:50 -08:00
accounts_db_external Change fxa_carts amount to int in schema (#5998) 2024-08-01 10:35:05 -04:00
accounts_db_nonprod_external Change fxa_carts amount to int in schema (#5998) 2024-08-01 10:35:05 -04:00
accounts_frontend Add view files for funnel data (#5547) 2024-05-10 15:19:34 -07:00
acoustic Deng 3287 move acoustic data from marketing to shared prod (#5316) 2024-04-03 16:26:44 +02:00
acoustic_derived Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
acoustic_external Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
activity_stream feat(activity_stream): create new activity stream live view (#4850) 2024-01-23 23:26:43 +00:00
activity_stream_bi chore: update anicholson ownership (#6220) 2024-09-19 13:25:40 +00:00
activity_stream_derived feat(activity_stream): create new activity stream live view (#4850) 2024-01-23 23:26:43 +00:00
addon_moderations_derived change types ofr created_at and job_created_at from STRING to DATE (#6536) 2024-11-20 18:07:48 +00:00
adjust Fix `verify-format-sql` CI check not reporting SQL formatting issues (#4827) 2024-01-22 11:48:08 -08:00
adjust_derived Dependabot/pip/black 24.1.1 fix (#5027) 2024-02-19 15:27:34 +01:00
ads Remove desktop_tiles_forecast_inputs table (#6245) 2024-09-23 18:58:29 +00:00
ads_backend Update ads_backend workgroup_access (#5859) 2024-06-27 19:18:11 +00:00
ads_backend_derived Update ads_backend workgroup_access (#5859) 2024-06-27 19:18:11 +00:00
ads_derived Remove desktop_tiles_forecast_inputs table (#6245) 2024-09-23 18:58:29 +00:00
amo_dev Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
amo_prod Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
analysis Set analysis dataset default retention to 180 days (#6346) 2024-10-14 21:46:40 +00:00
app_store fix: incorrect source in app_store_syndication views and limit the number of syndicated views created to reduce noise (#5882) 2024-07-03 11:56:24 +02:00
app_store_syndicate fix: incorrect source in app_store_syndication views and limit the number of syndicated views created to reduce noise (#5882) 2024-07-03 11:56:24 +02:00
apple_ads DS-3501 - Create New iOS App Campaign Reporting Table (#5515) 2024-05-07 14:44:59 -05:00
apple_ads_external Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
backfills_staging_derived Grant backfill SAs write access to backfills_staging_derived (#5274) 2024-03-25 22:10:17 +00:00
billing_syndicate Add cloud_pricing_export to billing_syndicate (#5277) 2024-03-25 19:47:52 +00:00
blpadi
braze_derived adding nothing personal subscription to map (#6270) 2024-09-27 19:31:53 +00:00
braze_external Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
bugzilla_metrics chore(bugzilla_metrics): switch to single dataset for syndication (#6386) 2024-10-24 17:45:56 +00:00
burnham_derived/test_results_v1 Remove init.sql files that can simply be replaced by schema.yaml (#5237) 2024-03-26 15:09:16 -07:00
cloudflare chore(metadata-completeness): Add missing column descriptions (#6395) 2024-10-24 21:05:12 +00:00
cloudflare_derived feat(Cloudflare): Switch to using GSM secrets instead of airflow vars (#6280) 2024-10-03 20:15:39 +00:00
contextual_services Add schema.yaml files for event_aggregates and event_aggregates_suggest views (#4946) 2024-02-01 13:36:11 -05:00
contextual_services_derived Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
ctms Add dataset_metadata.yaml files for syndicates (#4663) 2023-12-14 01:17:08 +00:00
ctms_braze Resolves DSRE-1560 to syndicate ctms mirror of braze (#5264) 2024-03-22 00:21:55 +00:00
dap_collector_derived FXCTO-13 Add dataset for DAP Collector data (#4703) 2023-12-14 12:18:03 +01:00
default_browser_agent/default_browser
domain_metadata_derived Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
fakespot Add flipkart and home_depot views (#5638) 2024-05-22 16:24:30 -05:00
fakespot_syndicate Fakespot syndicate dataset (#4704) 2023-12-14 17:35:41 +00:00
fenix Clean up views that are no longer needed (#5713) 2024-06-03 11:13:49 -05:00
fenix_derived chore(DO-1886): Add shredder mitigation to more tables (#6532) 2024-11-20 15:12:09 +00:00
fenix_external Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
firefox_accounts Bug 1889144 - Add unhashed user id to fxa_delete_events (#5864) 2024-06-28 16:35:34 +02:00
firefox_accounts_derived Bug 1889144 - Add unhashed user id to fxa_delete_events (#5864) 2024-06-28 16:35:34 +02:00
firefox_desktop chore(metadata-completeness): Add missing column descriptions (#6395) 2024-10-24 21:05:12 +00:00
firefox_desktop_derived chore(DO-1886): Add shredder mitigation to more tables (#6532) 2024-11-20 15:12:09 +00:00
firefox_ios Clean up views that are no longer needed (#5713) 2024-06-03 11:13:49 -05:00
firefox_ios_derived chore(DO-1886): Add shredder mitigation to more tables (#6532) 2024-11-20 15:12:09 +00:00
fivetran_costs
fivetran_costs_derived Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
focus_android_derived feat(): adding metadata.yaml files for old (v1 and v2, current v3) with deprecated label (#5132) 2024-03-04 14:41:48 +01:00
focus_ios_derived feat(): adding metadata.yaml files for old (v1 and v2, current v3) with deprecated label (#5132) 2024-03-04 14:41:48 +01:00
fxci feat(fxci): add new derived query to compute task cost (#6007) 2024-08-08 11:18:51 -07:00
fxci_derived fix: SUM after join error in fxci_derived.task_run_costs_v1 (#6374) 2024-10-21 15:25:59 +00:00
glam_derived Remove percentiles columns from client_probe_counts schema (#5984) 2024-07-29 13:02:01 -04:00
glam_etl Add metadata for GLAM views (#5094) 2024-02-23 11:58:25 -05:00
google_ads GROWTH-143 Create new desktop conversion event table (#5733) 2024-06-04 16:20:46 -05:00
google_ads_derived Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
google_search_console Move limited historical Google Search Console data into separate views (DENG-4329) (#6027) 2024-08-07 14:09:03 -07:00
google_search_console_derived Move limited historical Google Search Console data into separate views (DENG-4329) (#6027) 2024-08-07 14:09:03 -07:00
hubs Remove hubs service access to hubs datasets (#5741) 2024-06-11 16:37:12 +00:00
hubs_derived Remove hubs service access to hubs datasets (#5741) 2024-06-11 16:37:12 +00:00
internet_outages feat(): Add global_outages_v2 (which includes subdivision1 and 2) (#5952) 2024-07-26 11:53:08 +02:00
klar_ios_derived feat(): adding metadata.yaml files for old (v1 and v2, current v3) with deprecated label (#5132) 2024-03-04 14:41:48 +01:00
marketing_suppression_list_derived Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
marketing_suppression_list_external Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
mdn_rumba Add missing description for mdn_rumba syndication dataset (#4717) 2023-12-15 12:55:41 +01:00
mdn_yari_derived/mdn_popularities_v1 Dependabot/pip/black 24.1.1 fix (#5027) 2024-02-19 15:27:34 +01:00
messaging_system DENG-2978 Deprecate exact mau28 views (#5204) 2024-03-14 09:22:24 -05:00
messaging_system_derived Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
microsoft_derived delete extraneous print statements which were used for testing (#5843) 2024-06-25 16:20:41 -07:00
mlhackweek_search
mlhackweek_search_derived
monitor_backend chore(data-privacy-mapping): DSRE-1690 - Add dataset_metadata.yaml for monitor datasets (#5904) 2024-07-11 13:13:49 -04:00
monitor_backend_derived chore(data-privacy-mapping): DSRE-1690 - Add dataset_metadata.yaml for monitor datasets (#5904) 2024-07-11 13:13:49 -04:00
monitor_cirrus chore(data-privacy-mapping): DSRE-1690 - Add dataset_metadata.yaml for monitor datasets (#5904) 2024-07-11 13:13:49 -04:00
monitor_cirrus_derived chore(data-privacy-mapping): DSRE-1690 - Add dataset_metadata.yaml for monitor datasets (#5904) 2024-07-11 13:13:49 -04:00
monitor_frontend chore(data-privacy-mapping): DSRE-1690 - Add dataset_metadata.yaml for monitor datasets (#5904) 2024-07-11 13:13:49 -04:00
monitor_frontend_derived Revert "chore(data-privacy-mapping): DSRE-1690 - ignore tables contaiing RECO…" (#6090) 2024-08-23 12:08:23 -04:00
monitoring Add submission_date partition to ref table number in bigquery_usage (#6440) 2024-11-04 22:06:10 +00:00
monitoring_derived Don't set shredder target for datasets with no deletion requests (#6519) 2024-11-19 13:08:57 +00:00
moso_mastodon_backend Add moso datasets with DBT workgroup access (#4960) 2024-02-05 18:50:17 +00:00
moso_mastodon_backend_derived Add moso datasets with DBT workgroup access (#4960) 2024-02-05 18:50:17 +00:00
moso_mastodon_web Add moso datasets with DBT workgroup access (#4960) 2024-02-05 18:50:17 +00:00
moso_mastodon_web_derived Add moso datasets with DBT workgroup access (#4960) 2024-02-05 18:50:17 +00:00
mozilla_org Switch from v1 to v2 (#6481) 2024-11-13 15:09:18 +00:00
mozilla_org_derived Add depends on past = true (#6501) 2024-11-14 17:31:21 +00:00
mozilla_vpn Add vpnsession and daemonsession pings to vpn events unnested (#6338) 2024-10-11 17:24:14 +00:00
mozilla_vpn_derived Update VPN ETL `in_available_geos` logic for when VPN became available in various countries (DENG-5484) (#6441) 2024-11-04 23:44:34 +00:00
mozilla_vpn_external chore: switch to v2 workgroups for dataplatform access (#6368) 2024-11-04 18:12:47 +00:00
net_thunderbird_android_daily_derived/baseline_clients_last_seen_v1 Revert "Add Bigeye checks for Thunderbird datasets (#6471)" (#6490) 2024-11-13 21:25:45 +00:00
net_thunderbird_android_derived/baseline_clients_last_seen_v1 Remove row count check for net_thunderbird_android_derived.baseline_clients_last_seen_v1 (#6515) 2024-11-18 20:13:02 +00:00
operational_monitoring
operational_monitoring_derived
org_mozilla_broken_site_report Grant webcompat service access to broken site reports (#5322) 2024-04-05 13:23:15 -07:00
org_mozilla_fenix Replace `geckoview_version` view `schema.json` with `schema.yaml`. (#5493) 2024-05-03 14:52:05 -07:00
org_mozilla_fenix_derived Update bigconfig.yaml to use tag_deployments (#6449) 2024-11-06 17:29:51 +00:00
org_mozilla_firefox
org_mozilla_firefox_beta
org_mozilla_firefox_beta_derived/client_deduplication_v1 Remove generated content from main (#4867) 2024-01-24 09:52:04 -08:00
org_mozilla_firefox_derived Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_focus_beta_derived/additional_deletion_requests_v1 Remove generated content from main (#4867) 2024-01-24 09:52:04 -08:00
org_mozilla_focus_derived/additional_deletion_requests_v1 Remove generated content from main (#4867) 2024-01-24 09:52:04 -08:00
org_mozilla_focus_nightly_derived/additional_deletion_requests_v1 Remove generated content from main (#4867) 2024-01-24 09:52:04 -08:00
org_mozilla_ios_firefox [DENG-6279] Deprecate legacy tables in org_mozilla_firefox_derived (#6448) 2024-11-07 19:08:06 +00:00
org_mozilla_ios_firefox_derived [DENG-6279] Deprecate legacy tables in org_mozilla_firefox_derived (#6448) 2024-11-07 19:08:06 +00:00
org_mozilla_ios_focus_derived/baseline_clients_last_seen_v1 Update bigconfig.yaml to use tag_deployments (#6449) 2024-11-06 17:29:51 +00:00
org_mozilla_ios_tiktok_reporter Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_ios_tiktok_reporter_derived Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_ios_tiktok_reporter_tiktok_reportershare Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_ios_tiktok_reporter_tiktok_reportershare_derived Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_mozregression/mozregression_aggregates
org_mozilla_mozregression_derived/mozregression_aggregates_v1 Remove misc init.sql files (#5338) 2024-04-05 12:21:45 -07:00
org_mozilla_reference_browser_derived/baseline_clients_last_seen_v1 [Bug 1903788] Update checks for reference_browser_derived.baseline_clients_last_seen_v1 (#5842) 2024-06-26 08:55:37 -07:00
org_mozilla_social_nightly_derived/baseline_clients_last_seen_v1 Skip most of the Mozilla Social checks (#6438) 2024-11-04 18:15:09 +00:00
org_mozilla_tiktokreporter Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_tiktokreporter_derived Bug 1873431 - restrict access to tiktok reporter datasets (#5159) 2024-03-05 22:42:40 +00:00
org_mozilla_tv_firefox_derived/baseline_clients_last_seen_v1 Skip check for baseline_clients_last_seen for Fire TV (#4640) 2023-12-01 09:24:11 -08:00
org_mozilla_vrbrowser_derived/clients_last_seen_v1 DENG-2760: Add missing metadata.yaml files (#5038) 2024-02-23 12:56:35 -08:00
phabricator_metrics SVCSE-2120 create syndication file for phabricator_metrics (#5996) 2024-07-31 23:19:13 +00:00
pocket
pocket_derived Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
reference
reference_derived Deng-2845: Remove default deprecated false (#5118) 2024-02-27 10:33:50 -08:00
regrets_reporter
regrets_reporter_derived Remove misc init.sql files (#5338) 2024-04-05 12:21:45 -07:00
regrets_reporter_ucs
regrets_reporter_ucs_derived
relay
relay_derived Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
search Switch to baseline beginning Aug 01st 2024 (#6425) 2024-10-31 19:11:36 +00:00
search_derived chore(DO-1886): Add shredder mitigation to more tables (#6535) 2024-11-20 17:34:57 +00:00
search_terms Switch search terms datasets to minimal dataset base ACLs (#5175) 2024-03-07 17:17:45 +00:00
search_terms_derived Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
snowplow_external Add snowplow_external dataset (#5881) 2024-07-03 20:13:43 +00:00
static Fix Christmas date in tentpole dates csv (#6505) 2024-11-14 21:02:51 +00:00
stripe Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
stripe_derived
stripe_external Incorporate discounts into the logical subscription ETLs (DENG-974) (#6474) 2024-11-14 00:36:51 +00:00
stub_attribution_service Account for NULL handling in joins (#4590) 2023-11-21 08:55:03 -05:00
stub_attribution_service_derived DENG-2979 Update dl_token_ga_attribution_lookup_v1 to use new GA4 client ID after switch to GA4 (#5181) 2024-03-07 14:00:29 -06:00
subscription_platform
subscription_platform_derived Complete backfill of logical subscription ETLs to populate new discount fields. (#6506) 2024-11-15 00:01:07 +00:00
sumo_ga DSRE-1681 Create 2 new SUMO Google Analytics views in shared prod (#6278) 2024-10-01 03:50:05 +00:00
sumo_ga_derived Make select explicit because GA keeps adding columns (#6523) 2024-11-19 14:23:15 +00:00
taskclusteretl Add dataset_metadata.yaml files for syndicates (#4663) 2023-12-14 01:17:08 +00:00
taskclusteretl_community Add dataset_metadata.yaml files for syndicates (#4663) 2023-12-14 01:17:08 +00:00
taskclusteretl_stage Add dataset_metadata.yaml files for syndicates (#4663) 2023-12-14 01:17:08 +00:00
telemetry DENG-4835 - delete 3 views missed in previous PR (#6469) 2024-11-11 16:10:41 +00:00
telemetry_derived chore(DO-1886): Add shredder mitigation to more tables (#6535) 2024-11-20 17:34:57 +00:00
telemetry_dev_cycle DENG-1729 add data-review-stats view to telemetry dev cycle (#4823) 2024-01-12 17:01:31 +01:00
telemetry_dev_cycle_derived Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
telemetry_dev_cycle_external Change owners on lelis things (#6198) 2024-09-13 18:02:33 +00:00
treeherder_db Revert "DSRE-1620 Temporarily disable treeherder_db syndication (#5524)" (#5538) 2024-05-09 16:31:55 +02:00
udf internet_outage add new udf for geo with no null values (#5962) 2024-07-25 14:39:08 +02:00
udf_js [Bug 1823724] Add flag to missing columns views to indicate that column exists in schema (#6215) 2024-09-19 21:12:31 +00:00
udf_js_lib
udf_legacy Put assert UDFs in `mozfun` project (#4367) 2023-10-13 10:58:42 -07:00