Boomi · Data Integration: Snowflake
RVR-SNF-002: Snowflake connection failure
Short answer
RVR-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.
VerifiedLast verified
01Error text
Error Code: RVR-SNF-00202Likely causes
- Incorrect credentials, inadequate permissions or misconfigured account settings.
03How to fix it
- Confirm the username and password. The password should not contain
{,},",\,?,/,#or*. - Confirm access to the database, schema and warehouse.
- Confirm the account name and warehouse in the connection.
- Allowlist Data Integration IP addresses in the Snowflake network policy if access is restricted.
- Use Test Connection on the connection in Data Integration.
04Official documentation
→Related errors
- RVR-SNF-001: Snowflake connection problemRVR-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.
- 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.
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