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
4.8.5. Dashboard¶

4.8.6. Data exploration¶

4.8.7. SQL IDE¶

4.8.8. GIS and spatial data¶
