Getting Started With Superset: Airbnb’s data exploration platform

getting-started-with-superset-airbnb-data-exploration-platform.md

Getting Started With Superset: Airbnb’s data exploration platform

Update Python and PIP versions on EC2 (Amazon AMI)

At the time of writing, Python v3.5 and PIP v9.0.1 were available on AWS EC2.

sudo yum update -y
sudo yum install python35 -y

Adjust PATH

Add below lines to ~/.bashrc

export PATH=/usr/local/bin:$PATH
alias python=python35

source ~/.bashrc

Update PIP & other OS dependencies for Superset

sudo yum install python35-pip  -y
sudo /usr/bin/pip-3.5 install --upgrade setuptools pip
sudo yum upgrade python-setuptools -y
sudo yum install gcc gcc-c++ libffi-devel python-devel python-pip python-wheel openssl-devel libsasl2-devel openldap-devel -y
sudo yum install python35-devel -y

sudo cp /usr/local/bin/pip /usr/sbin/

Validate Python and PIP

Check Python and PIP

$ python -V
Python 3.5.1

$ pip -V
pip 9.0.1 from /usr/local/lib/python3.5/site-packages (python 3.5)

Setup Superset

Install superset

sudo pip install superset

Create an admin user (you will be prompted to set username, first and last name before setting a password)

fabmanager create-admin --app superset

Initialize the database

superset db upgrade

Load some data to play with

superset load_examples

Create default roles and permissions

superset init

Start the web server on port 8088, use -p to bind to another port

superset runserver -p 8080

Adjust security group to allow http port

http://<EC2 Public DNS>:8080/

References:

• https://github.com/ApacheInfra/superset/blob/master/docs/installation.rst
• https://stackoverflow.com/questions/34103119/upgrade-pip-in-amazon-linux

This worked for me! The port is either 8080 or 8088, but not both.

If you have an issue with fabmanager, try this fix.
apache/superset#6770 (comment)

If you have an issue with superset db upgrade, try this fix
apache/superset#7354 (comment)