How to Deploy Data Visualization using Redash on the Cloud

Free and simple DataViz Tool

Data visualization is a very important step to better understand the data and monitor a company’s activity.

Redash is a very powerful Data Viz tool to connect to any data source (PostgreSQL, MySQL, Redshift, BigQuery, MongoDB, Databricks, and many others), query, visualize and share your data to make your company data-driven — Redash.

It is the official DataViz tool integrated inside Databricks, the unified platform for data science, data engineering, data analyst, ML engineer

Running Redash for the first time may require some experience, depending on where you would like to deploy it.

In this beginner-friendly article, I will cover step-by-step how two deploy it on AWS Cloud.

Supported Data Source:

• Amazon Athena,
• Amazon CloudWatch
• Amazon Redshift
• Axibase Time Series Database
• BigQuery
• CSV Files
• CSV Files (Deprecated)
• Databricks
• DynamoDB
• Elasticsearch
• Google Analytics
• Google Sheets
• JIRA
• JSON API’s
• Microsoft Azure SQL Database & Synapse
• MongoDB
• Python

5 Simple Steps

Using Redash is very simple, here are the 5 steps in order to achieve a stunning result for DataViz

• Add a data source
• Write a query
• Add a visualization
• Create a Dashboard
• Invite colleagues

More details can be found here.

Redash uses technologies such as postgres , Redis and NGIX.

Setup Redash on the AWS Cloud

Create an EC2 instance