---
id: "data-warehouse"
type: "component"
kind: "data-warehouse"
provider: "default"
category: "data"
url: "https://localhost:3000/catalogue/components/data-warehouse"
---

# Generic data warehouse

Vendor-neutral data warehouse. Use when the real product is not in the catalogue; every rule for this kind still applies.

| | |
|---|---|
| Provider | [default](https://localhost:3000/catalogue?provider=default) |
| Kind | [Data warehouse](https://localhost:3000/catalogue/kinds/data-warehouse) |
| Category | Data |
| Official docs | not recorded |
| Generic? | Vendor-neutral: the kind itself |

## Properties

| property | type | values | required | default |
|---|---|---|---|---|
| `format` | enum | `columnar`, `row` | no | "columnar" |
| `managed` | boolean | — | no | false |
| `realtime` | boolean | — | no | false |
| `upsert` | boolean | — | no | false |

## 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
- [Microsoft Fabric](https://localhost:3000/catalogue/components/azure-fabric.md) `azure-fabric` — 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
- [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: "data-warehouse", component: "data-warehouse" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# The vendor-neutral data warehouse: the kind itself, with no product behind it. It sets no
# defaults and adds no properties, so every required kind property stays required on the node.
schemaVersion: "1"
type: "component"
id: "data-warehouse"
kind: "data-warehouse"
provider: "default"
```

Human page: https://localhost:3000/catalogue/components/data-warehouse