I had faced the same problem earlier. You can use R or Python for that.
You need to install package RpostgreSQL and connect to your Redshift:
drv <- dbDriver("PostgreSQL")
and then you can build report with markdown and then scheduled it with crontab task. Also if it helps I have used the mailR package to send the report to other users