Azure Documentation

Azure Synapse Analytics - Reference

Welcome to the comprehensive reference documentation for Azure Synapse Analytics. This section provides detailed information on services, features, APIs, and best practices for building and managing your data warehousing and big data analytics solutions on Azure.

Overview

Azure Synapse Analytics is an integrated analytics service that accelerates time to insight across data warehouses and big data systems. It allows you to query data using serverless on-demand or provisioned resources at a petabyte scale. Synapse brings together data integration, enterprise data warehousing, and big data analytics into a single, unified experience.

Key Components and Features

• SQL Pools (Dedicated and Serverless): For enterprise data warehousing and ad-hoc query capabilities.
• Spark Pools: For big data processing and machine learning using Apache Spark.
• Data Explorer Pools: For near real-time analytics on log and telemetry data.
• Pipelines and Integration: Data integration capabilities for ETL/ELT, orchestration, and monitoring.
• Management and Security: Tools for managing access, governance, and security.
• Monitoring and Performance: Insights into query performance, resource utilization, and costs.

Common Reference Topics

Explore the following sections for detailed information:

• SQL Pool Reference:
  • Dedicated SQL Pool Concepts
  • Serverless SQL Pool Concepts
  • T-SQL Syntax for Synapse Analytics
  • Performance Tuning Best Practices
• Spark Pool Reference:
  • Spark Pool Overview
  • Apache Spark Libraries
  • Synapse Notebooks
• Data Integration:
  • Synapse Pipelines
  • Pipeline Activities
  • Datasets and Linked Services
• APIs and SDKs:
  • REST API Reference
  • SDK Documentation
• Monitoring and Management:
  • Monitoring Synapse Analytics
  • Security and Compliance