How to run Queries on Redshift Database using AWS CLI

Question

I want to run queries by passing them as string to some supported command of AWS through its CLI.

I can see that the commands specific to AWS Redshift mentioned doesnt have anything which says that it can execute commands remotely

Link : https://docs.aws.amazon.com/cli/latest/reference/redshift/index.html

Need help on this.

Answer 1

You need to use psql. There is no API interface to redshift.

Redshift is based loosely on postgresql however so you can connect to the cluster using the psql command line tool.

https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-from-psql.html