Skip to content

Backfill `initial_pipeline_id` and `latest_pipeline_id`

We need to ensure that all existing vulnerability findings have their initial_finding_pipeline and latest_finding_pipeline columns backfilled before dropping the vulnerability_occurrence_pipelines table.

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

We do not expect any circumstance under which a vulnerability_occurrence cannot have these fields fields filled in.

Implementation Plan

Edited by Michael Becker