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:migrate

References

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.rb

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 Dmitry Gruzd

Merge request reports

Loading
Loading