If there's an issue migrating the data with STORAGE_MIGRATION 'after' the table has been 'renamed', we need to provide a restore script that will reset the table names back to the original.
A case when this happens is when 'hive' doesn't have the rights to create the warehouse location for the table. Which happens AFTER the table has already been altered/renamed.
If there's an issue migrating the data with STORAGE_MIGRATION 'after' the table has been 'renamed', we need to provide a restore script that will reset the table names back to the original.