lucami
Contributor

Hi @szymon_dybczak,

I suggest you the following:

  1. Create storage credential
  2. Register an external location for new storage location
  3. Create the catalog with a managed location
  4. Migrate table with full Delta history using DEEP CLONE


-- Azure example
CREATE EXTERNAL LOCATION extloc_target
  URL 'abfss://<container>@<account>.dfs.core.windows.net/<prefix>'
  WITH STORAGE CREDENTIAL cred_mi
  COMMENT 'Target path for managed catalog';


CREATE CATALOG my_catalog
  MANAGED LOCATION 'abfss://<container>@<account>.dfs.core.windows.net/<prefix>';

 

CREATE TABLE my_catalog.core.my_table
DEEP CLONE src_catalog.core.my_table;