topic Re: Load backup file in Warehousing & Analytics

Load backup file

swathiG — Mon, 12 Aug 2024 17:22:19 GMT

Hi Team,

There is a requirement to load a backup file into a database inside a SQL Warehouse. However, I don't see any option to directly load a
backup file.

I have tried reading the backup file using a notebook, but I’m unable to interpret the contents. Here’s the code I’ve used to attempt reading the file:

can anyone please suggest on this.

Re: Load backup file

szymon_dybczak — Mon, 12 Aug 2024 18:29:10 GMT

Hi @swathiG ,

What you are trying to achieve is impossible. You can't restore BAK file into Databricks SQL warehouse.

BAK files are proprietary files that can only be restored in SQL server databases.

Re: Load backup file

swathiG — Tue, 13 Aug 2024 05:52:34 GMT

@szymon_dybczak could you please suggest some other options for how I can proceed to load data from the database?

Re: Load backup file

szymon_dybczak — Tue, 13 Aug 2024 06:08:37 GMT

@swathiG , there are multiple ways. You can use ADF to transfer SQL tables and load them into data lake. Then you can work with them in datbricks SQL warehouse.

If you want only query those tables you can use lakehouse federation:

https://docs.databricks.com/en/query-federation/index.html