Skip to content

Superset Basics

homepage-banner

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 or miniconda 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
Leave a message