Skip to main content

​
Prerequisites

  • A Snowflake account.
  • A user with at least read access to the target database, schema, and warehouse.

​
Required fields

​
Optional fields

​
Authentication

​
Password

Enter the Snowflake user’s password. This is the default and requires no extra setup.
Snowflake is phasing out single-factor password sign-in for service users. If your user is affected, use key-pair authentication instead.

​
Key pair

Key-pair authentication signs each connection with an RSA private key instead of sending a password.
  1. Generate a key pair. Use the second command instead if you want the key encrypted with a passphrase.
  2. Extract the public key.
  3. Register the public key on the Snowflake user, pasting the contents of rsa_key.pub without the BEGIN/END lines.
  4. In Mora, select Key pair, then paste the full contents of rsa_key.p8 into Private key — including the -----BEGIN PRIVATE KEY----- and -----END PRIVATE KEY----- lines.
  5. If the key is encrypted (its first line reads -----BEGIN ENCRYPTED PRIVATE KEY-----), enter the passphrase in Key passphrase.
The key must be in PKCS#8 PEM format. A key that starts with -----BEGIN RSA PRIVATE KEY----- is PKCS#1 — convert it with openssl pkcs8 -topk8 -inform PEM -in rsa_key.pem -out rsa_key.p8 -nocrypt.

​
Steps

  1. Open Settings → Datasources → New.
  2. Enter a name and select Snowflake as the type.
  3. Fill in the fields above.
  4. Click Test connection to verify.
  5. Click Create.

​
Finding your account identifier

Your account identifier is in the URL you use to access Snowflake. For example, if you log in at https://xy12345.us-east-1.snowflakecomputing.com, your account identifier is xy12345.us-east-1.