Bug 1799688 Comment 3 Edit History

Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.

Original comment by
on 
`unified_metrics`, `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` are the downstream tables. 
Wondering if all need to be done at once (since I'm waiting on unified metrics PR to be approved) or can go ahead with `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` followed by `unified_metrics_v1`

In which case will run the below backfill commands: 

./bqetl query backfill search_derived.mobile_search_clients_last_seen_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0

./bqetl query backfill search_derived.mobile_search_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0
Revision 1 by
on 
`unified_metrics`, `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` are the downstream tables. 
Wondering if all need to wait for all to be run at once (since I'm waiting on unified metrics PR to be approved) or can go ahead with `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` followed by `unified_metrics_v1`

In which case will run the below backfill commands: 

./bqetl query backfill search_derived.mobile_search_clients_last_seen_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0

./bqetl query backfill search_derived.mobile_search_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0
Revision 2 by
on 
`unified_metrics`, `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` are the downstream tables. 
Wondering if I need to wait for all to be run at once (since I'm waiting on unified metrics PR to be approved) or can go ahead with `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` followed by `unified_metrics_v1`

In which case will run the below backfill commands: 

./bqetl query backfill search_derived.mobile_search_clients_last_seen_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0

./bqetl query backfill search_derived.mobile_search_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0
Revision 3 by
on 
`unified_metrics`, `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` are the downstream tables. 
Wondering if I need to wait for all to be run at once (since I'm waiting on unified metrics PR to be approved) or can go ahead with `mobile_search_clients_last_seen_v1` and `mobile_search_aggregates_v1` followed by `unified_metrics_v1`

In this case will run the below backfill commands: 

./bqetl query backfill search_derived.mobile_search_clients_last_seen_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0

./bqetl query backfill search_derived.mobile_search_aggregates_v1 --project_id=moz-fx-data-shared-prod -s 2021-01-01 -e 2022-11-30 -n 0

Back to Bug 1799688 Comment 3