Skip to content

Backfill vulnerability findings' `initial_pipeline_id` column

Michael Becker requested to merge 422383-backfill-first_pipeline_id-and-latest_pipeline_id into master

What does this MR do and why?

Context

As part of the epic to drop the vulnerability_occurrence_pipelines table, we need to ensure that all existing vulnerability findings have their initial_finding_pipeline and latest_finding_pipeline columns backfilled.

We will focus on backfilling the initial_pipeline_id column first, as the latest_pipeline_id column will be populated "naturally" over time by the vulnerability ingestion process.

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.

resolves: #451180
Related to #422383

Edited by Michael Becker

Merge request reports