We have been evaluating Databricks SQL and its capability to be used as DW. We are using Unity catalog in our implementation.
There seems to be a functionality mismatch between Azure and AWS versions as where table rename is supported on Azure side, it is prohibited on AWS side.
This seems like a bug as when using Unity catalog the whole table renaming operation is done in metadata, not in file system (error claims that the operation is not permitted as S3 is only eventually consistent).
I opened an IDEA in the Databricks ideas, https://ideas.databricks.com/ideas/DBE-I-1143
Could you have a look at this and perhaps give us some idea whether this could be part of the product in the near future?
