Creating a new SQL Pool for Azure Synapse follows the same path as Azure Data Warehouse. Start by making a new SQL Data Warehouse resource in the Azure Portal. This lets you create a new server ...

That includes products like SQL Server, the open source programming interface Apache Spark, A z ure Data Factory and Azure Data S tudio, as well as n otebook interfaces preferred by many data ...

Using a connection to Azure Arc, which is part of the SQL Server 2022 setup process, on-premises users can now also opt for cloud-enabled billing to manage consumption spikes or for ad hoc use cases.

For example, you can use the Azure Synapse Studio notebook to build a customer churn model in Python that accesses data natively from a Synapse SQL pool, as well as an Azure Data Lake source.

Microsoft also highlights Synapse’s integration with Power BI, its easy to use business intelligence and reporting tool, as well as Azure Machine Learning for building models.