Skip to content

Use the new MV for AI impact queries

Adam Hegyi requested to merge 470027-replace-cs-daily-usage-table into master

What does this MR do and why?

This MR alters 2 AI metrics queries to use the new materialized view table: code_suggestion_daily_usages -> code_suggestion_daily_events

Why: The new table contains the same data but servers more features. The old code_suggestion_daily_usages table (view) will be eventually removed from the system.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

No user facing change.

The following tests are passing without any modification:

  • ee/spec/services/analytics/ai_analytics/code_suggestion_usage_service_spec.rb
  • ee/spec/services/analytics/ai_analytics/last_code_suggestion_usage_service_spec.rb

Related to #470027 (closed)

Merge request reports