Connect with Snowflake

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 start, 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, Hyperline will only need a read access to the tables you need to synchronise.

​

Load your data

Snowlake is a standard SQL loaders and you just 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 an id, customerId and timestamp fields with the correct casing.