4.8. Database Exploration¶

4.8.1. Rationale¶

Apache Superset

4.8.2. Install¶

Install superset
$ pip install superset

Create an admin user

$ 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
To start a development web server on port 8088, use -p to bind to another port
$ superset runserver -d

4.8.3. Configuration¶

superset_config.py

ROW_LIMIT = 5000
SUPERSET_WEBSERVER_PORT = 8088

# Change this for your setup
SECRET_KEY = '\2\1myscretkey\1\2\e\y\y\h'

# Superset configuration database only
# Datasources are managed in the web UI
SQLALCHEMY_DATABASE_URI = 'sqlite:////path/to/superset.db'

# Flask CSRF protection
WTF_CSRF_ENABLED = True
WTF_CSRF_EXEMPT_LIST = []
WTF_CSRF_TIME_LIMIT = 60 * 60 * 24 * 365

# Set this API key to enable Mapbox visualizations
MAPBOX_API_KEY = ''

4.8.4. Production setup¶

$ gunicorn \
    -w 10 \
    -k gevent \
    --timeout 120 \
    -b  0.0.0.0:6666 \
    --limit-request-line 0 \
    --limit-request-field_size 0 \
    --statsd-host localhost:8125 \
    superset:app