Import from Snowflake

1. Create a Snowflake User for DataSyncs

• Run the following SQL in Snowflake:

CREATE USER datasyncs_user PASSWORD = 'your_secure_password'
DEFAULT_ROLE = 'HOCKEYSTACK_DATASYNCS_ROLE'
MUST_CHANGE_PASSWORD = FALSE;

1. Assign a Role and Permissions

• Create a role for DataSyncs:

CREATE ROLE HOCKEYSTACK_DATASYNCS_ROLE;
GRANT USAGE ON DATABASE your_database TO ROLE DATASYNCS_ROLE;
GRANT USAGE ON SCHEMA your_database.your_schema TO ROLE HOCKEYSTACK_DATASYNCS_ROLE;
GRANT SELECT ON ALL TABLES IN SCHEMA your_database.your_schema TO ROLE HOCKEYSTACK_DATASYNCS_ROLE;

• Assign the role to the user:

GRANT ROLE HOCKEYSTACK_DATASYNCS_ROLE TO USER hockeystack_datasyncs_user;

1. Enable Query Execution

• Grant the ability to create and run queries:

GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE HOCKEYSTACK_DATASYNCS_ROLE;

Gather Connection Information for DataSyncs

• Account Identifier (e.g., account-identifier) (does not include the .snowflakecomputing.com part)

• User: hockeystack_datasyncs_user

• Password: Secure password

• Role: DATASYNCS_ROLE

• Warehouse: your_warehouse

• Database: your_database

• Schema: your_schema

• Table: the specific table that you are looking to import data from

Configure an account limit with Resource Monitors (optional)

Larger imports (>100k rows) can increase compute costs. Setting a quota can help ensure no unexpected compute costs:

• Refer to Snowflake's Resource Monitors documentation to see which options are available to as limits you can set on the service account you are providing to DataSyncs