Warehouse

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Warehouse",
  "type": "object",
  "description": "A Snowflake virtual warehouse",
  "properties": {
    "warehouse_type": {
      "type": "string",
      "description": "Type of warehouse, possible types: STANDARD, SNOWPARK-OPTIMIZED"
    },
    "warehouse_size": {
      "type": "string",
      "description": "Size of warehouse, possible sizes: XSMALL, SMALL, MEDIUM, LARGE, XLARGE, XXLARGE, XXXLARGE, X4LARGE, X5LARGE, X6LARGE"
    },
    "wait_for_completion": {
      "type": "string",
      "description": "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": {
      "type": "integer",
      "description": "Specifies the maximum number of clusters for a multi-cluster warehouse"
    },
    "min_cluster_count": {
      "type": "integer",
      "description": "Specifies the minimum number of clusters for a multi-cluster warehouse"
    },
    "scaling_policy": {
      "type": "string",
      "description": "Scaling policy of warehouse, possible scaling policies: STANDARD, ECONOMY"
    },
    "auto_suspend": {
      "type": "integer",
      "description": "time in seconds before auto suspend"
    },
    "auto_resume": {
      "type": "string",
      "description": "Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it"
    },
    "initially_suspended": {
      "type": "string",
      "description": "Specifies whether the warehouse is created initially in the Suspended state"
    },
    "comment": {
      "type": "string",
      "description": "Specifies a comment for the warehouse"
    },
    "enable_query_acceleration": {
      "type": "string",
      "description": "Specifies whether to enable the query acceleration service for queries that rely on this warehouse for compute resources"
    },
    "query_acceleration_max_scale_factor": {
      "type": "integer",
      "description": "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": {
      "type": "integer",
      "description": "Object parameter that specifies the concurrency level for SQL statements executed by a warehouse cluster"
    },
    "statement_queued_timeout_in_seconds": {
      "type": "integer",
      "description": "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": {
      "type": "integer",
      "description": "Object parameter that specifies the time, in seconds, after which a running SQL statement  is canceled by the system"
    },
    "type": {
      "type": "string",
      "description": "[Deprecated] Type of warehouse, possible types: STANDARD, SNOWPARK-OPTIMIZED"
    },
    "size": {
      "type": "string",
      "description": "[Deprecated] names of size: X-Small, Small, Medium, Large, X-Large, 2X-Large, 3X-Large, 4X-Large, 5X-Large, 6X-Large"
    },
    "state": {
      "type": "string",
      "description": "The state of warehouse, possible states: STARTED, STARTING, DYNAMIC, SUSPENDED, RESIZING, RESUMING, SUSPENDING"
    },
    "started_clusters": {
      "type": "integer",
      "description": "Number of clusters currently started."
    },
    "running": {
      "type": "integer",
      "description": "Number of SQL statements that are being executed by the warehouse."
    },
    "queued": {
      "type": "integer",
      "description": "Number of SQL statements that are queued for the warehouse."
    },
    "is_default": {
      "type": "boolean",
      "description": "Whether the warehouse is the default for the current user."
    },
    "is_current": {
      "type": "boolean",
      "description": "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": {
      "type": "string",
      "description": "Percentage of the warehouse compute resources that are provisioned and available."
    },
    "provisioning": {
      "type": "string",
      "description": "Percentage of the warehouse compute resources that are in the process of provisioning."
    },
    "quiescing": {
      "type": "string",
      "description": "Percentage of the warehouse compute resources that are executing SQL statements,  but will be shut down once the queries complete."
    },
    "other": {
      "type": "string",
      "description": "Percentage of the warehouse compute resources that are in a state other than available,  provisioning, or quiescing."
    },
    "created_on": {
      "type": "string",
      "description": "Date and time when the warehouse was created."
    },
    "resumed_on": {
      "type": "string",
      "description": "Date and time when the warehouse was last started or restarted."
    },
    "updated_on": {
      "type": "string",
      "description": "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": {
      "type": "string",
      "description": "Role that owns the warehouse."
    },
    "budget": {
      "type": "string",
      "description": "Comment representing budget for warehouse."
    },
    "kind": {
      "type": "string"
    },
    "owner_role_type": {
      "type": "string",
      "description": "The type of role that owns the object."
    },
    "warehouse_credit_limit": {
      "type": "integer",
      "description": "Credit limit that are can be executed by the warehouse."
    },
    "target_statement_size": {
      "type": "string",
      "description": "Names of size: X-Small, Small, Medium, Large, X-Large, 2X-Large, 3X-Large, 4X-Large, 5X-Large, 6X-Large"
    }
  }
}