Snowflake credentials

You can use these credentials to authenticate the following nodes:

Prerequisites

Create a Snowflake account.

Supported authentication methods

Common configuration fields

Both authentication methods require the following fields:

  • An Account name: Your account name is the string of characters located between https:// and snowflakecomputing.com in your Snowflake URL. For example, if the URL of your Snowflake account is https://abc.eu-central-1.snowflakecomputing.com then the name of your account is abc.eu-central-1.

  • A Database: Enter the name of the database the credential should connect to.

  • A Warehouse: Enter the name of the default virtual warehouse to use for the session after connecting. n8n uses this warehouse for performing queries, loading data, and so on.

  • A Schema: Enter the schema you want to use after connecting.

  • A Role: Enter the security role you want to use after connecting.

  • Client Session Keep Alive: By default, client connections typically time out three or four hours after the most recent query execution. Turning this setting on sets the clientSessionKeepAlive parameter to true: the server will keep the client’s connection alive indefinitely, even if the connection doesn’t execute any queries.

Refer to Session Commands for more information on these settings.

Using password authentication

In addition to the common configuration fields, password authentication requires:

  • A Username

  • A Password

Using key-pair authentication

Key-pair authentication provides enhanced security as an alternative to password-based authentication. This method uses a public-private key pair for authentication.

In addition to the common configuration fields, key-pair authentication requires:

  • A Username: The Snowflake user that has the public key assigned to it.

  • A Private Key: The private key in PEM format (PKCS#8). This should be the full content of your private key file, including the -----BEGIN ENCRYPTED PRIVATE KEY----- and -----END ENCRYPTED PRIVATE KEY----- delimiters (or -----BEGIN PRIVATE KEY----- and -----END PRIVATE KEY----- for unencrypted keys).

  • A Passphrase (optional): If your private key is encrypted, enter the passphrase used to encrypt it. Leave this field empty if you’re using an unencrypted private key.

Refer to Snowflake’s key-pair authentication documentation for more information about generating and configuring key pairs.