Azure Data Platform

Comprehensive overview of Microsoft Azure data services, from ingestion to analytics

Azure Data Platform Architecture

Presentation Layer
Power BI
Excel
Custom Apps
Copilot
Analytics & AI
Microsoft Fabric
Synapse Analytics
Databricks
Azure OpenAI
ML Studio
Data Storage
OneLake (Fabric)
Data Lake (ADLS Gen2)
Cosmos DB
SQL Database
Blob Storage
Data Integration
Data Factory
Event Hubs
Stream Analytics
Logic Apps
Governance & Security
Microsoft Purview
Entra ID
Key Vault
Defender for Cloud
Fabric
Microsoft Fabric
Unified Analytics Platform
SaaS analytics platform unifying data engineering, data science, real-time analytics, and BI. Built on OneLake with automatic data virtualization.
OneLake Lakehouse Power BI Copilot Real-time
Synapse
Azure Synapse Analytics
Enterprise Analytics Service
Enterprise data warehousing and big-data analytics (serverless and dedicated SQL pools, Spark). Now being folded into Microsoft Fabric - the path forward for new analytics workloads.
SQL Pools Spark Pools Pipelines Serverless
Databricks
Azure Databricks
Apache Spark Analytics
First-party Databricks integration on Azure. Unified analytics with Delta Lake, MLflow, and Unity Catalog for data governance.
Delta Lake Unity Catalog MLflow Workflows
Data Factory
Azure Data Factory
Data Integration Service
Cloud-based ETL and data integration service. 100+ built-in connectors with visual pipeline designer and mapping data flows.
Pipelines Data Flows 100+ Connectors SSIS
Data Lake
Data Lake Storage Gen2
Scalable Data Lake
Blob storage with hierarchical namespace for analytics workloads. ABFS driver for Hadoop compatibility with enterprise security.
HNS ABFS ACLs Parquet
Purview
Microsoft Purview
Data Governance
Unified data governance for on-premises, multi-cloud, and SaaS data. Data catalog, classification, lineage, and policy management.
Catalog Lineage Classification Policies
Event Hubs
Event Hubs
Big Data Streaming
Fully managed real-time data ingestion service. Apache Kafka compatible with millions of events per second throughput.
Kafka API Capture Partitions Schema Registry
Stream Analytics
Stream Analytics
Real-time Analytics
Serverless real-time analytics engine. SQL-based query language for streaming data with temporal joins and windowing functions.
SQL Queries Windowing ML Functions Reference Data

Platform Comparison: Fabric vs Synapse vs Databricks

Feature Microsoft Fabric Synapse Analytics Databricks
Status Flagship (default) Into Fabric Mature
Storage OneLake (Delta) ADLS Gen2 Delta Lake (ADLS/DBFS)
Compute Serverless, Capacity-based SQL Pools, Spark Pools Clusters, SQL Warehouses
BI Integration Power BI Native Power BI Power BI, Tableau
Governance Purview (Native) Purview Unity Catalog
AI/ML Copilot, Data Science Spark ML MLflow, AutoML
Pricing Capacity Units (CU) DWU / Spark vCores DBU (Databricks Units)