Unable to connect Redshift

Hi Anonymous ,

It is a known defect with Redshift connector if password contains any of the following special characters:
@
%
}
{
+
;
<space>

As a workaround, remove the above mentioned special characters from the password to make this work.

This issue is addressed in 10.3 HF-012, 10.8 and on wards. It will connect to Redshift if the password contains any of these characters: [ % , { , } ,+ , ; ,<space>].

Note that @ character cannot be used due to limitations in Redshift.

Some exceptions have already been mentioned in the Redshift documentation. Following is the extract from the same:

"It can be any printable ASCII character (ASCII code 33 to 126) except ' (single quotation mark), " (double quotation mark), \, /, @, or space".

For more details, please refer to:

Quotas and limits in Amazon Redshift - Amazon Redshift 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.