re:dash client over Redshift
Access it here.
To deploy, launch an EC2 instance from AMI `redash-20151001`. Once launched add the instance to the Redshift security group and the redash load balancer.
To manage users, `ssh` to the host, `cd /opt/redash/current`, and then `sudo -u redash bin/run ./manage.py users`.
Here are steps to create the AMI:
- Base AMI: Ubuntu 14.04 LTS HVM 64-bit
- The user is "ubuntu"
- Remember to open HTTP 80 for testing
- Connect to the instance
- `sudo apt-get update`
- `sudo apt-get -y -q dist-upgrade`
- `sudo apt-get -y -q autoremove`
- `sudo apt-get -y -q autoclean`
- Run the bootstrap script
- Test that the website is up and running
- Edit `/opt/redash/.env` and change the cookie secret
- Go to `/opt/redash/current` and change the admin password `sudo -u redash bin/run ./manage.py users password admin <new password>`
- Set up Google OAuth in `/opt/redash/.env`. The credentials are also backed up in belltown
- Restart redash `sudo supervisorctl restart redash_server`
- Set up a load balancer behind Route53. Make sure the health check is on `/login` which the redash server returns 200
- Connect to Redshift. Note Redshift is in a different AWS account in on VPC. Must add the instance's IP to the Redshift's security group. Test the connection using `telnet`
- Configure the data source for Redshift by logging in as `admin` and browsing to `/data_source`