Redash on Heroku

Dockerfiles for hosting redash on heroku

How to create

git clone git@github.com:willnet/redash-on-heroku.git
cd redash-on-heroku
heroku create --stack=container your_app_name

How to setup

Add Addons

Add following addons on heroku dashboard.

• heroku postgres
• Redis Cloud(or something)
• sendgrid (or something)

Choose redis addon allow more than or equal 30 connections. Otherwise you will get connection errors frequently.

Add environment variables

Add environment variables like following.

heroku config:set PYTHONUNBUFFERED=0
heroku config:set QUEUES=queries,scheduled_queries,celery
heroku config:set REDASH_COOKIE_SECRET=YOUR_SECRET_TOKEN
heroku config:set REDASH_SECRET_KEY=YOUR_SECRET_KEY
heroku config:set REDASH_DATABASE_URL=YOUR_POSTGRES_URL
heroku config:set REDASH_LOG_LEVEL=INFO
heroku config:set REDASH_REDIS_URL=YOUR_REDIS_URL
heroku config:set REDASH_HOST=YOUR_DOMAIN_URL
heroku config:set REDASH_MAIL_PASSWORD=YOUR_ADDON_PASSWORD
heroku config:set REDASH_MAIL_PORT=587
heroku config:set REDASH_MAIL_SERVER=YOUR_ADDON_DOMAIN
heroku config:set REDASH_MAIL_USERNAME=YOUR_ADDON_USERNAME
heroku config:set REDASH_MAIL_USE_TLS=true
heroku config:set REDASH_MAIL_DEFAULT_SENDER=YOUR_MAIL_ADDRESS

• Test : Add ?ssl_cert_reqs=CERT_NONE to REDASH_REDIS_URL

See also https://redash.io/help/open-source/setup#-setup

Release container

git push heroku master

Create database

After deploy and add postgres addon, create database like following.

heroku run /app/manage.py database create_tables

Enable worker dyno

heroku ps:scale worker=1

How to upgrade

heroku ps:scale web=0 worker=0
git push heroku master
heroku run /app/manage.py db upgrade
heroku ps:scale web=1 worker=1

See also https://redash.io/help/open-source/admin-guide/how-to-upgrade