Граф коммитов

6260 Коммитов

Автор SHA1 Сообщение Дата
kik-kik ed8e313189
feat: remove the condition resulting in exception if no metric_type value is defined (#6552) 2024-11-22 15:24:56 +00:00
Anna Scholtz e8821ef26a
Update logic for handling errors when Bigeye partitioning is already set (#6549) 2024-11-21 22:30:18 +00:00
Anna Scholtz fac775de35
Backfill iOS onboarding funnels (#6548) 2024-11-21 22:05:48 +00:00
Anna Scholtz 2f655612c8
Disable monitoring for telemetry.releases (#6547) 2024-11-21 20:10:41 +00:00
Anna Scholtz 4a8bdc5cd5
Remove Bigeye Airflow dependency (#6546) 2024-11-21 19:50:01 +00:00
Ben Wu 11d854427c
Deploy materialized views if they do not exist (#6540) 2024-11-21 17:31:46 +00:00
Katie Windau 60fea351c6
Add preventative check to ensure clients_first_seen_v2 and _v3 are never run out of order (#6543)
* Add preventative check to ensure this is never run out of order

* Fix table name
2024-11-20 22:46:55 +00:00
rzhao 65402717f2
Rz modify ios onboarding funnel (#6503)
* Create iOS_onboarding.toml

Added iOS_onboarding.toml - query for generating the underlying table in the iOS onboarding dashboard.

* Update iOS_onboarding.toml

* feat: remove locale from dimension list, it does not exist in the source table

* Delete sql_generators/funnels/configs/iOS_onboarding.toml

* update ios onboarding funnel

* break ios onboarding funnel into two smaller funnels

* break ios onboarding funnel into two smaller funnels (#6537)

* Temporarily add active_users v3 to codeowners until v4 backfill is completed. (#6534)

* chore(DO-1886): Add shredder mitigation to more tables (#6532)

* Add shredder mitigation to desktop eng & ret tables

* Add shredder mitigation to desktop new profile agg v1

* Add fenix_derived.funnel_retention_week_4_v1 to shredder mitigation

* Add urlbar_events_daily_eng_by_pos_v1 to shredder mitigation

* Add firefox_ios_derived.funnel_retention_week_4_v1 shredder mitigation

* Add desktop funnel installs v1 to shredder mitigation

* Add firefox_nondesktop_exact_mau28_v1

* Add shredder mitigation to urlbar_events_daily_v1

* chore(DO-1886): Add shredder mitigation to more tables (#6535)

* Add shredder mitigation to searchreport v1

* Add mobile search agg for search report v1 to shredder mitigation

* Add smoot usage fxa compressed v2 to shredder mitigation

* Add smoot usage new profiles comp v2 to shredder mitigation

* change types ofr created_at and job_created_at from STRING to DATE (#6536)

---------

Co-authored-by: Lucia <30448600+lucia-vargas-a@users.noreply.github.com>
Co-authored-by: Katie Windau <153020235+kwindau@users.noreply.github.com>
Co-authored-by: Marlene Hirose <92952117+Marlene-M-Hirose@users.noreply.github.com>

* Use events_stream table

---------

Co-authored-by: kik-kik <kignasiak@mozilla.com>
Co-authored-by: Lucia <30448600+lucia-vargas-a@users.noreply.github.com>
Co-authored-by: Katie Windau <153020235+kwindau@users.noreply.github.com>
Co-authored-by: Marlene Hirose <92952117+Marlene-M-Hirose@users.noreply.github.com>
Co-authored-by: Anna Scholtz <anna@scholtzan.net>
2024-11-20 22:37:20 +00:00
Sean Rose 19237a99b2
Temporarily change `BigQueryTablePartitionExistenceSensor`s to run in reschedule mode (bug 1932180) (#6542)
* Temporarily change `BigQueryTablePartitionExistenceSensor`s to run in reschedule mode.

There's a bug in those sensors when they run in deferrable mode where the secondary queries they run to detect partitions fail, which is being fixed in apache/airflow#44225.

* Fix `test_dag_with_bigquery_table_sensors`.
2024-11-20 21:25:14 +00:00
Katie Windau 635e3f47ed
chore(DO-1886): Add shredder_mitigation to mobile engagement and retention tables (#6538)
* Add retention generator to have shredder mitigation

* Add engagement
2024-11-20 20:31:05 +00:00
Anna Scholtz 7d252ab9b5
Support for deploying queries consisting of only metadata.yaml and schema.yaml (#6529)
* Support for deploying queries consisting of only metadata.yaml and schema.yaml

* Fix parameter naming for deploy_table; prevent deploys for schemas when views and materialized_views exist

* add test

* Filter out sql and query.py
2024-11-20 19:53:22 +00:00
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
Katie Windau 5a4c6c9aed
chore(DO-1886): Add shredder mitigation to more tables (#6535)
* Add shredder mitigation to searchreport v1

* Add mobile search agg for search report v1 to shredder mitigation

* Add smoot usage fxa compressed v2 to shredder mitigation

* Add smoot usage new profiles comp v2 to shredder mitigation
2024-11-20 17:34:57 +00:00
Katie Windau 648e5c724c
chore(DO-1886): Add shredder mitigation to more tables (#6532)
* Add shredder mitigation to desktop eng & ret tables

* Add shredder mitigation to desktop new profile agg v1

* Add fenix_derived.funnel_retention_week_4_v1 to shredder mitigation

* Add urlbar_events_daily_eng_by_pos_v1 to shredder mitigation

* Add firefox_ios_derived.funnel_retention_week_4_v1 shredder mitigation

* Add desktop funnel installs v1 to shredder mitigation

* Add firefox_nondesktop_exact_mau28_v1

* Add shredder mitigation to urlbar_events_daily_v1
2024-11-20 15:12:09 +00:00
Lucia 29fc585874
Temporarily add active_users v3 to codeowners until v4 backfill is completed. (#6534) 2024-11-20 13:14:18 +00:00
dependabot[bot] d942a57714
Bump aiohttp from 3.10.2 to 3.10.11 (#6520)
Bumps [aiohttp](https://github.com/aio-libs/aiohttp) from 3.10.2 to 3.10.11.
- [Release notes](https://github.com/aio-libs/aiohttp/releases)
- [Changelog](https://github.com/aio-libs/aiohttp/blob/master/CHANGES.rst)
- [Commits](https://github.com/aio-libs/aiohttp/compare/v3.10.2...v3.10.11)

---
updated-dependencies:
- dependency-name: aiohttp
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2024-11-20 00:09:53 +00:00
Katie Windau 8aa22355a0
chore(DO-1887): Add shredder mitigation to search aggregate tables (#6531)
* Add shredder_mitigation = True for search_derived.mobile_search_aggregates_v1

* Adding shredder mitigation to some search_derived aggregate tables
2024-11-19 23:35:47 +00:00
Marlene Hirose cd9d0287cc
add in os.environ.get to get bearer_token (#6528)
* add in os.environ.get to get bearer_token

* properly indent key in metadata
2024-11-19 21:05:00 +00:00
Lucia 02f9d31e95
Remove the scheduler for v4, as rthe tables need to be moved to production via a backfill with shredder mitigation. It will be added after the tables are moved to production. (#6530) 2024-11-19 19:41:19 +00:00
m-d-bowerman 42185bab6a
complete backfill (#6527) 2024-11-19 18:21:48 +00:00
Ben Wu 1e13a6c29a
Support results with no rows in matches_pattern check (#6521)
* Support results with no rows in matches_pattern check

* remove extra )
2024-11-19 18:13:07 +00:00
Marlene Hirose 6890005c1d
add date partition parameter to scheduling in metadata (#6524) 2024-11-19 16:10:55 +00:00
Katie Windau 9cccd521b3
Make select explicit because GA keeps adding columns (#6523) 2024-11-19 14:23:15 +00:00
whd 34218a1f3b
DSRE 1639 (#6522)
* Set retention to 25 months on firefox_desktop_derived.pageload_1pct_v1

* Set retention to 25 months on firefox_desktop_derived.pageload_nightly_v1
2024-11-19 13:45:39 +00:00
Ben Wu 6687e67ba8
Don't set shredder target for datasets with no deletion requests (#6519) 2024-11-19 13:08:57 +00:00
Marlene Hirose dd2a762441
change schema mode from REPEATED to NULLABLE (#6518) 2024-11-18 21:48:06 +00:00
Ben Wu 59e49ea36c
Remove hardcoded dataset in baseline clients last seen check (#6514)
* Remove hardcoded dataset in baseline clients last seen check

* Remove extra .

Co-authored-by: Anna Scholtz <anna@scholtzan.net>

---------

Co-authored-by: Anna Scholtz <anna@scholtzan.net>
2024-11-18 20:38:11 +00:00
whd 16744aaf20
Set retention to 25 months on firefox_desktop_derived.pageload_1pct_v1 (#6513) 2024-11-18 20:25:48 +00:00
Lucia 92b7098f50
Prepare active_users_aggregates for a backfill with shredder mitigation. (#6349)
* Prepare active_users_aggregates for a backfill with shredder mitigation. Rename columns [first_seen_date, os_version, segment] to cascade upstream changes during the backfill for stable numbers.

* Update CODEOWNERS with the new version.

* Avoid modifying the active_users_aggregates view until the new version is backfilled. Remove the view generation from the new version which conflicts with previous version.

* Generate DAG with version.

* Adjust schema to query.

* Ensure attribution columns are present in mobile's schema.

* Convert NULLS in city to '??' as required by existing data.

* Remove uri_count, active_hours from views. Missing 'AS' added to to query.
2024-11-18 20:20:22 +00:00
Ben Wu 037eccc547
Remove row count check for net_thunderbird_android_derived.baseline_clients_last_seen_v1 (#6515) 2024-11-18 20:13:02 +00:00
Marlene Hirose 9fdf7611f3
Deng 6360 add arguments to metadata file (#6517)
* update logic and metadata to use the Cinder token secret

* add trailing white space in jiinja var
2024-11-18 19:48:20 +00:00
m-d-bowerman ad51416036
initiate backfill (#6516) 2024-11-18 18:44:25 +00:00
Marlene Hirose b79a7b9242
initial add of scripts for addon_moderations (#6484)
* initial add of scripts for addon_moderations

* move files over to addon_moderations_derived, update metadata.yaml to partition by date

* update metadata.yaml to type:day and field:date

* change DAG from bqetl_cinder to bqetl_addons

* remove query file, update query.py file"

* take out bexplicit bearer token

* take out clustering
2024-11-15 21:22:05 +00:00
m-d-bowerman 47559f846f
complete backfill (#6512) 2024-11-15 20:16:34 +00:00
Alekhya 8cf14f28e7
Set retention to 25 months on firefox_ios_derived.active_users_aggregates_v1 (#6509) 2024-11-15 18:54:55 +00:00
Marlene Hirose aaa1f14ca6
replace metadata file (#6510) 2024-11-15 18:48:22 +00:00
Lucia b83224393c
Improve checks to account for null replacements (#6508)
* Backfill info.

* Update tests,

* Update tests,
2024-11-15 17:03:02 +00:00
m-d-bowerman 944d6d55df
initiate backfill (#6507) 2024-11-15 16:30:55 +00:00
Sean Rose f40e5415b0
Complete backfill of logical subscription ETLs to populate new discount fields. (#6506) 2024-11-15 00:01:07 +00:00
Ben Wu d329ec4222
Fix Christmas date in tentpole dates csv (#6505) 2024-11-14 21:02:51 +00:00
Katie Windau 44a26dfd1a
Add depends on past = true (#6501) 2024-11-14 17:31:21 +00:00
Chelsey Beck b7ff9f242d
Fix newtab reporting issues caused by the is_list_card filter (#6500)
* updating filter to address null values

* formatting
2024-11-14 17:01:49 +00:00
Sean Rose 2eac9a0fd0
Initiate backfill of logical subscription ETLs to populate new discount fields. (#6495) 2024-11-14 16:20:22 +00:00
Marlene Hirose 0ee397021a
remove backtick (#6486) 2024-11-14 15:59:51 +00:00
Katie Windau 11a9fc0ecc
Update logic to exclude combinations sent previously (#6498) 2024-11-14 14:55:31 +00:00
kik-kik 1f91163f6c
feat: adding an additional case for when metric.metric_type is null inside _update_bigconfig (#6482) 2024-11-14 10:05:59 +00:00
Anna Scholtz 2bd130526e
Improve Bigeye error reporting (#6493) 2024-11-14 00:55:36 +00:00
Sean Rose c5b4f8efc3
Incorporate discounts into the logical subscription ETLs (DENG-974) (#6474)
* Fix subscription discounts join to exclude discounts which already ended.

* Incorporate discounts into the logical subscription ETLs.
2024-11-14 00:36:51 +00:00
Sean Rose 16589156cf
Complete backfill of `subscription_platform_derived.monthly_active_logical_subscriptions_v1`. (#6492) 2024-11-13 23:43:58 +00:00
ryboland 09f1605399
Add more dates to Key Tentpoles data.csv (#6491)
Add more dates for 2023
2024-11-13 22:31:03 +00:00