Data Warehouse
Azure

AZ Synapse

Implements Data Warehouse.

PaaS

Azure Synapse Analytics is an integrated analytics service that unifies enterprise data warehousing with big-data processing. It brings together SQL-based data warehousing, Apache Spark, and data integration pipelines in a single workspace. Its ability to query both relational warehouse data and data lake files from one environment distinguishes it as an end-to-end analytics platform.

Capabilities

  • Columnar storage for fast aggregation
  • Massively parallel query execution
  • Separate storage and compute scaling
  • Batch and streaming ingestion

Primitive

Data WarehouseThis component is an implementation of Data Warehouse. Visit the primitive to learn more about what purpose it serves.

Related services · Azure

Icon-databases-130
AZ SQL
MsPortalFx.base.images-7
AZ Blob Storage
Icon-manage-317
AZ Monitor

Alternatives

Icon-Architecture/64/Arch_Amazon-Redshift_64
AWS Redshift
Icon_24px_BigQuery_Color
GCP BigQuery