Delta Live tables vs Azure SQL DB for a read intensive application

techie001
New Contributor

‎09-23-2024 12:50 AM

Hi,

I am looking for some advice to compare cost and performace between Delta Live tables vs Azure SQL DB files in Azure Blob for building the backend for a web application.
There would be very frequent read operation(Multiple searches every second) and write frequency would be 3-4 times a day. Data needs to be stored in SCD type 2.

 

0 Kudos

gchandra
Databricks Employee
Databricks Employee

‎09-24-2024 08:24 AM

As far as I know, Azure SQL DB is RDBMS, whereas DLT is to build a data pipeline. 



~
0 Kudos