Metadata-Version: 1.1
Name: redshiftsql
Version: 0.0.4
Summary: Executes SQL commands from STDIN in a single transaction
Home-page: https://github.com/QuiNovas/redshiftsql
Author: Joseph Wortmann
Author-email: joseph.wortmann@gmail.com
License: APL 2.0
Description-Content-Type: UNKNOWN
Description: 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*
        -  **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
        
        
Keywords: quinovas
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Topic :: System :: Software Distribution
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Programming Language :: Python :: 2.7
