Schema:

ACCOUNT_USAGE

COMPUTE_POOLS View

Use this view to get a historical view of compute pools (creation, deletion) in your account for the last 365 days.

Columns

Column name

Data type

Description

NAME

VARCHAR

Compute pool name.

IS_SUSPENDED

BOOLEAN

Whether the pool is currently suspended.

MIN_NODES

INTEGER

Minimum number of nodes in the compute pool.

MAX_NODES

INTEGER

Maximum number of nodes in the compute pool.

INSTANCE_FAMILY

VARCHAR

Machine type of nodes in the compute pool.

AUTO_SUSPEND_SEC

INTEGER

Number of seconds of inactivity after which the compute pool is automatically suspended.

AUTO_RESUME

BOOLEAN

Whether the compute pool is automatically resumed when Snowflake attempts to start a service or job.

CREATED

TIMESTAMP

Date and time when the compute pool was created.

LAST_RESUMED

TIMESTAMP

Date and time when the suspended compute pool was last resumed.

LAST_ALTERED

TIMESTAMP

Date and time when the compute pool was last updated.

DELETED

TIMESTAMP

Date and time when the compute pool was deleted.

OWNER

VARCHAR

Role name that owns the compute pool.

OWNER_ROLE_TYPE

VARCHAR

Type of the role that owns the compute pool.

IS_EXCLUSIVE

BOOLEAN

Whether the compute pool was created for an application.

APPLICATION_NAME

VARCHAR

Application name for which the compute pool was created. Null if the compute pool was not created for an application or if the application no longer exists.

APPLICATION_ID

VARCHAR

Application ID for which the compute pool was created. Null if the compute pool was not created for an application.

COMMENT

VARCHAR

A comment.

Usage notes

  • Latency for the view can be up to 180 minutes (3 hours).