Superset安装使用

安装

安装apache-superset

pip install apache-superset
复制代码

更新数据库

superset db upgrade
复制代码

创建admin用户

export FLASK_APP=superset
flask fab create-admin
复制代码

下载样例数据

superset load_examples
复制代码

初始化环境

superset init
复制代码

启动Superset

superset run -h 0.0.0.0 -p 5000
复制代码

添加自定义数据库

sqlite3为例

若出现ERROR: (sqlalchemy_uri) SQLiteDialect_pysqlite cannot be used as a data source for security reasons.

则修改superset下的config.py，设置PREVENT_UNSAFE_DB_CONNECTIONS = False，然后重启

$ locate config.py|grep superset
.../python-3.7.2/lib/python3.7/site-packages/superset/config.py
​
$ vi .../python-3.7.2/lib/python3.7/site-packages/superset/config.py
​
# Some sqlalchemy connection strings can open Superset to security risks.
# Typically these should not be allowed.
PREVENT_UNSAFE_DB_CONNECTIONS = False
​
复制代码

\