redshiftsql 0.0.1

Executes SQL commands from STDIN in a single transaction

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"
  }
}

Usage

python -m redshiftsql –password –port –file

OR

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

Arguments

• 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