Backfill active_users_aggregates per browser
Categories
(Data Platform and Tools :: General, enhancement)
Tracking
(Not tracked)
People
(Reporter: lucia-vargas-a, Unassigned)
Details
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/114.0
Steps to reproduce:
Query data for 2021 in the active_users_aggregates tables.
Actual results:
Related to Jira DENG- .
Data Science requires 2021 data available in telemetry.active_users_aggregates for all browsers, which implies backfilling all the base tables per browser using these commands:
bqetl query backfill firefox_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill fenix_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill focus_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill focus_android_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill klar_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0```
Expected results:
Querying 2021 returns all the metrics correctly.
|
Reporter | |
Comment 2•3 years ago
|
||
Completed:
bqetl query backfill fenix_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill focus_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill focus_android_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill klar_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
Pending to run:
bqetl query backfill firefox_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill firefox_desktop_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
|
||
Comment 3•3 years ago
|
||
The backfill for the below is complete:
bqetl query backfill firefox_ios_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
bqetl query backfill firefox_desktop_derived.active_users_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2021-12-31 -n 0
The snapshots
firefox_desktop_derived.active_users_aggregates_v1-2023-05-03T14_38_14
firefox_ios_derived.active_users_aggregates_v1-2023-05-03T13_23_56
have been created and set to expire on May 19th
|
|
Reporter | |
Comment 4•3 years ago
|
||
All days have data and within the average. Closing the bug.
Description
•