Snowflake · Schema

ComputePool

A Snowflake compute pool definition.

SnowflakeDataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergMCPT1

Properties

Name	Type	Description
name	object
min_nodes	integer	Minimum number of nodes for the compute pool.
max_nodes	integer	Maximum number of nodes for the compute pool.
instance_family	string	Instance family for the compute pool.
auto_resume	boolean	Whether Snowflake automatically resumes the compute pool when any statement that requires the compute pool is submitted.
comment	string	Comment describing the compute pool.
state	string	Current state of the compute pool. Possible values include UNKNOWN, STARTING, IDLE, ACTIVE, STOPPING, SUSPENDED, and RESIZING.
num_services	integer	Number of services on the compute pool.
num_jobs	integer	Number of jobs on the compute pool.
auto_suspend_secs	integer	Number of seconds until the compute pool automatically suspends.
active_nodes	integer	Number of currently active nodes on the compute pool.
idle_nodes	integer	Number of currently idle nodes on the compute pool.
target_nodes	integer	Number of target nodes on the compute pool.
created_on	string	Time the compute pool was created.
resumed_on	string	Time the compute pool was last resumed.
updated_on	string	Time the compute pool was last updated.
owner	string	Identifier for the current owner of the compute pool.
is_exclusive	boolean	Whether a compute pool is created exclusively for a Snowflake Native App.
application	string	Name of the Snowflake Native App if the compute pool is created exclusively for the app.
budget	string	The name of the budget monitoring the credit usage of the compute pool.
error_code	string	Current error the compute pool hit if any.
status_message	string	Current status of the compute pool if any.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/ComputePool",
  "title": "ComputePool",
  "type": "object",
  "description": "A Snowflake compute pool definition.",
  "properties": {
    "name": {
      "$ref": "./common.yaml#/components/schemas/Identifier"
    },
    "min_nodes": {
      "type": "integer",
      "description": "Minimum number of nodes for the compute pool.",
      "example": 10
    },
    "max_nodes": {
      "type": "integer",
      "description": "Maximum number of nodes for the compute pool.",
      "example": 10
    },
    "instance_family": {
      "type": "string",
      "description": "Instance family for the compute pool.",
      "example": "example_value"
    },
    "auto_resume": {
      "type": "boolean",
      "description": "Whether Snowflake automatically resumes the compute pool when any statement that requires the compute pool is submitted.",
      "example": true
    },
    "comment": {
      "type": "string",
      "description": "Comment describing the compute pool.",
      "example": "example_value"
    },
    "state": {
      "type": "string",
      "description": "Current state of the compute pool. Possible values include UNKNOWN, STARTING, IDLE, ACTIVE, STOPPING, SUSPENDED, and RESIZING.",
      "readOnly": true,
      "enum": [
        "UNKNOWN",
        "STARTING",
        "IDLE",
        "ACTIVE",
        "STOPPING",
        "SUSPENDED",
        "RESIZING"
      ],
      "example": "UNKNOWN"
    },
    "num_services": {
      "type": "integer",
      "description": "Number of services on the compute pool.",
      "readOnly": true,
      "example": 10
    },
    "num_jobs": {
      "type": "integer",
      "description": "Number of jobs on the compute pool.",
      "readOnly": true,
      "example": 10
    },
    "auto_suspend_secs": {
      "type": "integer",
      "description": "Number of seconds until the compute pool automatically suspends.",
      "format": "int64",
      "example": 10
    },
    "active_nodes": {
      "type": "integer",
      "description": "Number of currently active nodes on the compute pool.",
      "readOnly": true,
      "example": 10
    },
    "idle_nodes": {
      "type": "integer",
      "description": "Number of currently idle nodes on the compute pool.",
      "readOnly": true,
      "example": 10
    },
    "target_nodes": {
      "type": "integer",
      "description": "Number of target nodes on the compute pool.",
      "readOnly": true,
      "example": 10
    },
    "created_on": {
      "type": "string",
      "description": "Time the compute pool was created.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "resumed_on": {
      "type": "string",
      "description": "Time the compute pool was last resumed.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "updated_on": {
      "type": "string",
      "description": "Time the compute pool was last updated.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "owner": {
      "type": "string",
      "description": "Identifier for the current owner of the compute pool.",
      "readOnly": true,
      "example": "example_value"
    },
    "is_exclusive": {
      "type": "boolean",
      "description": "Whether a compute pool is created exclusively for a Snowflake Native App.",
      "readOnly": true,
      "example": true
    },
    "application": {
      "type": "string",
      "description": "Name of the Snowflake Native App if the compute pool is created exclusively for the app.",
      "readOnly": true,
      "example": "example_value"
    },
    "budget": {
      "type": "string",
      "description": "The name of the budget monitoring the credit usage of the compute pool.",
      "readOnly": true,
      "example": "example_value"
    },
    "error_code": {
      "type": "string",
      "description": "Current error the compute pool hit if any.",
      "readOnly": true,
      "example": "example_value"
    },
    "status_message": {
      "type": "string",
      "description": "Current status of the compute pool if any.",
      "readOnly": true,
      "example": "example_value"
    }
  },
  "example": {
    "name": "compute_pool_name",
    "warehouse": "test_wh",
    "min_nodes": 4,
    "max_nodes": 5,
    "instance_family": "compute_pool_family",
    "auto_resume": false,
    "comment": "test_comment",
    "state": "STARTING",
    "num_services": 1,
    "num_jobs": 3,
    "auto_suspend_secs": 10,
    "active_nodes": 2,
    "idle_nodes": 2,
    "target_nodes": 4,
    "created_on": "2024-06-18T01:01:01.111111",
    "updated_on": "2024-06-18T01:01:01.111111",
    "resumed_on": "2024-06-18T01:01:01.111111",
    "owner": "POOL_ADMIN",
    "is_exclusive": true,
    "application": "testapp",
    "budget": "testbudget",
    "error_code": "392507",
    "status_message": "Compute Pool is resizing for last 10 minutes. We have observed CAPACITY_ERROR. Please refer to our documentation."
  },
  "required": [
    "name",
    "instance_family",
    "min_nodes",
    "max_nodes"
  ]
}

Work with this as data

Every JSON Schema 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 schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema 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 Schema

curl "https://apis.io/api/v1/json-schemas/snowflake-computepool"

All schemas

curl "https://apis.io/api/v1/json-schemas?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.