Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application. It provides wide set of data visualizations to slice & dice your data.

Server Details of Intelehealth Apache Superset installation:

• Server: 13.233.116.180

• Port: 8088

• Username: ubuntu

• To start the superset server run the following shell script in path ‘/home/Ubuntu’:

• To stop the superset server run the following command in path ‘/home/ubuntu’:

How to install Apache Superset on the server?

Following steps should be followed to install the Apache Superset on the server:

Step 1:

Superset is Python-based but it has deprecated support for Python 2.* and supports only >= 3.6. Therefore, your system should have Python >=3.6 installed.

Steps to Install Python:

1. Run Command - sudo add-apt-repository ppa:jonathonf/python-3.6

2. Then check updates and install Python 3.6 via commands:

3. To make python3 use the new installed python 3.6 instead of the default 3.5 release, run following 2 commands:

4. Finally switch between the two python versions for python3 via command:

5. After selecting version 3.6:

6. To overcome the issue of ‘gdbm’ run the following command

Step 2

Superset stores database connection information in its metadata database. For that reason, it becomes necessary to encrypt connection passwords. We use the cryptography Python library to ensure that all sensitive database information gets encrypted. Using the pip package manager, install cryptography using following command:

pip install cryptography

Step 3

We need virtual environment to organize our projects in an isolated manner. Create a directory on server where you wish to install Superset & then install a virtual environment in that directory to run your superset:

(Thus, my_viz is our virtual environment where we will complete our superset installation)

Step 4

The next step is to activate the virtual environment using following command:

Step 5

This is an optional step, but we will execute it to upgrade the setup tools using command:

Step 6

To install and configure Superset, run the following command in the same directory:

While executing the above command, in case we encounter geohash issue due to non-availability of python.h then run following commands to resolve the same:

To overcome the issue of sasl.h does not exists issue, run the following command:

Now, again try to run the command ‘my_viz/bin/pip3.6 install superset’ again to complete the installation.

In case, Pandas compatibility & sqlalchemy compatibility issues are encountered, run following commands:

# Fix pandas version compatibility problem

# Fix sqlalchemy compatibility problem

Now, run the command ‘my_viz/bin/pip3.6 install superset’ again to complete the installation.

Step 7

# Initialize the database using following command:

Step 8

Next step is to create and setup an admin user. This is necessary for completing the authentication setup. Upon running the below command, we would be prompted to enter username, first name, last name, email and password:

i. pip install flask==1.0.0

ii. pip install Flask-JWT-Extended==3.20.0

iii. pip install flask==0.12.2

iv. $ export FLASK_APP=superset

v. flask fab create-admin

The above command will request the user to key in information for:

Username [admin] : admin

User First Name: Priya

User Last Name: Joshi

Email: priya@intelehealth.io

Password: XXXX

Repeat for Confirmation: XXXX

On entering the above data successfully, you will receive following messages:

Recognized Database Authentications.

Admin User admin created.

Step 9

Load sample data in the superset to play with using below command:

Step 10

Create default roles and permissions

Step 11

To start the web server on 8088 port to initialize Apache Superset on browser

Step 12

Open your web browser and type in http://13.233.116.180:8088/ to run the superset interface.