Load backup file

[swathiG]

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.

[szymon_dybczak]

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.

[swathiG]

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

[szymon_dybczak]

@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