Search users

Search for users in Snowflake.

Options

Field Definition Type Required

Result Set

Choose one of the following options to display your search results:

  • First Matching Record: Returns the first matching record.

  • First 100 Matching Records: Returns the first 100 matching records.

  • Stream Matching Records: Passes all matching records from your parent flow to a helper flow.

Dropdown TRUE

Filter

Choose one of the following filter options to search for roles:

  • Like: Filter the command output by role name. Uses case-insensitive pattern matching. This filter supports the Percentage(%) and Underscore(_) SQL wildcard characters.

  • Starts With: Filter the command output based on the string of characters that appear at the beginning of the object name. Uses case-sensitive pattern matching.

  • From Name: Enable fetching rows only following the first row whose object name matches the specified string. This filter is case-sensitive and doesn't have to be the full name.

Dropdown FALSE

Input

Field Definition Type Required

Search By

User Name

Username of the user.

Text FALSE

Streaming

Flow

Click Choose Flow to browse and select a helper flow where the search results will be streamed, then click Choose to confirm.

Optionally, click the empty field under Click or drop here to create and add custom extensible fields that pass data to the helper flow. These fields are added as key/value pairs under the State output object in the helper flow.

This field appears when you select Stream Records from the Result Set field.

Flow

 TRUE

Record Limit

Specify the number of records to stream.

  • When the Record Limit field is set to greater than 0, the stream returns up to the maximum number specified.

  • When the Record Limit field is null or not selected, all records are streamed.

  • The default value is 10000.

  • The valid range for the Like and Starts With filters is from 1 to 1000000. The valid range for the From Name filter is from 1 to 10000.

Number FALSE

Output

Field Definition Type

Result

User Name

Username of the user.

Text

Password

The user's password.

Text

Login Name

The name that 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

Email

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

Type of user

  • Person

  • Service

  • Legacy Service

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

Records Streamed

The number of records streamed in a streaming flow.

This field appears when you select Stream Matching Records from the Result Set field.

 Number