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.