Query endpoint on Azure sql or databricks?

Ruby8376
Valued Contributor

Hi 

Currently all data reauired resides in Az sql database. We have a project in which we need to query on demand this data in Salesforce data cloud to be further used for reporting in CRMA dashboard.

do we need to move this data from az sql to delta lake (databricks) and create query edpoint there then via streaming apis data it can be queried? Or can be done by keeping data in az sql?