Hello people,
I am currently investigating the added value of Azure Synapse Analytics as a DWH solution versus doing it the traditional way with a Azure SQL database and Azure Data Factory. I also noticed in Azure SQL Server there is an option to create a Dedicated SQL Pool so my question is: What is the added benefit of using Azure Synapse Analytics versus just making a Dedicated SQL Pool in your Azure SQL Server and using Azure Data factory for your ETL, since Synapse seems to be using ADF as well but a watered down version in their Synapse studio. Is there something I'm missing here? Because to me it looks like they're very similar and I don't see what value using Synapse brings to my DWH.
For context the data model is a dimensional model that isn't that complex. The data amount is also not extremely huge and the purpose this DWH mainly serves is historization and a central data source for PowerBI Reports.
Thank in advance!