Read user
Read a user in Snowflake.
Input
| Field | Definition | Type | Required |
|---|---|---|---|
|
User |
|||
|
User Name |
Username of the user. |
Text | TRUE |
Output
| Field | Definition | Type |
|---|---|---|
|
User |
||
|
User Name |
Username of the user. |
Text |
|
Password |
The user's password. |
Text |
|
Login Name |
The name the user provides to sign in. |
Text |
|
Display Name |
Name displayed for the user. |
Text |
|
First Name |
Given name of the user. |
Text |
|
Middle Name |
Middle name of the user. |
Text |
|
Last Name |
Last name of the user. |
Text |
|
|
The email address of the user. |
Text |
|
Must Change Password |
If true, the user is forced to change their password on their next sign-in, including their first sign-in. |
True/False |
|
Is Disabled |
If true, the user is locked out of Snowflake and can't sign back in. |
True/False |
|
Days To Expiry |
The number of days after which the user status is set to Expired and is no longer allowed to sign in. |
Number |
|
Mins To Unlock |
The number of minutes until the temporary lock on the user sign-in is cleared. |
Number |
|
Default Warehouse |
A virtual warehouse that's active by default for the user's session upon signing in. |
Text |
|
Default Namespace |
The namespace that's active by default for the user's session upon signing in. |
Text |
|
Default Role |
The primary role that's active by default for the user's session upon signing in. |
Text |
|
Default Secondary Roles |
The default secondary roles of this user to use when starting a session. The only valid values are ALL or NONE. |
Text |
|
Mins To Bypass MFA |
The number of minutes until MFA is required again. |
Number |
|
RSA Public Key |
The RSA public key of the user. |
Text |
|
RSA Public Key 2 |
The second RSA public key of the user. |
Text |
|
Comment |
A comment about the user. |
Text |
|
Type |
The type of user:
|
Text |
|
Enable Unredacted Query Syntax Error |
If false, the contents of a failed query are redacted from the views, pages, and functions that provide a query history. |
True/False |
|
Network Policy |
Specifies an existing network policy is active for the user. Otherwise, it uses the account default. |
Text |
|
Created On |
The date and time when the user was created. |
Date & Time |
|
Last Login |
The date and time when the user last signed in to Snowflake. |
Date & Time |
|
Expires At |
The date and time when the user's status is set to Expired and the user can no longer sign in. |
Date & Time |
|
Locked Until |
The date and time until the user is unlocked. |
Date & Time |
|
Has Password |
If true, the user has set a password. |
True/False |
|
Has RSA Public Key |
If true, the user has an RSA Public Key. |
True/False |
|
RSA Public Key Fp |
The fingerprint of the user's RSA Public Key. |
Text |
|
RSA Public Key 2 Fp |
The fingerprint of the user's second RSA Public Key. |
Text |
|
Ext Authn Duo |
If true, Duo is enabled for the user. |
True/False |
|
Ext Authn UID |
The authorization ID used for Duo. |
Text |
|
Owner |
The role that owns the user. |
Text |
|
Locked By Snowflake |
If true, the user, account, or organization is locked. |
True/False |
|
Snowflake Support Usage |
If true, Snowflake Support is allowed to use the user or account. |
True/False |
|
Mins To Bypass Network Policy |
A temporary bypass network policy on the user for a specified number of minutes. |
Number |
|
Password Last Set |
The date and time when the password was last set. |
Date & Time |
|
Custom Landing Page URL |
The landing page URL of the user in Snowflake. |
Text |
|
Custom Landing Page URL Flush Next UI Load |
If true, the custom landing page of the user is flushed on the next UI load. |
True/False |
|
Raw Output |
The raw output returned by the Snowflake API. |
Object |