Loading
Add system_note_metadata to Siphon replication
What does this MR do and why?
Adds system_note_metadata to Siphon replication so it is available in ClickHouse as siphon_system_note_metadata.
GKG system-notes edge materialization depends on the action discriminator from this table. Stage 1 lifecycle-edge views (siphon_system_note_merged, siphon_system_note_closed, siphon_system_note_reopened) and Stage 2 cross-reference parsing both need this table replicated to avoid expensive joins and to filter parseable system notes at scale.
Generated with:
bundle exec rails generate gitlab:click_house:siphon system_note_metadata --with-traversal-path
bundle exec rake gitlab:clickhouse:migrateReferences
- gitlab-org/orbit/knowledge-graph#499 (closed)
- #594122 (closed)
- https://gitlab.com/dgruzd/tasks/-/work_items/2726
- https://docs.gitlab.com/development/database/clickhouse/clickhouse_table_design_with_siphon/
How to set up and validate locally
bundle exec rails generate gitlab:click_house:siphon system_note_metadata --with-traversal-path
bundle exec rake gitlab:clickhouse:migrate
bundle exec rspec spec/lib/generators/gitlab/click_house/siphon_generator_spec.rbMR 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 Dmitry Gruzd