Snowflake Warehouse | Mondoo Docs

snowflake.warehouse MQL resource for querying Snowflake infrastructure with cnquery and cnspec.

Snowflake

Snowflake Warehouse

Use MQL in cnspec shell or policy:

snowflake.warehouse

Min version: 9.0.0Defaults: name

Relationships

Snowflake

3 resources · 3 relationships·Click to select, expand fields to see properties.

Fields (27)

Field	Type	Description
`autoResume`required	int	Whether the warehouse, if suspended, automatically resumes
`autoSuspend`required	int	Period of inactivity, in seconds, after which a running warehouse automatically suspends and stops using credits
`available`required	float	Percentage of the warehouse compute resources available
`comment`required	string	Comment for the warehouse
`createdAt`required	time	When the warehouse was created
`enableQueryAcceleration`required	int	Whether query acceleration is enabled
`isCurrent`required	int	Whether the warehouse is a current warehouse
`isDefault`required	int	Whether the warehouse is a default warehouse
`maxClusterCount`required	int	Maximum cluster count
`minClusterCount`required	int	Minimum cluster count
`name`required	string	Name of the warehouse
`other`required	float	Percentage of the warehouse compute not in available, provisioning, or quiescing state
`owner`required	string	Warehouse owner
`ownerRoleType`required	string	Owner role type
`provisioning`required	float	Percentage of the warehouse compute resources in provisioning
`queryAccelerationMaxScaleFactor`required	int	Query acceleration scale factor
`queued`required	int	Number of queued clusters
`quiescing`required	float	Percentage of the warehouse compute resources that execute queries
`resourceMonitor`required	string	Resource monitor of the warehouse
`resumedAt`required	time	When the warehouse resumed
`running`required	int	Number of running clusters
`scalingPolicy`required	string	Scaling policy of the warehouse
`size`required	string	Warehouse size
`startedClusterCount`required	int	Number of started clusters
`state`required	string	Whether the warehouse is active/running, inactive or resizing
`type`required	string	Warehouse type
`updatedAt`required	time	When the warehouse was updated