Forum Discussion
Azure Synapse dedicated SQL pool vs. Azure SQL vs SQL
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 mul...
Hi
You're right Azure SQL database is well suited for small needs . However i would suggest to see the comparison below to have better visibility
https://stackify.com/azure-sql-database-vs-warehouse/
Have you tried to estimate how much cost ASA with the least compute nodes /DWU ?
Azure Synapse analytics uses Azure storage to store data so No you cannot use another service for storage purpose .
You will be able to use both in Azure Data Factory .
You can find the supported linked services types here ;
https://docs.microsoft.com/en-us/azure/data-factory/parameterize-linked-services