Geo - Finalize the the backfill of the new verification details tables

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Problem

As part of the effort to split the verification details for the replicates using the same table to store the verification stat (4) into separate tables, we created the new tables and started the backfilling process in #515873. We must finalize the backfill for the mutable data types and ignore the original columns that store the verification state. This should be done in the next release after a required stop. We plan to do this in %18.0, which is the release after the last stop required % 17.11.

Replicable Models using the same table to store the verification state:

• Ci::PipelineArtifact
• Packages::PackageFile
• SnippetRepository
• Terraform::StateVersion

Proposal

1. Update the application to read from the new table only for the immutable data types (Ci::PipelineArtifact, Packages::PackageFile, Terraform::StateVersion) during Geo's usual verification processes to backfill the separate tables.
2. Ignore the original columns. This starts the process of safely removing database columns, as described in our guides.