Update bulk_import_export_uploads sharding

What does this MR do and why?

As part of the cells preparation, the import & integrate team needs to set the sharding key for a few tables, and clean up any old data as well as setting appropriate foreign keys and database checks. The original MR to do this has been broken up into individual MRs per table as suggested during the review process, to make reviewing easier.

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.

Related to #463854 (closed)

changed milestone to %17.5

added Category:Cell analytics instrumentation backend database devopsfoundations groupimport and integrate milestonep1 missed:17.4 sectioncore platform typemaintenance workflowin dev labels

assigned to @knejad

added pipelinetier-1 label

added databasereview pending label

	1 Message
	CHANGELOG missing: If this merge request needs a changelog entry, add the Changelog trailer to the commit message you want to add to the changelog. If this merge request doesn't need a CHANGELOG entry, feel free to ignore this message.

Reviewer roulette

Category	Reviewer	Maintainer
database	@lma-git (UTC-7, 7 hours behind author)	@DylanGriffith (UTC+11, 11 hours ahead of author)

Please refer to documentation page for guidance on how you can benefit from the Reviewer Roulette, or use the GitLab Review Workload Dashboard to find other available reviewers.

If needed, you can retry the danger-review job that generated this comment.

Generated by Danger

marked this merge request as ready

changed the description

added workflowready for review label and removed workflowin dev label

changed milestone to %17.6

mentioned in issue #463854 (closed)

mentioned in merge request !168003 (merged)

changed the description

@bmarjanovic could you do the initial database review for this please?

requested review from @bmarjanovic

approved this merge request

removed review request for @bmarjanovic

added pipeline:mr-approved label

added pipelinetier-2 label and removed pipelinetier-1 label

Before you set this MR to auto-merge

This merge request will progress on pipeline tiers until it reaches the last tier: pipelinetier-3. We will trigger a new pipeline for each transition to a higher tier.

Before you set this MR to auto-merge, please check the following:

• You are the last maintainer of this merge request
• The latest pipeline for this merge request is pipelinetier-3 (You can find which tier it is in the pipeline name)
• This pipeline is recent enough (created in the last 8 hours)

If all the criteria above apply, please set auto-merge for this merge request.

See pipeline tiers and merging a merge request for more details.

requested review from @Andyschoenen

E2E Test Result Summary

allure-report-publisher generated test report!

e2e-test-on-gdk: test report for cb941cff

expand test summary

+------------------------------------------------------------------+
|                          suites summary                          |
+-------------+--------+--------+---------+-------+-------+--------+
|             | passed | failed | skipped | flaky | total | result |
+-------------+--------+--------+---------+-------+-------+--------+
| Verify      | 45     | 0      | 2       | 0     | 47    | ✅     |
| Plan        | 76     | 0      | 0       | 0     | 76    | ✅     |
| Monitor     | 8      | 0      | 0       | 0     | 8     | ✅     |
| Govern      | 75     | 0      | 4       | 1     | 79    | ✅     |
| Ai-powered  | 0      | 0      | 1       | 0     | 1     | ➖     |
| Create      | 129    | 0      | 19      | 0     | 148   | ✅     |
| Fulfillment | 2      | 0      | 0       | 0     | 2     | ✅     |
| Data Stores | 33     | 0      | 1       | 0     | 34    | ✅     |
| Release     | 5      | 0      | 0       | 0     | 5     | ✅     |
| Package     | 17     | 0      | 18      | 0     | 35    | ✅     |
| Analytics   | 2      | 0      | 0       | 0     | 2     | ✅     |
| Manage      | 1      | 0      | 1       | 0     | 2     | ✅     |
| Secure      | 4      | 0      | 0       | 0     | 4     | ✅     |
+-------------+--------+--------+---------+-------+-------+--------+
| Total       | 397    | 0      | 46      | 1     | 443   | ✅     |
+-------------+--------+--------+---------+-------+-------+--------+

e2e-test-on-cng: test report for cb941cff

expand test summary

+------------------------------------------------------------------+
|                          suites summary                          |
+-------------+--------+--------+---------+-------+-------+--------+
|             | passed | failed | skipped | flaky | total | result |
+-------------+--------+--------+---------+-------+-------+--------+
| Plan        | 86     | 0      | 8       | 14    | 94    | ✅     |
| Verify      | 50     | 0      | 15      | 10    | 65    | ✅     |
| Monitor     | 8      | 0      | 12      | 0     | 20    | ✅     |
| Package     | 24     | 0      | 14      | 0     | 38    | ✅     |
| Govern      | 81     | 0      | 12      | 10    | 93    | ✅     |
| Create      | 139    | 0      | 21      | 21    | 160   | ✅     |
| Manage      | 1      | 0      | 9       | 0     | 10    | ✅     |
| Data Stores | 33     | 0      | 10      | 1     | 43    | ✅     |
| Ai-powered  | 0      | 0      | 2       | 0     | 2     | ➖     |
| Analytics   | 2      | 0      | 0       | 0     | 2     | ✅     |
| Configure   | 0      | 0      | 3       | 0     | 3     | ➖     |
| ModelOps    | 0      | 0      | 1       | 0     | 1     | ➖     |
| Growth      | 0      | 0      | 2       | 0     | 2     | ➖     |
| Secure      | 1      | 0      | 6       | 0     | 7     | ✅     |
| Fulfillment | 2      | 0      | 7       | 0     | 9     | ✅     |
| Release     | 5      | 0      | 1       | 0     | 6     | ✅     |
+-------------+--------+--------+---------+-------+-------+--------+
| Total       | 432    | 0      | 123     | 56    | 555   | ✅     |
+-------------+--------+--------+---------+-------+-------+--------+

approved this merge request

added databaseapproved label and removed databasereview pending label

resolved all threads

added pipelinetier-3 pipeline:run-e2e-omnibus-once labels and removed pipelinetier-2 label

enabled automatic add to merge train when checks pass

added this merge request to the merge train at position 2

merged

Hello @knejad

The database team is looking for ways to improve the database review process and we would love your help!

If you'd be open to someone on the database team reaching out to you for a chat, or if you'd like to leave some feedback asynchronously, just post a reply to this comment mentioning:

@gitlab-org/database-team

And someone will be by shortly!

Thanks for your help!

This message was generated automatically. You're welcome to improve it.

mentioned in commit d884c9e7

added workflowstaging-canary label and removed workflowready for review label

added workflowcanary label and removed workflowstaging-canary label

added workflowstaging label and removed workflowcanary label

added workflowproduction label and removed workflowstaging label

added workflowpost-deploy-db-staging label and removed workflowproduction label

added workflowpost-deploy-db-production label and removed workflowpost-deploy-db-staging label

added releasedcandidate label

added releasedpublished label and removed releasedcandidate label