RVR-RS-403

1. Issue Summary

   • The error Rivery Redshift User ErrorError Code: RVR-RS-403 encountered with the Redshift data connector generally indicates a permissions or configuration issue related to the user or session trying to access Redshift via Rivery. This may be due to incorrect user permissions, network access issues, or a misconfiguration in the Redshift connection setup.

2. Action Steps:

   • Verify User Permissions: Ensure that the Rivery user has the correct permissions in Redshift. Check if the user has access to the necessary schemas, tables, and functions. You can do this by running relevant SQL commands in your SQL management tool connected to Redshift.
   • Review AWS Security Groups: Make sure that your Redshift cluster's security group settings allow inbound traffic from the IP addresses used by Rivery. This can often be a cause if IPs haven't been whitelisted.
   • Test Redshift Connection: Use the "Test Connection" option in the Rivery platform to ensure your connection credentials and network configurations are correctly set up. Ensure the host, port, username, and password are all correct.
   • Check Network Access: Ensure your Redshift cluster is accessible from outside your VPC if it is supposed to be publicly accessible. Review your cluster and network setup in AWS to confirm this.
   • Consult Rivery Support: If these steps do not resolve the issue, consider reaching out to Rivery support to get more detailed assistance specific to your account and system configuration.

3. External References:

   • For more guidance on user permissions and security settings in Amazon Redshift, refer to the official AWS documentation: Amazon Redshift Permissions.
   • For more information on setting up and troubleshooting Amazon Redshift connections in Rivery, you may refer to the official Rivery documentation: Rivery Redshift Connection.

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