RVR-SNFS-400

Issue summary

• The error code RVR-SNFS-400 indicates that there are missing authentication credentials for establishing a connection with Snowflake using Data Integration. This typically occurs due to a misconfiguration in the credentials setup required to access Snowflake. In general, incomplete or incorrect credentials such as username, password, warehouse, and account name can lead to this issue.

Action steps

To resolve the error, follow these steps:

• Verify Connection Details: Double-check that the Snowflake connection configuration in Data Integration is complete and accurate. Make sure you have entered the following key details correctly:

  • Username: Your Snowflake account username.
  • Password: The corresponding password for the username.
  • Account Name: This is available in your Snowflake account details and often takes the format your-org-name.eu-central-1.
  • Warehouse: Specify the Snowflake warehouse name to use during Data Integration operations.
  • Role: (Optional) Make sure the role has necessary permissions if specified or ensure the default role can access the designated warehouse.

• Authentication Method: Verify that you are using the correct authentication method:

  • For Basic Authentication, ensure that the password does not contain disallowed special characters.
  • Key-Pair Authentication (if used): Ensure the private key has been correctly generated and is in use as required.

• Test The Connection: Use the Test Connection feature in Data Integration to test the connection and verify if it operates successfully.

• Credentials and Permissions: Ensure that the Snowflake user possesses adequate permissions to access the necessary resources. This includes having the appropriate privileges set for accessing the database, schema, and warehouse.

External references

• For more details, you can visit Data Integration official documentation on connecting to Snowflake: Data Integration Snowflake Connection.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.