I would like to know if there are any decision making factors between Azure Synapse vs Delta Lake(Databricks)? in regards of performance/features/PRICE....
Given that the original design is that heavily rely on Store procedure (Azure Synapse) to do the transformation / build some tables(by simple aggregation function like sum/avg/count) for reporting dashboards.
