| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This page will walk through the setup of Snowflake in K.
...
Select Direct Connect and add your Snowflake details and click Next
Fill in the Source Settings and click Next
Name: The name you wish to give your Snowflake DB in K
Host: Add your Snowflake Account (found in your Snowflake URL)
Omit the https:// and anything from and including .snowflakecomputing.com/….
For example:
from the URL
Information Database Role: Add the role the user should use
Warehouse: Add the warehouse the user should use
...
Add the Connection details and click Save to test the connection. Click & Next when connection is successful
Snowflake account: Use the same details (Snowflake account) you previously added in the Host setting
Username: Add the Snowflake user name
Password: Add the Snowflake user password
...
Test your connection and click Save
Select the Databases you wish to load into K and click Finish Setup
All databases will be listed. If you have a lot of databases this may take a few seconds to load
Return to the Sources page and locate the new Snowflake source that you loaded
Click on the clock icon to select Edit Schedule and set your preferred schedule for the Snowflake load
...