Skip to main content

Snowflake Username and Password

Snowflake MFA Requirements

Snowflake is moving towards MFA for all password based sign-ins. We recommend using OAuth for user login and Key pair for automation accounts. For the most recent information, see Snowflake's blog post: Snowflake Will Block Single-Factor Password Authentication by November 2025.

Basic Auth is the fastest way to connect your target database platform to Coalesce, and the credential can be stored either in your local browser's storage (not recommended) or in Coalesce's cloud secrets vault.

Get Your Snowflake Account URL​

  1. Follow the instructions in Snowflake for Finding the organization and account name for an account.
  2. On the Account Details screen, copy the Account/Server URL. You'll need the first part. For example, if your URL is ABC123-1234567.snowflakecomputing.com, you'll need ABC123-1234567.

Add Basic Auth to Snowflake​

  1. Navigate to Build Settings > Environments or Workspaces.
  2. Select Edit on the environment or workspace that you wish to connect to Snowflake using Basic Auth.
  3. In Edit Environment or Workspace > User Credentials, select Authentication Type as Username and Password (Cloud) or Username and Password (Browser Storage).
  4. Enter Username and Password into their respective fields and Save.
Workspace settings interface for configuring Snowflake connection credentials, showing input fields for account URL, username, password, role, and warehouse configurations, with Save and Cancel buttons at the bottom