RVR-SNF-001

Issue summary

• The error "FSnowflake connection problem. Please check the connection details or your credentials in Snowflake. Error Code: RVR-SNF-001" indicates a failure to establish a connection to Snowflake through Data Integration. This is likely due to incorrect connection details or inadequate permissions given to the credentials in use.
• Initial diagnosis points to misconfigured credentials or missing permissions in the Snowflake setup needed to access the relevant resources.

Action steps

To resolve the error, follow these steps:

1. Verify Connection Details:
   • Ensure that the connection name, username, account name, and warehouse details in Data Integration are correctly filled out.
2. Check Credentials:
   • Using either Basic or Key-Pair authentication, confirm that the credentials provided have the necessary permissions to access the database, schema, and warehouse mentioned in your Data Flows.
3. Warehouse Permissions:
   • Make sure the Snowflake role associated with the user has adequate privileges to access the warehouse and database. This might include permissions such as USAGE or OWNERSHIP over the necessary objects.
4. Network Policies:
   • If your Snowflake environment employs network policies for IP address restriction, ensure that Data Integration you have allowlisted the IP addresses in your Snowflake account.
5. Test Connection:
   • Use the Test Connection feature in Data Integration to ensure that your connection configuration can successfully authenticate and interact with Snowflake.

External references

• Data Integration Documentation on Snowflake Connection for details on setting up Snowflake connections.
• Snowflake Official Documentation on Key-Pair Authentication for generating keys and setup.

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.