Sanjeeb2024
Valued Contributor

Hi @Rose_15 - Thanks for the details. It is better to do a planning like number of tables, size and number of records and better to extract the files to a cloud storage and reload the data using any mechanism. Once your extraction is complete, you will not depend upon source server and always load the file in databricks tables. If possible, you can explore the approach to extract it in .parquet file which will reduce the size as well.

 

Sanjeeb Mohapatra