---
id: "azure-fabric"
type: "component"
kind: "data-warehouse"
provider: "azure"
category: "data"
docs: "https://learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview"
url: "https://localhost:3000/catalogue/components/azure-fabric"
---

# Microsoft Fabric

SaaS analytics platform unifying data engineering, warehousing, real-time intelligence and Power BI over OneLake.

| | |
|---|---|
| Provider | [azure](https://localhost:3000/catalogue?provider=azure) |
| Kind | [Data warehouse](https://localhost:3000/catalogue/kinds/data-warehouse) |
| Category | Data |
| Official docs | [https://learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview](https://learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `capacitySku` | enum | `f2`, `f4`, `f8`, `f16`, `f32`, `f64`, `f128`, `f256`, `f512`, `f1024`, `f2048` | no | — | inherited |
| `format` | enum | `columnar`, `row` | no | "columnar" | **"columnar"** |
| `managed` | boolean | — | no | false | **true** |
| `mirroring` | boolean | — | no | false | inherited |
| `realtime` | boolean | — | no | false | **true** |
| `upsert` | boolean | — | no | false | inherited |
| `workload` | enum | `data-warehouse`, `lakehouse`, `real-time-intelligence`, `data-science`, `data-factory`, `power-bi` | no | — | inherited |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 39

- [AnalyticDB](https://localhost:3000/catalogue/components/alibaba-analyticdb.md) `alibaba-analyticdb` — alibabacloud
- [ApsaraDB for ClickHouse](https://localhost:3000/catalogue/components/alibaba-clickhouse.md) `alibaba-clickhouse` — alibabacloud
- [Hologres](https://localhost:3000/catalogue/components/alibaba-hologres.md) `alibaba-hologres` — alibabacloud
- [MaxCompute](https://localhost:3000/catalogue/components/alibaba-maxcompute.md) `alibaba-maxcompute` — alibabacloud
- [ApsaraDB for SelectDB](https://localhost:3000/catalogue/components/alibaba-selectdb.md) `alibaba-selectdb` — alibabacloud
- [Amazon Athena](https://localhost:3000/catalogue/components/aws-athena.md) `aws-athena` — aws
- [Amazon Redshift](https://localhost:3000/catalogue/components/redshift.md) `redshift` — aws
- [Azure Analysis Services](https://localhost:3000/catalogue/components/azure-analysis-services.md) `azure-analysis-services` — azure
- [Azure Synapse Analytics](https://localhost:3000/catalogue/components/azure-synapse.md) `azure-synapse` — azure
- [R2 SQL](https://localhost:3000/catalogue/components/cloudflare-r2-sql.md) `cloudflare-r2-sql` — cloudflare
- [ClickHouse](https://localhost:3000/catalogue/components/clickhouse.md) `clickhouse` — default
- [Generic data warehouse](https://localhost:3000/catalogue/components/data-warehouse.md) `data-warehouse` — default
- [Databricks SQL](https://localhost:3000/catalogue/components/databricks-sql.md) `databricks-sql` — default
- [Apache Doris](https://localhost:3000/catalogue/components/doris.md) `doris` — default
- [Dremio](https://localhost:3000/catalogue/components/dremio.md) `dremio` — default
- [Apache Drill](https://localhost:3000/catalogue/components/drill.md) `drill` — default
- [Apache Druid](https://localhost:3000/catalogue/components/druid.md) `druid` — default
- [DuckDB](https://localhost:3000/catalogue/components/duckdb.md) `duckdb` — default
- [Exasol](https://localhost:3000/catalogue/components/exasol.md) `exasol` — default
- [Firebolt](https://localhost:3000/catalogue/components/firebolt.md) `firebolt` — default
- [Greenplum](https://localhost:3000/catalogue/components/greenplum.md) `greenplum` — default
- [Apache Hive](https://localhost:3000/catalogue/components/hive.md) `hive` — default
- [Apache Impala](https://localhost:3000/catalogue/components/impala.md) `impala` — default
- [Apache Kylin](https://localhost:3000/catalogue/components/kylin.md) `kylin` — default
- [MonetDB](https://localhost:3000/catalogue/components/monetdb.md) `monetdb` — default
- [MotherDuck](https://localhost:3000/catalogue/components/motherduck.md) `motherduck` — default
- [Apache Pinot](https://localhost:3000/catalogue/components/pinot.md) `pinot` — default
- [Presto](https://localhost:3000/catalogue/components/presto.md) `presto` — default
- [Snowflake](https://localhost:3000/catalogue/components/snowflake.md) `snowflake` — default
- [StarRocks](https://localhost:3000/catalogue/components/starrocks.md) `starrocks` — default
- [Teradata Vantage](https://localhost:3000/catalogue/components/teradata.md) `teradata` — default
- [Trino](https://localhost:3000/catalogue/components/trino.md) `trino` — default
- [Vertica](https://localhost:3000/catalogue/components/vertica.md) `vertica` — default
- [Google BigQuery](https://localhost:3000/catalogue/components/bigquery.md) `bigquery` — gcp
- [Db2 Warehouse as a Service](https://localhost:3000/catalogue/components/ibm-db2-warehouse.md) `ibm-db2-warehouse` — ibm
- [Netezza Performance Server as a Service](https://localhost:3000/catalogue/components/ibm-netezza.md) `ibm-netezza` — ibm
- [IBM watsonx.data](https://localhost:3000/catalogue/components/ibm-watsonx-data.md) `ibm-watsonx-data` — ibm
- [Autonomous AI Lakehouse](https://localhost:3000/catalogue/components/oci-autonomous-data-warehouse.md) `oci-autonomous-data-warehouse` — oci
- [MySQL HeatWave cluster](https://localhost:3000/catalogue/components/oci-mysql-heatwave-cluster.md) `oci-mysql-heatwave-cluster` — oci

## Use it in a design

```yaml
nodes:
  - { id: "azure-fabric", component: "azure-fabric" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# Microsoft Fabric: SaaS analytics platform over OneLake. "What is Microsoft Fabric" states it is
# delivered as SaaS, that Fabric Data Warehouse natively stores data in the open Delta Lake format,
# and that Real-Time Intelligence analyses data as it arrives. Capacity is bought as F SKUs.
schemaVersion: "1"
type: "component"
id: "azure-fabric"
kind: "data-warehouse"
provider: "azure"
docs: "https://learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview"
defaults:
  realtime: true
  format: "columnar"
  managed: true
properties:
  workload:
    type: "enum"
    values: ["data-warehouse", "lakehouse", "real-time-intelligence", "data-science", "data-factory", "power-bi"]
  capacitySku:
    type: "enum"
    values: ["f2", "f4", "f8", "f16", "f32", "f64", "f128", "f256", "f512", "f1024", "f2048"]
  mirroring:
    type: "boolean"
    default: false
```

Human page: https://localhost:3000/catalogue/components/azure-fabric