1707921 - Some event properties are not being updated

Status: RESOLVED WONTFIX

(Data Platform and Tools :: General, defect, P1)

Description

[Frank Bertsch [:frank]]

I was investigating a difference between Amplitude and Looker funnel counts for an onboarding experiment. Looking at e.g. the message_id PIN-A_AW_PIN_FIREFOX, with even CLICK_BUTTON, there are no event properties in event_types_history_v1.

Upon a bit of digging, the problem is during the new_event_property_value_indices portion of the extraction query. It seems to be missing the event property values for the new types.

Relevant query: https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/messaging_system_derived/event_types_history_v1/query.sql

Comment 1

[GitHub Bugzilla PR Linker]

Attachment: Link to GitHub pull-request: https://github.com/mozilla/bigquery-etl/pull/1980

Comment 2

[Rob Miller [:rmiller]]

Hello,

The Mozilla Data Engineering organization is currently going through our extensive backlog, consisting of hundreds of issues stretching back for nearly 10 years. We've done a pass through all of the open bugzilla bugs and have identified and tagged the ones that we think are relevant enough to still need attention. The rest, including the bug with which this comment is associated, we are closing as "WONTFIX" in a single bulk operation.

If you feel we have closed this (or any) issue in error, please feel free to take the following actions:

• Reopen the bug.
• Edit the bug to add the string [dataplatform] (including the brackets) to the Whiteboard field. (Note that you must edit the Whiteboard, not the similarly named QA Whiteboard.)

Doing this will ensure that we see the bug in our weekly triage process, where we will decide how to proceed.

Thank you.