sanger / unified_warehouse

MIT License
2 stars 9 forks source link

Rolling back adding retention instructions to sample table #657

Closed dasunpubudumal closed 2 months ago

dasunpubudumal commented 2 months ago

Closes #633

Changes proposed in this pull request

This migration has already been applied in UAT warehouse. We can introduce a remove_column migration but that will cause problems when the two migrations add_column and remove_column goes into production as add_column in sample table is a huge task (as it is ~4Gi in size).

So the suggested change rollbacks the changes done for adding retention instructions to sample table, so that it will have no effect on the sample table in production. The migration added to UAT database is to be manually removed.

Instructions for Reviewers

[All PRs] - Confirm PR template filled
[Feature Branches] - Review code
[Production Merges to main]
    - Check story numbers included
    - Check for debug code
    - Check version