Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Step 4: Add the Amazon Redshift Cluster Public Key to Each Amazon EC2 Host's Authorized Keys File

You add the cluster public key to each host's authorized keys file for all of the Amazon EMR cluster nodes so that the hosts will recognize Amazon Redshift and accept the SSH connection.

To add the Amazon Redshift cluster public key to the host's authorized keys file

  1. Access the host using an SSH connection.

    For information about connecting to an instance using SSH, see Connect to Your Instance in the Amazon EC2 User Guide.

  2. Copy the Amazon Redshift public key from the console or from the CLI response text.

  3. Copy and paste the contents of the public key into the /home/<ssh_username>/.ssh/authorized_keys file on the host. Include the complete string, including the prefix "ssh-rsa " and suffix "Amazon-Redshift". For example:

    ssh-rsa AAAACTP3isxgGzVWoIWpbVvRCOzYdVifMrh… uA70BnMHCaMiRdmvsDOedZDOedZ Amazon-Redshift