Formally known as SQL DW, Azure Synapse Analytics brings together enterprise data warehousing and big data analytics. Azure synapse analytics combines data integration, machine learning, and Power BI into one suite to provide a complete end-to-end analytics experience.
The following diagram shows the Azure Synapse Analytics service at a high level:
SQL On-Demand is a serverless capability within Azure Synapse Analytics that provides analytics directly over the Data Lake without creating a copy or duplicating the data. You can simply use the familiar T-SQL query data stored in Azure Data Lake.