Skip to main content
This guide is specific to setting up a dataloader with Snowflake, to learn more about data loaders in general, you can read our general article.

​
Connect to your database

To get started, just go to the data loaders page in Hyperline, create a new Connection and select “Snowflake” in the dropdown list.
Fill in the form with your connection details (account ID, username, warehouse, database, schema, role). Hyperline will only need read access to the tables you need to synchronise.

​
Authentication

Hyperline supports two authentication modes for Snowflake, selectable from the Authentication dropdown in the connection form:
  • Password — authenticate with the Snowflake user’s password.
  • Key pair (RSA) — authenticate with an RSA private key that is registered on the Snowflake user.
Snowflake is deprecating single-factor password authentication on August 31, 2026. If your connection uses a password today, plan to migrate to key-pair authentication (or another supported method) before that date to avoid disruption.

​
Password authentication

Select Password and enter the user’s password in the Password field.

​
Key pair (RSA) authentication

Select Key pair (RSA) and provide:
  • Private key — the RSA private key registered on the Snowflake user, in PEM format. Paste the full key including the -----BEGIN PRIVATE KEY----- and -----END PRIVATE KEY----- lines (or the encrypted equivalent).
  • Private key passphrase (optional) — the passphrase protecting the private key, if it is encrypted. Leave empty for unencrypted keys.
Refer to Snowflake’s key-pair authentication guide for instructions on generating a key pair and assigning the public key to a Snowflake user.

​
Load your data

Snowflake is a standard SQL loader and you just need to write a Snowflake compatible SQL query. Hyperline will run it as the role/user that was used to connect to the database. As always, make sure to include id, customerId and timestamp fields with the correct casing.