Azure Synapse analytics and SQL On-Demand

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.

To learn ...

Get Implementing Microsoft Dynamics 365 for Finance and Operations Apps - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.