Skip to content

Set `desired_sharding_key` for `security_findings`

What does this MR do and why?

Set desired_sharding_key for security_findings

vulnerability_scanners has a NOT NULL constraint on project_id, so we can use it to backfill the sharding key for security_findings.

Relates to: #454949 (comment 2081070244)

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.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Edited by Brian Williams

Merge request reports

Loading