# WAREHOUSE

Config path: `/warehouse.yaml`

Example:

```yaml
task_wh:
  size: XSMALL
  auto_suspend: 60
```

```yaml
multi_custer_wh:
  size: SMALL
  generation: 2
  min_cluster_count: 1
  max_cluster_count: 4
  auto_suspend: 60
```

## Schema

* *{key} (ident) -* warehouse name
* {value} (dict)
  * <mark style="background-color:red;">**size**</mark> (str) - warehouse size
  * **type** (str) - warehouse [type](https://docs.snowflake.com/en/user-guide/warehouses.html)
  * **generation** (str) - (default: "1")
  * **min\_cluster\_count** (int) - (default: 1)
  * **max\_cluster\_count** (int) - (default: 1)
  * **scaling\_policy** (str) - (default: STANDARD)
  * **auto\_suspend** (int) - number of idle seconds before warehouse is automatically suspended (default: 60)
  * **resource\_monitor** (ident) - name of resource monitor managed by [SnowDDL config](/basic/yaml-configs/resource-monitor.md)
  * **global\_resource\_monitor** (ident) - name of resource monitor created externally
  * **enable\_query\_acceleration** (bool) - enable [query acceleration service](https://docs.snowflake.com/en/user-guide/query-acceleration-service.html)
  * **query\_acceleration\_max\_scale\_factor** (int) - (default: 8)
  * **resource\_constraint** (str) - (default `MEMORY_X16`  for Snowpark-optimized warehouses)
  * **warehouse\_params** (dict)
    * *{key}* (ident) - warehouse param name
    * *{value}* (bool, float, int, str) - warehouse param value
  * **comment** (str)

## Usage notes

1. Values for `size` are available in [CREATE WAREHOUSE](https://docs.snowflake.com/en/sql-reference/sql/create-warehouse.html#optional-properties-objectproperties) documentation.
2. Scaling policy and multi-cluster warehouses require [Enterprise Edition or higher](https://docs.snowflake.com/en/user-guide/intro-editions.html).
3. `resource_monitor` can only be applied by user with `ACCOUNTADMIN` role.
4. All warehouses are created with `INITIALLY_SUSPENDED` and `AUTO_RESUME` enabled.
5. When creating Snowpark-optimized warehouse, please pay attention to `resource_constraint` values depending on warehouse size. Default is `MEMORY_16X`, which requires at least `MEDIUM` warehouse size. For small warehouse sizes you should set `MEMORY_1X` or similar constraint explicitly.

## Links

* [CREATE WAREHOUSE](https://docs.snowflake.com/en/sql-reference/sql/create-warehouse.html)
* [ALTER WAREHOUSE](https://docs.snowflake.com/en/sql-reference/sql/alter-warehouse.html)
* [SHOW WAREHOUSES](https://docs.snowflake.com/en/sql-reference/sql/show-warehouses.html)
* [Parser & JSON Schema (GitHub)](https://github.com/littleK0i/SnowDDL/blob/master/snowddl/parser/warehouse.py)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.snowddl.com/basic/yaml-configs/warehouse.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.