This page will walk you through the setup of Snowflake in K.
Access to Snowflake
Snowflake integration uses username/password. Using keys will be supported in an upcoming release
Create a Snowflake user with access to following tables in the Snowflake database.
account_usage.history
account_usage.views
account_usage.tables
account_usage.columns
account_usage.copy_history
account_usage.grants_to_roles
account_usage.grants_to_users
Setting up Snowflake in K
Select Platform Setting > Integration / Sources
Click Add Source and Select Snowflake
Select Direct Connect and add your Snowflake details and click Next
Name: The name you wish to give your Snowflake DB in K
Host: Add the host URL of your Snowflake account. Omit the https:// and anything from and including .snowflakecomputing.com/….
Warehouse: Default warehouse for the user
Add the user details and click Save.
Select the Databases you wish to load into K and click Finish Setup
Go to the Sources page and select Edit Schedule
Set a schedule for when the Snowflake load will occur
To run a manual extract go to Platform Settings > Platform Settings / Batch Manager
Select Source Load > Run
Select Snowflake and Click Run
A manual source load will also require a manual run of
DAILY
GATHER_METRICS_AND_STATS
To load all metrics and indexes with the manually loaded metadata. These can be found in the Batch Manager page