[[Snowflake Destination — Prerequisites]]
Before setting up Snowflake as a destination in RevSure, the customer should ensure the following are available:
- Snowflake account with a dedicated user for the integration
- Warehouse that RevSure can use
- Database and schema where RevSure data will be written
- Snowflake role granted to that user, with:
- `USAGE` on the warehouse, database, and schema
- `CREATE TABLE` on the target schema
- `SELECT, INSERT, UPDATE, DELETE ` on current and future tables in the schema
- `REFERENCES` on tables in the schema
- Auth ready for the RevSure connection: Snowflake OAuth (Client ID + Client Secret) or RSA key pair
- Network policies or IP allowlists that permit the RevSure connection
Values to have on hand for the RevSure Destination form:
- Account URL (e.g. `https://<account>.snowflakecomputing.com`)
- Warehouse, database, schema, and role names
- OAuth Client ID + Client Secret, or RSA username + private key (and passphrase if the key is encrypted)
Once these are configured, the customer can authenticate with Snowflake from the RevSure Destination setup flow ([[Data Hub → Data Destinations → Snowflake]]), then add workflows for the tables to sync.