Boomi · Data Integration: Snowflake
RVR-SNF-001: Snowflake connection problem
Short answer
RVR-SNF-001 means Data Integration could not connect to Snowflake, usually because of wrong connection details or credentials without enough privileges. Verify the account, username, warehouse and role.
VerifiedLast verified
01Error text
Snowflake connection problem. Please check the connection details or your credentials in Snowflake. Error Code: RVR-SNF-00102Likely causes
- Incorrect connection details.
- Insufficient permissions on the credentials.
03How to fix it
- Confirm the connection name, username, account name and warehouse.
- With Basic or Key-Pair authentication, confirm the credentials can access the database, schema and warehouse the Data Flows use.
- Confirm the Snowflake role has adequate privileges, such as
USAGEorOWNERSHIP. - If Snowflake restricts access by IP, allowlist the Data Integration IP addresses in the account's network policy.
- Use Test Connection on the connection in Data Integration.
04Official documentation
→Related errors
- RVR-SNF-002: Snowflake connection failureRVR-SNF-002 is a failure to connect to Snowflake from wrong credentials, missing permissions or account settings. Check the username and password first, including for unsupported characters in the password.
- RVR-SNFLGC-400: Snowflake process is missing valuesRVR-SNFLGC-400 means the Snowflake process lacks values it needs to continue. Check the Data Flow's required fields and column mapping, and look for nulls in key fields.
- RVR-IPAL-001: IP address allowlist check failedRVR-IPAL-001 means the connecting IP addresses are not in the allowlist of the service you are connecting to. Add the Data Integration IP addresses to that service's inbound rules.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Boomi work:Open Boomi jobsBoomi rates and salaries