Azure Synapse Analytics is an analysis service which combines big Data Warehouses with Big Data Analytics, and the product is an evolution of Azure SQL Data Warehouse. You can make data queries in your data lake – either with serverless resources or resources ready for use – on a large scale. It is primarily when we talk about large scale (more than 1 terabyte of data in your Data Warehouse) that Synapse makes sense for you.
Azure Synapse Analytics merges these two worlds into one experience that prepares, administrates and serves data relatively quickly, to be used, for instance, in Business Intelligence and Machine Learning.
With Azure Synapse Analytics, both relational and non-relational data can be queried using the known SQL language. This can be done either with serverless on-demand-queries for data exploration and ad hoc analyses or resources ready for use for the most demanding needs for data storage. In other words, one simple platform regardless of needs.