RVR-RS-403

1. Issue Summary

   • The error code "RVR-RS-403" indicates a "Rivery Redshift User Error." This type of error typically occurs due to permission issues or incorrect configurations within the Redshift environment when trying to connect or execute operations from Rivery. It's important first to verify user permissions and ensure all prerequisites for the Redshift connection are correctly set up.

2. Action Steps:

   • Verify User Permissions:
     • Ensure the Redshift user associated with the Rivery connection has the correct permissions, such as SELECT, INSERT, UPDATE, DELETE, and other necessary actions on the target schema and tables【4:4†source】.
   • Check Redshift Connection Settings:
     • Make sure the Redshift cluster is accessible and the host, port, and database name settings are accurate in the Rivery connection configuration.
   • Whitelist IP Addresses:
     • Ensure that Rivery's IP addresses are whitelisted in the Redshift cluster's security group settings to prevent connectivity issues. This can be managed through the AWS Management Console under the VPC security group settings【4:10†source】.
   • Test the Connection:
     • Use the test connection feature in Rivery to confirm that the connection to the Redshift cluster is stable and properly established.

3. External References:

   • For more details on setting up user permissions and configuration on Redshift, refer to the Amazon Redshift documentation.
   • Check Rivery's official documentation for additional guidance on Redshift connections and error handling.

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