Snowflake · JSON Structure

Warehouse Warehouse Structure

Type: object Properties: 36
Data LakesData SharingData WarehousingDatabaseSQL

Warehouse is a JSON Structure definition published by Snowflake, describing 36 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

warehouse_type warehouse_size wait_for_completion max_cluster_count min_cluster_count scaling_policy auto_suspend auto_resume initially_suspended comment enable_query_acceleration query_acceleration_max_scale_factor max_concurrency_level statement_queued_timeout_in_seconds statement_timeout_in_seconds type size state started_clusters running queued is_default is_current available provisioning quiescing other created_on resumed_on updated_on owner budget kind owner_role_type warehouse_credit_limit target_statement_size

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "Warehouse",
  "type": "object",
  "properties": {
    "warehouse_type": {
      "type": "string"
    },
    "warehouse_size": {
      "type": "string"
    },
    "wait_for_completion": {
      "type": "string"
    },
    "max_cluster_count": {
      "type": "integer"
    },
    "min_cluster_count": {
      "type": "integer"
    },
    "scaling_policy": {
      "type": "string"
    },
    "auto_suspend": {
      "type": "integer"
    },
    "auto_resume": {
      "type": "string"
    },
    "initially_suspended": {
      "type": "string"
    },
    "comment": {
      "type": "string"
    },
    "enable_query_acceleration": {
      "type": "string"
    },
    "query_acceleration_max_scale_factor": {
      "type": "integer"
    },
    "max_concurrency_level": {
      "type": "integer"
    },
    "statement_queued_timeout_in_seconds": {
      "type": "integer"
    },
    "statement_timeout_in_seconds": {
      "type": "integer"
    },
    "type": {
      "type": "string"
    },
    "size": {
      "type": "string"
    },
    "state": {
      "type": "string"
    },
    "started_clusters": {
      "type": "integer"
    },
    "running": {
      "type": "integer"
    },
    "queued": {
      "type": "integer"
    },
    "is_default": {
      "type": "boolean"
    },
    "is_current": {
      "type": "boolean"
    },
    "available": {
      "type": "string"
    },
    "provisioning": {
      "type": "string"
    },
    "quiescing": {
      "type": "string"
    },
    "other": {
      "type": "string"
    },
    "created_on": {
      "type": "string"
    },
    "resumed_on": {
      "type": "string"
    },
    "updated_on": {
      "type": "string"
    },
    "owner": {
      "type": "string"
    },
    "budget": {
      "type": "string"
    },
    "kind": {
      "type": "string"
    },
    "owner_role_type": {
      "type": "string"
    },
    "warehouse_credit_limit": {
      "type": "integer"
    },
    "target_statement_size": {
      "type": "string"
    }
  }
}