Create user

Create a user in Snowflake.

Options

Field Definition Type Required

If User Exists

Choose how to handle user creation when a user with the same name exists already.

  • Throw Error: Throws an error if you try to create a resource that exists.

  • Replace: Automatically replaces the existing resource with the current one.

  • Ignore: Creates the user if it doesn't exist, otherwise returns 200, indicating it exists.

Dropdown TRUE

User Type

The type of user.

  • Person: The user is a human user who can interact with Snowflake.

  • Service: The user is a service or app that interacts with Snowflake without human interaction.

  • Legacy service: Similar to Service, but also allows password and SAML authentication.

Dropdown FALSE

Input

Field Definition Type Required

User

User Name

Username of the user.

Usernames are case-sensitive. For example, TESTUSER and testuser are treated as two different users.

 Text TRUE

Password

The user's password.

The password must be at least 14 characters long, contain at least one digit, one uppercase letter, and one lowercase letter.

Text FALSE

Login Name

The name that the user provides to sign in.

Text FALSE

Display Name

Name displayed for the user.

Text FALSE

First Name

Given name of the user.

Text FALSE

Middle Name

Middle name of the user.

Text FALSE

Last Name

Last name of the user.

Text FALSE

Email

The email address of the user.

Text FALSE

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 FALSE

Is Disabled

If true, the user is locked out of Snowflake and can't sign back in.

True/False 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 FALSE

Mins To Unlock

The number of minutes until the temporary lock on the user sign-in is cleared.

Number FALSE

Default Warehouse

A virtual warehouse that's active by default for the user's session upon signing in.

Text FALSE

Default Namespace

The namespace that's active by default for the user's session upon signing in.

Text FALSE

Default Role

The primary role that's active by default for the user's session upon signing in.

Text FALSE

Default Secondary Roles

The default secondary roles of this user to use when starting a session. The only valid values are ALL or NONE.

Dropdown FALSE

Mins To Bypass MFA

The number of minutes until MFA is required again.

Number FALSE

RSA Public Key

The RSA public key of the user.

Text FALSE

RSA Public Key 2

The second RSA public key of the user.

Text FALSE

Comment

A comment about the user.

Text FALSE

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 FALSE

Network Policy

Specifies an existing network policy is active for the user. Otherwise, it uses the account default.

Text FALSE

Output

Field Definition Type

Result

Status Code

The status code returned by the server.

Number

Status

The status message returned by the server.

Text