Hi,
I'm having some issues with renaming a table. There's a an incremental table in my MDW, containing 60 million rows. I'm trying to rename the table whilst keeping all data.
I've tried several combinations (deploy, deploy & execute, deploy with differential deployment unchecked, etc.). But it keeps throwing the same error during the "Deploy Direct Read Transfer" stage of the deployment.
In SSMS I can see that the table was in fact renamed correctly.
The error is:
fact_example to fact_example_old
Invalid object name 'mdw.fact_example'.Yes, I know that's an invalid object name because you've just renamed that table...
At some stage I actually managed to lose all data which is quite unfortunate.
There are a few supernatural key fields, there is a clustered columnstore index, no (custom) table inserts, no relations.
Any ideas what could be causing this? I've got no idea where to look.
Version is 20.10.66.
