Snowflake · Schema
Snowflake Warehouse
A Snowflake virtual warehouse provides the compute resources required to execute queries and perform DML operations. A warehouse can be started, suspended, resized, and configured for auto-suspend and auto-resume.
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Identifier for the virtual warehouse. Must be unique within the account. |
| warehouse_type | string | Type of warehouse specifying the compute resource architecture. |
| warehouse_size | string | Size of the warehouse determining the number of compute resources per cluster. |
| wait_for_completion | string | When resizing a warehouse, block the return of the ALTER WAREHOUSE command until the resize has finished provisioning all its compute resources. |
| max_cluster_count | integer | Specifies the maximum number of clusters for a multi-cluster warehouse. For a single-cluster warehouse, this value is 1. |
| min_cluster_count | integer | Specifies the minimum number of clusters for a multi-cluster warehouse. For a single-cluster warehouse, this value is 1. |
| scaling_policy | string | Scaling policy for a multi-cluster warehouse that determines when additional clusters are started or shut down. |
| auto_suspend | integer | Number of seconds of inactivity after which a warehouse is automatically suspended. A value of 0 means the warehouse is never automatically suspended. |
| auto_resume | string | Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it. |
| initially_suspended | string | Specifies whether the warehouse is created initially in the Suspended state. |
| resource_monitor | string | Specifies the name of a resource monitor that is explicitly assigned to the warehouse. When a resource monitor is explicitly assigned, the monitor controls the monthly credits used by the warehouse. |
| comment | string | Specifies a comment for the warehouse. |
| enable_query_acceleration | string | Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources. |
| query_acceleration_max_scale_factor | integer | Specifies the maximum scale factor for leasing compute resources for query acceleration. The scale factor is used as a multiplier based on warehouse size. |
| max_concurrency_level | integer | Object parameter that specifies the concurrency level for SQL statements executed by a warehouse cluster. |
| statement_queued_timeout_in_seconds | integer | Object parameter that specifies the time, in seconds, a SQL statement can be queued on a warehouse before it is canceled by the system. |
| statement_timeout_in_seconds | integer | Object parameter that specifies the time, in seconds, after which a running SQL statement is canceled by the system. |
| warehouse_credit_limit | integer | Credit limit that can be consumed by the warehouse. |
| target_statement_size | string | Target statement size for adaptive warehouses. |
| state | string | The current state of the warehouse. |
| started_clusters | integer | Number of clusters currently started. |
| running | integer | Number of SQL statements that are being executed by the warehouse. |
| queued | integer | Number of SQL statements that are queued for the warehouse. |
| is_default | boolean | Whether the warehouse is the default for the current user. |
| is_current | boolean | Whether the warehouse is in use for the session. Only one warehouse can be in use at a time for a session. |
| available | string | Percentage of the warehouse compute resources that are provisioned and available. |
| provisioning | string | Percentage of the warehouse compute resources that are in the process of provisioning. |
| quiescing | string | Percentage of the warehouse compute resources that are executing SQL statements but will be shut down once the queries complete. |
| other | string | Percentage of the warehouse compute resources that are in a state other than available, provisioning, or quiescing. |
| created_on | string | Date and time when the warehouse was created. |
| resumed_on | string | Date and time when the warehouse was last started or restarted. |
| updated_on | string | Date and time when the warehouse was last updated, which includes changing any of the properties of the warehouse or changing the state. |
| owner | string | Role that owns the warehouse. |
| owner_role_type | string | The type of role that owns the object. |
| budget | string | Budget associated with the warehouse. |