- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2022 02:01 PM
Hi @Quentin Maire ,
We need a bit more details.
where is your data stored ?
are you using external or managed tables?
the migrate tool allows you to export DDL statements not the data itself.
I can think about few scenarios on Top of my head.
if you had previously external tables you can create tables in the new workspace using the same adls path, it will allow you to access data.
if you used external tables but you need new location for them (storage account, etc). You cN copy data with azure native tools like az copy to new location. Then create external tables using new location.
I think the above one should work for managed tabela as well, you just need to find out where the data is stored - in the dbfs root location.
you can then copy data into new location and create external tables.
mare you planning to use unity catalog ? You can then create storage credential/external location using exisitng table location and copy data into managed or external tables.
there is few options here, bit if you used the managed tables then most-likely there is a need for copy in your case - if the data storage needs to change as well. The copy can be done with the az copy or some of the databricks options.
Please see here how to ingest data:
https://docs.databricks.com/ingestion/index.html
thanks,
Pat