Skip to content

Use the recently added contributions view for CA

Adam Hegyi requested to merge ah-make-ca-use-the-contributions-view into master

What does this MR do and why?

This MR removes the contribution analytics specific materialized view/table and uses the new contributions view for querying the data. Not a user-facing change.

The contributions materialized views contains almost the same data but it includes some extra events that we need to filter out in query time.

How to set up and validate locally

  1. Ensure that you're on ultimate, click house is enabled and enable the feature flags
    Feature.enable(:event_sync_worker_for_click_house)
    Feature.enable(:clickhouse_data_collection)
    ClickHouse::EventsSyncWorker.new.perform
  2. Visit any group, Analyze > ContributionAnalytics
  3. Some data should show up if there was activity in the group

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Adam Hegyi

Merge request reports