redshiftsql
A simple command line batch processing tool for Redshift SQL
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
1 maintainer
Metadata
1 maintainer
Release files for redshiftsql 0.0.7
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| redshiftsql-0.0.7.tar.gz | 4.0 kB | Without provenance | Details for redshiftsql-0.0.7.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| redshiftsql-0.0.7-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details for redshiftsql-0.0.7-py2.py3-none-any.whl |
Total release size: 9.4 kB
Release files / redshiftsql-0.0.7.tar.gz
| Download URL | redshiftsql-0.0.7.tar.gz |
|---|---|
| Size | 4.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
ba8c0f6a8b9d222719172d76714040b3d7ef6c22e3ff3ba5f0c2bf4712ddf51d
|
|
BLAKE2b-256 checksum How to use checksums |
7a40db5c942a00f36c329086d6d6c0b63712b6f0f53e255eea2a90397cd5cafa
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / redshiftsql-0.0.7-py2.py3-none-any.whl
| Download URL | redshiftsql-0.0.7-py2.py3-none-any.whl |
|---|---|
| Size | 5.4 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
83a29ed0fa71da9d6c54c1199687440b6a5b57cfe2646e7587d98b64997d47c1
|
|
BLAKE2b-256 checksum How to use checksums |
9066999d0edd5495059b0549ca31649c2cac17eb2191d7b7489291ce2b69a0c6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for redshiftsql 0.0.7
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
