Follow-up from "AI Impact: Add GraphQL API for AI Acceptance Rate"

The following discussion from !157035 (merged) should be addressed:

• @pshutsin started a discussion: (+3 comments)

  @ahegyi I wonder if we can remove daily usages and reuse this MV? By expanding this MV for all events we can then do SELECT max(date), user_id AS last_used_at FROM code_suggestion_daily_events WHERE event = 1 GROUP BY user_id to get last usage for event 1.

  I assume that the query will not scan entire table because we have all fields in ORDER BY key. Is it correct?

assigned to @pshutsin

mentioned in merge request !157035 (merged)

changed milestone to %17.2

added Stretch backend clickhouseapproved devopsplan documentation groupoptimize pipelinetier-3 pipeline:mr-approved priority2 sectiondev typefeature workflowin dev labels

removed workflowin dev label

removed clickhouseapproved label

removed pipelinetier-3 label

removed documentation label

removed pipeline:mr-approved label

removed Stretch label

added maintenanceremoval label

added typemaintenance label and removed typefeature label

set weight to 1

@blabuschagne FYI I've added this cleanup issue to %17.3

changed milestone to %17.3

added workflowready for development label

mentioned in issue gitlab-org/quality/triage-reports#18634 (closed)

mentioned in issue gitlab-org/quality/triage-reports#18721 (closed)

@pshutsin This issue looks like it may slip this current milestone. Can you leave a or to signify if you are on track to deliver this issue? Please also consider updating the issue's Health Status or Milestone to reflect its current state, and communicate with your Product Manager as appropriate.

Bot policy.

It's planned for %17.3

@pshutsin is this workflowverification?

@blabuschagne no it's still in TODO. I didn't have time to work on this follow-up.

mentioned in issue gitlab-org/quality/triage-reports#18803 (closed)

mentioned in issue gitlab-org/quality/triage-reports#18916 (closed)

unassigned @pshutsin

assigned to @ahegyi

added workflowin dev label and removed workflowready for development label

mentioned in merge request !161276 (merged)

mentioned in merge request !161280 (merged)

added workflowverification label and removed workflowin dev label

added workflowcomplete label and removed workflowverification label

closed

added devopsmonitor label and removed devopsplan label