Executes SQL commands from STDIN in a single transaction
Project description
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", "arn:aws:redshift:us-west-2:123456789012:dbname:examplecluster/dev_database" ] } }
Usage
python -m redshiftsql host dbname user file --password password --port port
OR
python -m redshiftsql host dbname user file --aws-access-key-id aws-access-key-id --aws-secret-key aws-secret-key --cluster-name cluster-name --port port
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
- region The region that the Redshift cluster is in. Defaults to us-east-1
- file The file to read the SQL commands from
- 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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
redshiftsql-0.0.7.tar.gz
(4.0 kB
view hashes)
Built Distribution
Close
Hashes for redshiftsql-0.0.7-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 83a29ed0fa71da9d6c54c1199687440b6a5b57cfe2646e7587d98b64997d47c1 |
|
MD5 | d5d883a4d8b31c4ec0d6ff0543d4f9a6 |
|
BLAKE2-256 | 9066999d0edd5495059b0549ca31649c2cac17eb2191d7b7489291ce2b69a0c6 |