Welcome to Azure Synapse Analytics Database Reference
Azure Synapse Analytics is an integrated analytics service that accelerates time to insight across data warehouses and big data systems. It brings together enterprise data warehousing and Big Data analytics into a single platform. This section provides detailed reference information for the database-related components within Synapse Analytics.
Explore the different types of data stores and compute engines available to build powerful analytical solutions:
SQL Pools (Dedicated & Serverless)
Leverage powerful SQL capabilities for traditional data warehousing and ad-hoc querying over data lakes.
Learn MoreSpark Pools
Utilize Apache Spark for big data processing, machine learning, and advanced analytics with seamless integration.
Learn MoreData Explorer Pools
Enable real-time analytics on streaming and time-series data with the power of Azure Data Explorer.
Learn MoreData Integration & Orchestration
Build and manage data pipelines using Synapse Pipelines for ETL/ELT workflows.
Learn MoreKey Concepts
- Workspace: The central hub for managing all Synapse Analytics resources, including data stores, compute, and pipelines.
- Data Lake Storage Gen2: The primary storage solution for Azure Synapse Analytics, providing a hierarchical namespace and optimized performance for big data analytics.
- Synapse SQL: Offers both Dedicated SQL pools (formerly SQL DW) and Serverless SQL pools for different analytical workloads.
- Synapse Spark: Integrates Apache Spark for big data processing and machine learning.
- Synapse Pipelines: A cloud-based ETL and data integration service for creating data-driven workflows.
Getting Started
To begin using Azure Synapse Analytics:
- Create an Azure Synapse Workspace in the Azure portal.
- Connect to your workspace using the Synapse Studio web interface.
- Provision and configure SQL, Spark, or Data Explorer pools as needed.
- Ingest and explore your data using integrated tools and services.