Snowflake User | Mondoo Docs

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

Snowflake

Snowflake User

Use MQL in cnspec shell or policy:

snowflake.user

Min version: 9.0.0Defaults: name

Relationships

Snowflake

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

Field	Type	Description
`comment`required	string	Comment for the user
`createdAt`required	time	When the user was created
`defaultNamespace`required	string	Namespace that is active by default
`defaultRole`required	string	Default role for the user
`defaultWarehouse`required	string	Virtual warehouse that is active by default
`disabled`required	int	Whether the user is disabled
`displayName`required	string	Display name
`email`required	string	Email address
`expiresAt`required	time	When the user expires
`extAuthnDuo`required	int	Whether the user has MFA enabled
`extAuthnUid`required	string	MFA user ID
`firstName`required	string	First name
`hasPassword`required	int	Whether the user has a password
`hasRsaPublicKey`required	int	Whether the user has MFA enabled
`lastName`required	string	Last name
`lastSuccessLogin`required	time	Last time the user logged in
`lockedUntil`required	time	Time until the user is locked
`login`required	string	Login name
`mustChangePassword`required	int	Whether the user is forced to change their password
`name`required	string	User name
`parameters`	[]snowflake.parameter	Parameters for the user