Error 1006 - Invalid database hostname

Last updated on Oct 26, 2022

Hevo is unable to establish connection to the database using the credentials provided by the user.

Verify that the hostname entered in the Configure your Amazon Redshift Destination page is correct.
To do this:
1. Log in to the AWS Console.
2. In the global search bar, enter Redshift.
3. In the left navigation pane, click on Provisioned clusters dashboard.
4. In the Provisioned clusters dashboard, under the Cluster overview section, select the cluster that you are using for configuring the Redshift Destination in Hevo.
5. In the Configuration tab, under the Cluster Database Properties section, locate and verify the Port and JDBC URL. The default Amazon Redshift port is 5439. In case you want to change or correct the values, you can do it in the Configure your Amazon Redshift Destination page.
  
  Note: For URL-based hostnames, exclude the jdbc:redshift:// part. For example, if the hostname URL is jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev, enter examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com in the Database Host field in Hevo.
Use the Connect via SSH option in the Configure your Amazon Redshift Destination page to set up the Destination if the Redshift instance is on a local IP address.
Invite another team member with the required privileges to set up the Pipeline. Read Inviting and Moderating Team Members.

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Sep-21-2022	NA	New document.

Error Code	1006
Error Message Text(s)	- ‘{hostname}’ is an invalid Redshift database hostname. The hostname must be a DNS hostname or an IP address accessible over the internet. In case the database cannot be made accessible over the internet, consider enabling an SSH tunnel.