Execute COPY command on Redshift database from a Linux server outside AWS cluster

1k views Asked by At

I want to load data into Redshift database from amazon S3 using 'COPY' command.But I want to execute it from a shell/perl script present in a Linux machine present outside AWS cluster.I wanted to know if there is any Redshift client that can be installed in the Linux machine available to help me achieve this similar to the SnowSQL client for SnowFlake?

1

There are 1 answers

5
Rahul Gupta On BEST ANSWER

Are you looking for this.
psql- a terminal-based front end from PostgreSQL

You just have to connect to your redshift cluster with the connection configuration and then you can execute any query on the cluster.

PS - The file to be copied/Unload always has to be on s3.
If I’ve made a bad assumption please comment and I’ll refocus my answer.