Skip to main content
GET
Get the live status of a Snowflake warehouse

Authorizations

Authorization
string
header
required

Organization API key (sl_…).

Headers

x-tenant-id
string
required

The organization ID the request is scoped to.

Path Parameters

snowflake_account_id
string
required
warehouse_name
string
required

Response

Successful Response

The live state of a Snowflake warehouse, as Snowflake reports it now.

The field names and values are the same as on SnowflakeWarehouse, so a client can join the two by uuid.

uuid
string
required

The identifier Snowflake gives the warehouse.

name
string
required

The name of the warehouse.

type
string
required

The Snowflake warehouse type, for example STANDARD.

state
string
required

The Snowflake state of the warehouse, for example STARTED, SUSPENDED or RESIZING.

started_clusters
integer
required

The number of clusters of the warehouse that run now.

running
integer
required

The number of queries that the warehouse runs now.

queued
integer
required

The number of queries in the queue of the warehouse now.

size
string | null

The Snowflake warehouse size. null for an adaptive warehouse.

min_cluster_count
integer | null

The minimum cluster count of the warehouse.

max_cluster_count
integer | null

The maximum cluster count of the warehouse.

scaling_policy
string | null

The Snowflake scaling policy of the warehouse.

auto_suspend
integer | null

The number of seconds of inactivity after which Snowflake suspends the warehouse.

resumed_time
string | null

When Snowflake last resumed the warehouse, as an RFC 3339 UTC timestamp. null when Snowflake reports no time.