Hi, Databricks Community
I am currently plan to do migrate of existing metastore (not in a desired account and name) to a new one (a different desired account) within the same region. I understand it is not as straightforward it might be and complicated.
Can I ask, what might be the best approach to actually fulfil this?
What could be the issue if Metastore and the S3 bucket is set up on different region?
We have set up external tables and connects with existing Metastore, would we lose tehm once we move to the new one?
Can we set up a sync between the new and existing Metastore and S3 bucket, what impact could that lead to?
is there anything that we need to concern about this idea?