How to connect to Redshift through Linux terminal

Redshift is a data warehouse platform from AWS. Since its built over PostgeSQL, we can use the psql command to connect to Redshift.

Command syntax is as follows.

#psql -h <host> -U <user> -d <database> -p <port>

Where:

<host> is the Redshift cluster endpoint.

<user> is the user name for Redshift cluster.

<database> is the database name.

<port> is the Redshift cluster port.

This command will will prompt for the password.

That's all…