---
id: "oci-autonomous-data-warehouse"
type: "component"
kind: "data-warehouse"
provider: "oci"
category: "data"
aliases: "ADW"
docs: "https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-provision.html"
url: "https://localhost:3000/catalogue/components/oci-autonomous-data-warehouse"
---

# Autonomous AI Lakehouse

Autonomous AI Database data warehouse workload with elastic ECPU scaling.

| | |
|---|---|
| Provider | [oci](https://localhost:3000/catalogue?provider=oci) |
| Kind | [Data warehouse](https://localhost:3000/catalogue/kinds/data-warehouse) |
| Category | Data |
| Official docs | [https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-provision.html](https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-provision.html) |
| Also known as | ADW |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `autonomousDataGuard` | boolean | — | no | false | inherited |
| `computeAutoScaling` | boolean | — | no | true | inherited |
| `computeModel` | enum | `ecpu`, `ocpu` | no | "ecpu" | inherited |
| `ecpuCount` | integer | — | no | 2 | inherited |
| `format` | enum | `columnar`, `row` | no | "columnar" | **"columnar"** |
| `managed` | boolean | — | no | false | **true** |
| `networkAccess` | enum | `secure-access-everywhere`, `allowed-ips-and-vcns`, `private-endpoint` | no | "secure-access-everywhere" | inherited |
| `realtime` | boolean | — | no | false | **false** |
| `storageAutoScaling` | boolean | — | no | false | inherited |
| `upsert` | boolean | — | no | false | **true** |

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
- [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
- [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: "oci-autonomous-data-warehouse", component: "oci-autonomous-data-warehouse" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# Autonomous AI Lakehouse / Data Warehouse workload of Autonomous AI Database Serverless.
# "Provision an Autonomous AI Database Instance": ECPU compute model, 2 ECPUs minimum, compute
# auto scaling on and storage auto scaling off, Oracle-managed keys, secure access from everywhere.
schemaVersion: "1"
type: "component"
id: "oci-autonomous-data-warehouse"
kind: "data-warehouse"
provider: "oci"
docs: "https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/autonomous-provision.html"
aliases: ["ADW"]
defaults:
  managed: true
  format: "columnar"
  upsert: true
  realtime: false
properties:
  computeModel:
    type: "enum"
    values: ["ecpu", "ocpu"]
    default: "ecpu"
  ecpuCount:
    type: "integer"
    default: 2
  computeAutoScaling:
    type: "boolean"
    default: true
  storageAutoScaling:
    type: "boolean"
    default: false
  autonomousDataGuard:
    type: "boolean"
    default: false
  networkAccess:
    type: "enum"
    values: ["secure-access-everywhere", "allowed-ips-and-vcns", "private-endpoint"]
    default: "secure-access-everywhere"
```

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