Bug 1889144 Comment 2 Edit History

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

In context of https://bugzilla.mozilla.org/show_bug.cgi?id=1895503 :mreid pointed out to me that we want to export just the data from newly added `fx_accounts` ping table. With that and thinking about the deletion part more I think the approach that the plan above would implement is too broad.

I think accounts deletion request in its current form should not trigger deletion of all the Firefox telemetry by default. To do that, there should either be a separate request, or a flag in the existing request.

Taking above into account, to let us collect client association ping (https://bugzilla.mozilla.org/show_bug.cgi?id=1903310) we just just shred the newly added ping. This means the plan is to:
1. Add raw, unhashed `uid` to https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_delete_events_v2/query.sql (acceptable per https://docs.google.com/document/d/17eoA4lTdJO6IPjdkzRPT6e7uDbTWM8uGKprgVZA93V8/edit)
2. Add new DeleteSource pointing to `fxa_delete_events_v2.uid` and DeleteTarget pointing to `firefox_desktop_stable.fx_accounts_v1` in Shredder config

/cc :mreid for visibility
In context of https://bugzilla.mozilla.org/show_bug.cgi?id=1895503 :mreid pointed out to me that we want to export just the data from newly added `fx_accounts` ping table. With that and thinking about the deletion part more I think the approach that the plan above would implement is too broad.

I think accounts deletion request in its current form should not trigger deletion of all the Firefox telemetry by default. To do that, there should either be a separate request, or a flag in the existing request.

Taking above into account, to let us collect client association ping (https://bugzilla.mozilla.org/show_bug.cgi?id=1903310) we will just shred the newly added ping. This means the plan is to:
1. Add raw, unhashed `uid` to https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_delete_events_v2/query.sql (acceptable per https://docs.google.com/document/d/17eoA4lTdJO6IPjdkzRPT6e7uDbTWM8uGKprgVZA93V8/edit)
2. Add new DeleteSource pointing to `fxa_delete_events_v2.uid` and DeleteTarget pointing to `firefox_desktop_stable.fx_accounts_v1` in Shredder config

/cc :mreid for visibility

Back to Bug 1889144 Comment 2