This blog post is about How to setup Redash on Docker.
Redash is a tool which separates the Data Fetching logic from the Visualization Step. It lets you directly feed Queries for different Data Sources, such as MongoDB, ElasticSearch, Amazon RDS, MySQL, Google BigQuery, amongst others.
All these queries can be mapped against predefined Visualizations, such as graph, bar charts, box plots etc. These, visualizations can then used to create Dashboards. So, as you must have figured out, different data, from different data sources, can be added in one Dashboard. How about that!
Redash provides an on-premise solution, which you can download and set it on your own servers, or a paid subscription where all you need to worry about is your queries and Data Sources.
More can be found at Redash.
Redash provides setup guidelines for all leading cloud hosting services, such as Amazon Web Services (AWS) and Google Cloud. The installation is fairly straight-forward, and can be found at :-
On-Premise Setup for Amazon Web Services and Google Cloud.
In this post, I will explain how to setup Redash on Docker. Steps are as follows :-
STEP I : Install Docker
Docker installation is fairly straight-forward for all Operating Systems, and can be found online easily. This blog post deals with Mac OS X and Linux Operating System Flavours.
STEP II : Configure Setup
We will use an Ubuntu Image as a base image for this installation. I have added codes for two files. Download them for usage, or you can make your own 😉
Entry Point : supervisor.sh
This script will act as an Entry Point. An Entry Point is a script which is run every time a docker instance boots up. Docker needs a process to keep running in order for the instance to keep running. Thus, the last statement we put is a tail command.
DockerFile : docker-redash
This uses a base Ubuntu image, adds up all required packages, downloads the Redash Script, and executes and sets up everything you need. It is pretty self explanatory.
STEP III : Execute commands for final setup
This will take sometime to run, but should run without any hassles.
Once this executes completely, you should get a ready Docker Image. Execute the following command to boot your instance :-
Now, go to http://127.0.0.1:9876 and enjoy! 😉
Please post comments in case you find problems, and I will try and help you out!