skip to navigation
skip to content

redshiftsql 0.0.1

Executes SQL commands from STDIN in a single transaction

Latest Version: 0.0.7

This tool accepts either a Redshift username and password OR an AWS Access Key ID and Secret Key.

If you use the IAM Access/Secret method, the user that you are referencing MUST have the correct policy to get temporary credentials from the database. For example:

  "Version": "2012-10-17",
  "Statement": {
    "Effect": "Allow",
    "Action": "redshift:GetClusterCredentials",
    "Resource": "arn:aws:redshift:us-west-2:123456789012:dbuser:examplecluster/temp_creds_user"


python -m redshiftsql –password –port –file


python -m redshiftsql –aws-access-key-id –aws-secret-key –cluster-name –port –file


  • host The Redshift endpoint, minus the port
  • dbname The Redshift database to connect to
  • user The Redshift user
  • password The Redshift password. Ignored if aws-access-key-id is present
  • port The port on the host. Defaults to 5439
  • file The file to read the SQL commands from. If not present, the commands will be read from stdin
  • aws-access-key-id The AWS Access Key ID for the IAM user to obtain temporary credentials
  • aws-secret-key The AWS Secret Key for the IAM user to obtain temporary credentials
  • cluster-name The Redshift cluster name to obtain temporary credentials from
File Type Py Version Uploaded on Size
redshiftsql-0.0.1-py2.py3-none-any.whl (md5) Python Wheel py2.py3 2018-03-14 5KB
redshiftsql-0.0.1.tar.gz (md5) Source 2018-03-14 3KB