This tool uses dbt for managing database credentials. It assumes you want to connect to a Redshift instance through a bastion server (specified in your ~/.ssh/config
file).
Create a file called prod.yml
in the config/
directory with the desired dbt profile and cron settings. Then, run:
$ python schedule.py
to install the new CronTab. If your cron config changes, just run the above command again to delete existing cron jobs and install the new ones. Only cron jobs containing the comment "autovacuum scheduler" will be deleted!
Use at your own risk!