cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks ADLS vs Azure Sql ? which is better for datawarehousing ? and why

Ak3
New Contributor III

Databricks ADLS vs Azure Sql ? which is better for datawarehousing ? and why

5 REPLIES 5

Rishabh264
Honored Contributor II

hey @Arunkumar Shanmugasamy​  

A database stores the current data required to power an application. A data lake stores current and historical data for one or more systems in its raw form for the purpose of analyzing the data.

so for Datawarehousing according to me datalake will be the best option so i will go with Databricks ADLS as it has current + historical data also .

Ak3
New Contributor III

Hi Rishabh, thanks for your comment.

As we store data historically that means it might incur storage cost right..!! any comparison of 'storage cost' of Databricks ADLS compared to Azure sql ?

Also, lets say If I am running a query on top of 100GB data with some index set on the table properly. how much computing cost between Databricks compared to Azure Sql ?

Regards, Ak

Aviral-Bhardwaj
Esteemed Contributor III

Rishabh is right

Thanks @Aviral Bhardwaj​ ​

Hubert-Dudek
Esteemed Contributor III

Databricks is the data lake / lakehouse and Azure SQL is the database.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.