Snowflake · Schema
Warehouse
A Snowflake virtual warehouse
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| warehouse_type | string | Type of warehouse, possible types: STANDARD, SNOWPARK-OPTIMIZED |
| warehouse_size | string | Size of warehouse, possible sizes: XSMALL, SMALL, MEDIUM, LARGE, XLARGE, XXLARGE, XXXLARGE, X4LARGE, X5LARGE, X6LARGE |
| wait_for_completion | string | When resizing a warehouse, you can use this parameter to 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 |
| min_cluster_count | integer | Specifies the minimum number of clusters for a multi-cluster warehouse |
| scaling_policy | string | Scaling policy of warehouse, possible scaling policies: STANDARD, ECONOMY |
| auto_suspend | integer | time in seconds before auto suspend |
| 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 |
| 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 |
| type | string | [Deprecated] Type of warehouse, possible types: STANDARD, SNOWPARK-OPTIMIZED |
| size | string | [Deprecated] names of size: X-Small, Small, Medium, Large, X-Large, 2X-Large, 3X-Large, 4X-Large, 5X-Large, 6X-Large |
| state | string | The state of warehouse, possible states: STARTED, STARTING, DYNAMIC, SUSPENDED, RESIZING, RESUMING, SUSPENDING |
| 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. To specify or change the warehouse for a session, use the USE WAREHOUSE command. |
| 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 (STARTED, SUSPENDED, RESIZING) of the warehouse. |
| owner | string | Role that owns the warehouse. |
| budget | string | Comment representing budget for warehouse. |
| kind | string | |
| owner_role_type | string | The type of role that owns the object. |
| warehouse_credit_limit | integer | Credit limit that are can be executed by the warehouse. |
| target_statement_size | string | Names of size: X-Small, Small, Medium, Large, X-Large, 2X-Large, 3X-Large, 4X-Large, 5X-Large, 6X-Large |