RVR-SNF-002

1. Issue Summary

   • Error Code: RVR-SNF-002 indicates a failure to connect to Snowflake through Rivery. This error typically arises from incorrect credentials, inadequate permissions, or misconfigured account preferences in the Snowflake setup.

2. Action Steps:

   • Verify Credentials: Ensure that the username and password provided are correct. Snowflake passwords should not contain certain special characters such as {, }, "\", "?, /, #, *.
   • Check Permissions: Verify that the user credentials have the necessary permissions — this includes access to the specified database, schema, and warehouse within Snowflake.
   • Confirm Account Information: Make sure that the correct account name and warehouse details are used during connection setup. Snowflake account names should be carefully checked to match the format specified in the setup documentation.
   • Network Policy Configuration: If your Snowflake account is access-restricted by IPs, ensure that Rivery's IPs are whitelisted in your Snowflake's Network Policy.
   • Use the Test Connection Function: After checking and adjusting the above settings, use the Test Connection feature in the Rivery platform to confirm the connection is active.

3. External References:

   • Rivery's Snowflake Connection Configuration for detailed guidance on setting up and troubleshooting Snowflake connections.
   • Snowflake Documentation for any in-depth and technical details regarding user permissions and account configuration.

If the issue persists or you need further assistance, please open a ticket with Rivery support.