Superset Basics
Introduction
Recently, the Apache Software Foundation announced that Apache Superset was promoted to an ASF top-level project. At the same time, Apache Superset also ushered in a major milestone version 1.0.
The main features are as follows:
- Rich data visualization set
- Easy-to-use interface for browsing and visualizing data
- Create and share dashboards
- Enterprise-ready authentication with major identity providers (databases, OpenID, LDAP, OAuth, and REMOTE_USER integrated with Flask AppBuilder)
- Scalable, fine-grained security/permission model allowing complex rules about who can access individual elements and datasets
- A simple semantic layer that allows users to control how data sources are displayed in the UI by defining which fields should appear in which dropdowns and which aggregates and functional metrics are available for users to use
- Integration with most SQL-speaking RDBMS through SQLAlchemy
- Deep integration with
http://druid.io/
Installation
Refer to Installing Superset from Scratch, it is recommended to install using pip
1. Prepare the pyenv environment
- Recommended
virtualenv
orminiconda
distribution
2. Install apache-superset
pip install apache-superset
3. Initialize the database
superset db upgrade
4. Create a user
# Create an admin user (you will be prompted to set a username, first and last name before setting a password)
$ export FLASK_APP=superset
superset fab create-admin
# Load some data to play with
superset load_examples
# Create default roles and permissions
superset init
5. Start
# To start a development web server on port 8088, use -p to bind to another port
superset run -p 8088 --with-threads --reload --debugger
The backend is Flask, which listens to 127.0.0.1 by default. If you want to listen to 0.0.0.0, add the -h 0.0.0.0 parameter
superset run -h 0.0.0.0 -p 8088 --with-threads --reload --debugger
Reference
https://github.com/apache/superset
https://superset.apache.org/
- Supported data source list:
https://superset.apache.org/docs/databases/installing-database-drivers