Public Repository

Last pushed: 6 months ago
Short Description
Easily run Redshift VACUUM and ANALYZE commands and email the output.
Full Description

The VACUUM and ANALYZE logic itself is based on https://github.com/awslabs/amazon-redshift-utils

To run, use:

docker run --rm \
    -e DB_NAME=your_db_name \
    -e DB_USER=your_db_user \
    -e DB_PWD=your_db_pass \
    -e DB_HOST=your.redshift.cluster \
    -e SEND_EMAIL=True  \
    -e EMAIL_HOST=smtp.gmail.com \
    -e EMAIL_PORT=587 \
    -e EMAIL_SENDER=email@domain.com \
    -e EMAIL_PWD=senderpassword \
    -e EMAIL_RECIPIENT=recipient@domain.com \
    [-e DB_SCHEMA=your_schema ] \
    alooma/vacuum-analyze-redshift

See https://alooma.com/blog/vacuum-analyze for more details

Docker Pull Command
Owner
alooma