Snowflake · Arazzo Workflow

Snowflake Resume Warehouse and Verify State

Version 1.0.0

Resume a suspended warehouse and confirm it is running by describing it.

1 workflow 1 source API 1 provider
View Spec View on GitHub DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1ArazzoWorkflows

Provider

snowflake

Workflows

resume-warehouse-and-verify
Resume a warehouse, then fetch it to verify it is no longer suspended.
Resumes a suspended virtual warehouse and chains a describe call so the caller can confirm the warehouse state after the resume.
2 steps inputs: authToken, tokenType, warehouseName outputs: resumeStatus, warehouseState
1
resumeWarehouse
Resume the warehouse, tolerating the case where it does not exist.
2
fetchWarehouse
Describe the warehouse to read back its current state.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: Snowflake Resume Warehouse and Verify State
  summary: Resume a suspended warehouse and confirm it is running by describing it.
  description: >-
    An operational flow for waking a suspended Snowflake warehouse before running
    queries against it. The workflow resumes the named warehouse, then describes
    it to read back its current state and confirm the resume took effect. Each
    step inlines its Authorization bearer token and the
    X-Snowflake-Authorization-Token-Type header and its ifExists query parameter
    so the flow can be read and executed without opening the underlying OpenAPI
    description.
  version: 1.0.0
  x-realizes-capability-ids:
  - BC-600.50
  x-capability-derivation:
    method: 'deterministic join: sourceDescriptions -> per-tag OpenAPI -> tag/capability edge. No classification at this step.'
    min_confidence: 0.7
    sources:
    - capability_id: BC-600.50
      capability_name: IT Infrastructure Management
      spec: snowflake-warehouse-api-openapi.yml
      confidence: 0.7
    model: Turbo EA Capabilities by Vincent Verdet — Turbo EA, https://github.com/vincentmakes/turbo-ea-capabilities, CC BY 4.0
sourceDescriptions:
- name: warehouseApi
  url: ../openapi/snowflake-warehouse-api-openapi.yml
  type: openapi
workflows:
- workflowId: resume-warehouse-and-verify
  summary: Resume a warehouse, then fetch it to verify it is no longer suspended.
  description: >-
    Resumes a suspended virtual warehouse and chains a describe call so the
    caller can confirm the warehouse state after the resume.
  inputs:
    type: object
    required:
    - authToken
    - warehouseName
    properties:
      authToken:
        type: string
        description: Bearer token (KEYPAIR_JWT, OAUTH, or programmatic access token).
      tokenType:
        type: string
        description: Value for the X-Snowflake-Authorization-Token-Type header.
        default: OAUTH
      warehouseName:
        type: string
        description: Name of the warehouse to resume.
  steps:
  - stepId: resumeWarehouse
    description: Resume the warehouse, tolerating the case where it does not exist.
    operationId: resumeWarehouse
    parameters:
    - name: name
      in: path
      value: $inputs.warehouseName
    - name: ifExists
      in: query
      value: true
    - name: Authorization
      in: header
      value: Bearer $inputs.authToken
    - name: X-Snowflake-Authorization-Token-Type
      in: header
      value: $inputs.tokenType
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      status: $response.body#/status
  - stepId: fetchWarehouse
    description: Describe the warehouse to read back its current state.
    operationId: fetchWarehouse
    parameters:
    - name: name
      in: path
      value: $inputs.warehouseName
    - name: Authorization
      in: header
      value: Bearer $inputs.authToken
    - name: X-Snowflake-Authorization-Token-Type
      in: header
      value: $inputs.tokenType
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      state: $response.body#/state
  outputs:
    resumeStatus: $steps.resumeWarehouse.outputs.status
    warehouseState: $steps.fetchWarehouse.outputs.state

Work with this as data

Every workflow 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 arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow 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 workflow
curl "https://apis.io/api/v1/arazzo/snowflake-resume-warehouse-and-verify-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?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.

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