Update metastore bucket

[gg_047320_gg_94]

Hello,

Our Databricks workspace is currently hosted on AWS account1, while the meta store bucket is configured within a separate AWS account2. We want to transfer this bucket to account1 to eliminate our reliance on account2. How to configure this bucket and migrate the data without any downtime?

Thank you.

[Kaniz_Fatma]

Hi @gg_047320_gg_94, To migrate your metastore bucket from AWS account2 to account1 without any downtime, you need to create a new bucket in the account1 and then configure it as your new metastore.

Here are the steps:

1. **Create the S3 bucket in account1**: Create a new S3 bucket in account1. This bucket should be in the same region as your Databricks workspaces. Follow AWS's bucket naming rules and create a unique name.

2. **Create a storage configuration record**: This record represents the root S3 bucket. You can create it by calling the create storage configuration API. The API request should include the storage_configuration_name (a new unique storage configuration name) and root_bucket_info (a JSON object that contains a bucket_name field with your S3 bucket name).

[Debayan]

Hi, You can use: https://github.com/databrickslabs/migrate/blob/master/METASTORE.md# for the metastore data migration. 

Please tag @Debayan with your next comment which will get me notified.