Hello,
currently we operate on-premises PostgreSQL DB that we use as our data warehouse.
I would like to set up a data warehouse in Azure, but the Azure portal is bit confusing, as there are multiple options:
1) in Azure Synapse, there is dedicated SQL pool (formerly labeled as Azure Data Warehouse)
Then, outside Azure Synapse there are two additional options:
2) Azure SQL database ( /BrowseResource/resourceType/Microsoft.Sql%2Fazuresql ) and
3) "SQL database" (/BrowseResource/resourceType/Microsoft.Sql%2Fservers%2Fdatabases)
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
describes that Azure SQL (#2 above) uses symmetric multiprocessing (SMP) while "Azure Synapse Analytics" (#1) above uses massively parallel processing (MPP).
My data needs are not so vast to utilize the MPP. Thus it seems I should be considering #2, i.e. outside the Synapse Analytics.
Azure SQL (#2) above further branches into "Single Database", "Elastic pool" and "Single instance managed DB".
I am guessing that for my scenario, "Azure SQL - Single Database" is the best option.
If I choose this, will I be able to use this storage in Azure Synapse Analytics?
Furthermore, to use Azure Data Factory (ADF) - if I set up "Azure SQL - Single Database", should I be aiming to use Data Factory within Azure Synapse Analytics, or outside it (i.e. use ADF in Azure portal)?
