---
id: "alibaba-clickhouse"
type: "component"
kind: "data-warehouse"
provider: "alibabacloud"
category: "data"
docs: "https://www.alibabacloud.com/help/en/clickhouse/"
url: "https://localhost:3000/catalogue/components/alibaba-clickhouse"
---

# ApsaraDB for ClickHouse

Managed column-oriented OLAP database built on open source ClickHouse for real-time analysis over large tables.

| | |
|---|---|
| Provider | [alibabacloud](https://localhost:3000/catalogue?provider=alibabacloud) |
| Kind | [Data warehouse](https://localhost:3000/catalogue/kinds/data-warehouse) |
| Category | Data |
| Official docs | [https://www.alibabacloud.com/help/en/clickhouse/](https://www.alibabacloud.com/help/en/clickhouse/) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `edition` | enum | `enterprise`, `community-compatible` | no | — | inherited |
| `format` | enum | `columnar`, `row` | no | "columnar" | **"columnar"** |
| `managed` | boolean | — | no | false | **true** |
| `realtime` | boolean | — | no | false | **true** |
| `upsert` | boolean | — | no | false | 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
- [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
- [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: "alibaba-clickhouse", component: "alibaba-clickhouse" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# ApsaraDB for ClickHouse: "a fully managed, cloud-native Online Analytical Processing (OLAP) database
# service built on the open-source ClickHouse project" ("What is ApsaraDB for ClickHouse?"). That page states
# the service uses column-oriented storage; "Introduction to ApsaraDB for ClickHouse" describes it as a
# distributed column-oriented database service that provides real-time analysis, and both pages name the
# Enterprise Edition and the Community-compatible Edition.
schemaVersion: "1"
type: "component"
id: "alibaba-clickhouse"
kind: "data-warehouse"
provider: "alibabacloud"
docs: "https://www.alibabacloud.com/help/en/clickhouse/"
defaults:
  managed: true
  realtime: true
  format: "columnar"
properties:
  edition:
    type: "enum"
    values: ["enterprise", "community-compatible"]
```

Human page: https://localhost:3000/catalogue/components/alibaba-clickhouse