RVR-SF-RDBMS-316

1. Issue Summary

   • Error Code: RVR-SF-RDBMS-316
   • Data Connector: RDBMS
   • Error Description: This error indicates a failure in fetching available warehouses in a Rivery River setup. It may be related to incorrect configurations, permissions, or connectivity issues between Rivery and the data warehouse service (e.g., Snowflake, Databricks, etc.).

2. Action Steps:

   • Check Connection Settings: Verify that the connection settings to the warehouse are correctly set up in Rivery. This includes ensuring the correct server address, ports, and credentials are in use.
   • Verify Warehouse Permissions: Ensure that the credentials used in the data connector have adequate permissions to access the warehouse resources. You might need roles that allow viewing or interacting with warehouses.
   • Whitelist Rivery IPs: If access is restricted by IP, ensure that Rivery's IPs are whitelisted in your warehouse's network configuration. For specific guides on whitelisting, refer to the relevant Rivery documentation.
   • Consult Logs and Error Messages: Check any available logs or error messages returned by Rivery or your data warehouse service, as these may provide additional context or specific error descriptions related to connectivity or permissions.
   • Reinitialize or Reset Connections: Sometimes reinitializing the connection or resetting the Rivery river that connects to the warehouse can resolve transient issues.

3. External References:

   • For more detailed configuration and setup instructions, refer to Rivery's official documentation on connections and ensure your warehouse setup aligns with the recommendations.
   • Check the specific data warehouse provider's documentation (e.g., Snowflake, Databricks) for any additional required settings or troubleshooting tips.

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