It is an advanced analytics service that combines business data warehousing and Big Data analytics. Azure Synapse leverages the best SQL technologies used in data warehousing, Spark technologies used in big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB and AzureML.
What is Azure Synapse?
Azure Synapse is:
Synapse SQL is a distributed query system for T-SQL that enables data warehousing and data virtualization scenarios and extends T-SQL with stream processing and machine learning scenarios.
Apache Spark industry standard
Apache Spark for Azure Synapse seamlessly integrates Apache Spark – the most popular open source big data engine used for data preparation, data engineering, ETL and machine learning.
Working with Data Lake
Synapse Azure removes the traditional technology barriers between using SQL and Spark. You can seamlessly mix and match both technologies depending on your needs and experience.
Built-in data integration
Azure Synapse includes the same data integration engine as Azure Data Factory, allowing you to create rich ETL pipelines without leaving Azure Synapse Analytics.
A unified experience
Synapse Studio provides a single way to create solutions, maintain and secure within a single user experience.
Implementation, maintenance and development of the solution
Integration and retrieval of various data sources
Consulting, workshops and training for end users