What is Azure Synapse Analytics - Azure Synapse Analytics

rw-book-cover

In this article

  1. Industry-leading SQL
  2. Industry-standard Apache Spark
  3. Working with your Data Lake
  4. Built-in data integration
  5. Data Explorer (Preview)
  6. Unified experience
  7. Engage with the Synapse community
  8. Next steps

Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

Diagram of Azure Synapse Analytics architecture.

Industry-leading SQL

Synapse SQL is a distributed query system for T-SQL that enables data warehousing and data virtualization scenarios and extends T-SQL to address streaming and machine learning scenarios.

Industry-standard Apache Spark

Apache Spark for Azure Synapse deeply and seamlessly integrates Apache Spark--the most popular open source big data engine used for data preparation, data engineering, ETL, and machine learning.

Working with your Data Lake

Azure Synapse removes the traditional technology barriers between using SQL and Spark together. You can seamlessly mix and match based on your needs and expertise.

Built-in data integration

Azure Synapse contains the same Data Integration engine and experiences as Azure Data Factory, allowing you to create rich at-scale ETL pipelines without leaving Azure Synapse Analytics.

Data Explorer (Preview)

Azure Synapse Data Explorer provides customers with an interactive query experience to unlock insights from log and telemetry data. To complement existing SQL and Apache Spark analytics runtime engines, Data Explorer analytics runtime is optimized for efficient log analytics using powerful indexing technology to automatically index free-text and semi-structured data commonly found in the telemetry data.

Use Data Explorer as a data platform for building near real-time log analytics and IoT analytics solutions to:

Unified experience

Synapse Studio provides a single way for enterprises to build solutions, maintain, and secure all in a single user experience

Engage with the Synapse community

Next steps