How to sync data from Snowflake into Knock

Knock connects to Snowflake with key-pair authentication. Every environment in your account can sync from the warehouse once it's connected.

To add or edit a warehouse, you need the owner or admin role, or a custom permission group that's allowed to manage integrations.

1. Go to Platform > Sources.
2. Under Connect a new source, click Snowflake.
3. Enter a Name and a Key. The key can't be changed later.
4. Click Add warehouse. Knock opens the warehouse's Details tab.

1. On the warehouse's Details tab, fill in the connection:

   Field	What to enter
   Account host	Your account's host, ending in snowflakecomputing.com
   Port	Defaults to 443
   Database	The database to read from
   User	The Snowflake user Knock reads as, such as KNOCK_SYNC

2. Leave Public key empty and click Save connection. Knock generates a key pair and shows the public key.

3. Click Copy public key and assign it to the user in Snowflake, leaving out the BEGIN and END lines:

4. Make sure the user's default role can read the tables you'll sync and that the user has a default warehouse.

5. Click Test connection.

To use a key that's already assigned to the user, paste its public key into Public key before saving.

Once the connection works, create a sync. See create a sync.