Some additional columns need to be added to the local_group_default_T_mediarequest_per_referer.data & local_group_default_T_mediarequest_per_file.data tables in support of new endpoints that expose video plays.
See also: https://docs.google.com/document/d/1JVzKS4qeOEAAR1gnQhWzU5Iqzuha2czJjLk7K2suCHo/edit?tab=t.0
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T108522 Record and report metrics for audio and video playback | |||
| Open | None | T198628 Count the number of video plays | |||
| Open | Snwachukwu | T415202 Introduce a new AQS endpoint to expose video plays | |||
| Resolved | Eevans | T420008 Alter AQS Cassandra tables in support of video plays endpoints |
Change #1251445 had a related patch set uploaded (by Eevans; author: Eevans):
[generated-data-platform/aqs/media-analytics@main] cassandra schema changes for videoplays
Change #1251445 merged by jenkins-bot:
[generated-data-platform/aqs/media-analytics@main] cassandra schema changes for videoplays
Done.
FYI: These tables didn't already exist in staging, but have been created now (complete with the schema change). Obviously there isn't any existing data, so (as a reminder) if you load staging with some test data (which I do recommend), be sure to put in place some sampling as the staging cluster has nowhere near the capacity of production, and some of these tables are large(ish). Limiting it to the last few days, weeks (or even months) should be fine.
Thanks for creating the tables in staging @Eevans.
be sure to put in place some sampling as the staging cluster has nowhere near the capacity of production
Noted. A few days should be fine.
Change #1261504 had a related patch set uploaded (by Eevans; author: Eevans):
[operations/puppet@production] cassandra_dev: add aqsloader grants to staging
Change #1261504 merged by Eevans:
[operations/puppet@production] cassandra_dev: add aqsloader grants to staging
Change #1266247 had a related patch set uploaded (by Eevans; author: Eevans):
[operations/puppet@production] cassandra_dev: add media_analytics role & grants
Change #1266247 merged by Eevans:
[operations/puppet@production] cassandra_dev: add media_analytics role & grants
{{Done}}
I'm going to close this issue (I think we've completed what's in-scope). Please don't hesitate to re-open it if you spot any problems.