Add CH tables for issue analytics queries

What does this MR do and why?

This MR prepares the issues (work items) table to be efficiently queried by groups/projects in ClickHouse.

  • Add traversal_path to efficient group-level querying.
  • Add label_ids and assignee_ids as array columns for JOIN-less filtering.

The MR follows the strategy described in this blueprint: https://handbook.gitlab.com/handbook/engineering/architecture/design-documents/data_insights_platform_hierarchical_data_retrieval_optimization/

High-level overview:

GitLab_ClickHouse_data_model_1_

References

https://gitlab.com/groups/gitlab-org/architecture/gitlab-data-analytics/-/epics/57+

MR acceptance checklist

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

Edited by Adam Hegyi

Merge request reports

Loading