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.

Piyush Sonigra · Accepted Answer · 2021-01-05 10:16:47Z

7

You can use Redshift Data API to execute queries on Redshift using AWS CLI.

aws redshift-data execute-statement 
    --region us-west-2 
    --secret arn:aws:secretsmanager:us-west-2:123456789012:secret:myuser-secret-hKgPWn 
    --cluster-identifier mycluster-test 
    --sql "select * from stl_query limit 1" 
    --database dev

https://aws.amazon.com/about-aws/whats-new/2020/09/announcing-data-api-for-amazon-redshift/ https://docs.aws.amazon.com/redshift/latest/mgmt/data-api.html https://docs.aws.amazon.com/cli/latest/reference/redshift-data/index.html#cli-aws-redshift-data

answered Jan 5, 2021 at 10:16

Piyush Sonigra

1,65814 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pandelis · Accepted Answer · 2018-01-31 14:13:29Z

6

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

answered Jan 31, 2018 at 14:13

Pandelis

1,99714 silver badges20 bronze badges

2 Comments

Sai Bhasker Raju Over a year ago

I am already using psql @pandelis but i am facing issues regarding "client_encoding" . I thought of asking it on a different thread and learn if there is anything which can be done from CLI or Powershell Cmdlets

John Rotenstein Over a year ago

Since this answer was written, Amazon Redshift has added the Redshift Data API. See the other answer for an example.

Collectives™ on Stack Overflow

How to run Queries on Redshift Database using AWS CLI

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related