Superset 落地過程筆記

Superset local 安裝過程

superet是個強大且免費的BI工具。

安裝環境：

確保安裝 python, wheel

http://go.microsoft.com/fwlink/?LinkId=691126&fixForIE=.exe.

安裝的過程如下： 

cd\superset

virtualenv env

env\Scripts\activate

(env) C:\superset>pip install apache-superset

(env) C:\superset>set FLASK_APP=superset

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset fab create-admin

安裝 windows版 MySQL

從 MySQL內 建立 superset_db  資料庫

改config.py的 mysql設定

# SQLALCHEMY_DATABASE_URI = "sqlite:///" +  os.path.join(DATA_DIR, "superset.db")

SQLALCHEMY_DATABASE_URI='mysql://root:900098@localhost:3306/superset_db?charset=UTF8'

(env) C:\superset\env\Lib\site-packages\superset\bin>pip install Pillow

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset db upgrade

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset load_examples

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset init

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset run -p 8088 --with-threads --reload --debugger

設定帳號密碼。 要打 admin

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset fab create-admin

取得 MapBox key 填在 config.py

改密碼

(env) C:\superset\env\Lib\site-packages\superset\bin>python superset fab reset-password --username admin --password xxxxx

SQL server 連結修正

It should be located in the file ~ C:\python\venv\Lib\site-packages\superset\utils\core.py

Comment Try in the below method and add pass: def enter(self): def exit(self, type, value, traceback):

SQL連結：mssql+pymssql://name:password@db_host:1433/db_name