CODEWITHSUNDEEP
perlamazon-web-servicesamazon-redshiftamazon-redshift-spectrum
indranil
indranil

Reputation: 83

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

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?

Upvotes: 0

Views: 1037

Answers (1)

Rahul Gupta
Rahul Gupta

Reputation: 1802

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.

Upvotes: 1

Related Questions