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_SECS	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.