Restoring delta tables from an old metastore to the new one.

[drii_cavalcanti]

Hi everyone,

Just wondering if I copy the catalog folders (under the metastore storage) to a different s3 bucket, once I have a new metastore with a new ID I can restore the tables as they were <catalog_name>.<schema_name>.<table_name> into the new metastore by using COPY INTO command.

Thank you all!

[drii_cavalcanti]

Hi Kaniz,

thanks for your reply.

The tables in the old metastore were external managed tables. I have copied them to a new bucket and then now I was hoping to get them back into the new metastore by creating an external location and a credential storage.

I was wondering if there was a way to map them back into the correct namespace in the new metastore. I saw that in the external bucket, the folder tables only has tables identified by their ids so then I wanted to find somehow a table called tables in the information_schema and from there, be able to do the mapping.

Adriana C