Snowflake Native App Connector

Kumo connects to your Snowflake data warehouse using a Snowflake Connector. Creating a Snowflake connector in Kumo requires the following steps:

Step 1: Grant the privileges required

The following is the minimum set of privileges that should be granted to the Kumo Snowflake app to successfully create a Snowflake connector.

Note

1. The following commands should be run by a user who has OWNERSHIP or WITH GRANT OPTION privileges on the objects (warehouse, database, schema and tables) being granted access to.
2. The objects used in the commands (warehouse, database, and schema) must be the same as those used to create the connector (in Step 2 below).
3. See Warehouse sizing table below for the size of the warehouse to use.

-- In the following, replace KUMOAPP_NAME, DB_NAME, SCHEMA_NAME and WAREHOUSE_NAME with
-- those that will be used to build models with Kumo.
SET KUMOAPP_NAME='<KUMOAPP_NAME>';
SET DB_NAME='<DB_NAME>';
SET SCHEMA_NAME='<DB_NAME>.<SCHEMA>';
SET WAREHOUSE_NAME='<WAREHOUSE_NAME>';
GRANT USAGE ON WAREHOUSE IDENTIFIER($WAREHOUSE_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT USAGE ON DATABASE IDENTIFIER($DB_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT USAGE ON SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT SELECT, REFERENCES ON ALL TABLES IN SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT SELECT, REFERENCES ON ALL VIEWS IN SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT SELECT, REFERENCES ON ALL MATERIALIZED VIEWS IN SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT CREATE TABLE ON SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);
GRANT DROP TABLE ON SCHEMA IDENTIFIER($SCHEMA_NAME) TO APPLICATION IDENTIFIER($KUMOAPP_NAME);

Step 2: Creating the Snowflake connector

1. To set up a new Snowflake connector, click on Connectors in the left-hand column, followed by the Configure Connector button on the “Connectors” page.

2. On the “Snowflake Connector” window, provide a name for your Snowflake connector and add the following connection details. The necessary privileges (described above) must be granted to the Kumo application before this step.

• Account Identifier - The account identifier uniquely identifies your Snowflake account. This should be provided as ORGNAME-ACCOUNT_NAME. The ORGNAME and ACCOUNT_NAME can be retrieved for your Snowflake account using the instructions here.
• Database - The Snowflake database where the input relational data exists (same as the one in Step 1).
• Warehouse - The warehouse that will be used to read and process data in Snowflake (same as the one in Step 1).
• Schema Name - The schema under the Database where the input tables are to be loaded from (same as the one from Step 1 but should not be prefixed with the Database name).

Click on the Done button to save your new Snowflake connector.

Step 3 (Optional): Grant a user role the permission to access new tables and views created in the database/schema used by the Kumo app

-- Use ACCOUNTADMIN or a role with proper privileges
USE ROLE ACCOUNTADMIN; -- or SECURITYADMIN with proper grants
-- Create database role
CREATE DATABASE ROLE if not exists <YOUR_DB>.kumo_db_role;
-- Grant database and schema usage
GRANT USAGE ON DATABASE <YOUR_DB> TO DATABASE ROLE <YOUR_DB>.kumo_db_role;
GRANT USAGE ON SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO DATABASE ROLE <YOUR_DB>.kumo_db_role;
-- Grant privileges on existing tables
GRANT SELECT ON ALL TABLES IN DATABASE <YOUR_DB> TO DATABASE ROLE <YOUR_DB>.kumo_db_role;
-- Grant future privileges (choose either database OR schema level)
GRANT SELECT ON FUTURE TABLES IN DATABASE <YOUR_DB> TO DATABASE ROLE <YOUR_DB>.kumo_db_role;
-- Schema level if needed 
-- GRANT ALL ON FUTURE TABLES IN SCHEMA <YOUR_DB>.<YOUR_SCHEMA> TO DATABASE ROLE <YOUR_DB>.kumo_db_role;
-- Grant the database role to the application
GRANT DATABASE ROLE <YOUR_DB>.kumo_db_role TO APPLICATION <YOUR_KUMO_APP>;

Snowflake Data Warehouse Sizing

Kumo recommends the following data warehousing sizes for the Snowflake Native app based on the size of your largest table.