Request:
Look into adding a notification_type field to the echo_notification table (or alternatively, reopen T296437 to renable Echo).
Rationale
There was notificationType field in the Echo Schema but that was disabled and we decided not to reenable it in T296437. As a result, this either needs to be added to echo_notification or we need to renable Echo so we know the type of notification that was sent. This is specifically needed to complete the topic notification analysis in T280897.
Note: EchoInteraction is currently active and includes a notificationType field however, this schema only logs events that are interacted with by the user. We also need to be also to determine the types of notifications that are sent and not interacted with by the user (which we should be able to do with this addition)
Requirements
- echo_notification table is logging events with a notification_type field, which can be used to isolate events sent by the DiscussionTools (event.notificationType = 'dt-subscribed-new-comment')
Done
- All ===Requirements are met
- @MNeisler verifies that aggregate data is landing in database(s) as expected