Preparing Your Snowflake Account for RevSure Data Destination Integration

What does RevSure need from Snowflake set up before sending data into Snowflake as a destination?

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)