Snowflake · JSON Structure

Warehouse Warehouse Structure

Type: object Properties: 36

DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1

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

{
  "$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"
    }
  }
}

Work with this as data

Every JSON Structure here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for json structure

4 MCP tools reach this

find_json_structuresBrowse and filter every JSON Structure in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This JSON Structure

curl "https://apis.io/api/v1/json-structures/warehouse-warehouse-structure"

All json structure

curl "https://apis.io/api/v1/json-structures?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.