Authenticate your Snowflake Instance

How to successfully create a service account for HockeyStack and allow it permission to export data to your table.

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;

1. Enable Table Creation priviledges

• This allows our service account to create the table you specified while configuring the export:

GRANT CREATE TABLE ON SCHEMA your_schema 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 export data to

Configure an account limit with Resource Monitors (optional)

Larger imports (>100k rows) may 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
• Caveat: We currently do not change export behavior based on quotas, therefore an export will fail if quotas are too restrictive.

After authenticating, navigate to DataSync in the settings:

Set up the Export