Skip to main content
Feedback

RVR-RS-403

  1. Issue Summary

    • The error {conKeyRefs.DataIntegration} 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 Data Integration. 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 Data Integration 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 Data Integration. This can often be a cause if IPs haven't been whitelisted.
    • Test Redshift Connection: Use the "Test Connection" option in the Data Integration 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 Data Integration Support: If these steps do not resolve the issue, consider reaching out to Data Integration 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 Data Integration, you may refer to the official Data Integration documentation: Data Integration Redshift Connection.

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