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
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
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
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
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 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
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
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
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) |