Hi @Jdlrobson and @JKatzWMF! The whitelist for the MobileWebSectionUsage EventLogging schema, of which you are the maintainers, is keeping permanently fields that contain both unique session ids and page ids. Per our data retention guidelines, we cannot keep those two items together for more than 90 days and therefore one of them should be removed from the whitelist.
Please let me know which one of the following two you'd like to keep:
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Remove sessionID from whitelist for MobileWebSectionUsage schema | analytics/refinery | master | +0 -1 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • fdans | T205458 Remove sessionId, pageId pairs from whitelist | |||
| Resolved | • Tbayer | T209049 MobileWebSectionUsage schema is whitelisting both session ids and page ids |
This schema is marked as inactive. We're not currently using it.. what am I missing?
cc @Tbayer
@Jdlrobson there's data from this schema that is persisted beyond the 90 day window, which contains the fields above mentioned. Even if the schema is no longer active, we need to remove one of the two fields from the whitelist for the purging script to delete the pertinent data and comply with our retention guidelines.
Discussed with @ovasileva today - we are going to remove the session IDs and keep the page names. I will submit a patch soon.
Change 480470 had a related patch set uploaded (by Fdans; owner: Fdans):
[analytics/refinery@master] Remove sessionID from whitelist for MobileWebSectionUsage schema
Change 480470 merged by Nuria:
[analytics/refinery@master] Remove sessionID from whitelist for MobileWebSectionUsage schema