🙋♂️ INFO: If you have fixes/suggestions to for this doc, please comment below.
🌟 STAR: This doc if you found this document helpful.
-
Install Microsoft Visual C++ 14.x standalone: Build Tools for Visual Studio 2019 (x86, x64, ARM, ARM64)
-
Select latest version of MSVCv142 - VS 2019 C++ x64/x86 build tools
-
Select Windows 10 SDK
-
-
Install Python 3.7.x
-
Install PIP within the installer
-
Add Python 3.7 to PATH
-
-
Use CMD to execute below commands (Recommended)
Ideally run these commands sequentially ...
:: Create directory to host the files
mkdir D:\superset
cd /d D:\superset
:: Check Versions
python --version
pip --version
systeminfo | findstr /C:"OS"
:: Upgrade Setuptools & PIP
pip install --upgrade setuptools pip
:: Create Virtual Environment named venv
python -m venv venv
:: Activate Virtual Environment
venv\Scripts\activate
:: Workaround - Install PIP within Virtual Environment
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py --ssl-no-revoke
python get-pip.py
:: Workaround - Upgrade Setuptools & PIP within venv
pip install --upgrade setuptools pip
:: (OUTDATED) Install Superset Requirements - Not required towards end of 2020
:: -- ref: https://gist.github.com/mark05e/d9cccae129dd11a21d7219eddd7d9923#gistcomment-3614048
:: curl https://raw.githubusercontent.com/apache/incubator-superset/master/requirements.txt -o requirements.txt --ssl-no-revoke
:: pip install -r requirements.txt
:: Install Superset
pip install apache-superset
:: (OUTDATED) Workaround - Install specific versions for compatibility (USE WITH CAUTION - ONLY IF NEEDED)
:: pip uninstall pandas
:: pip install pandas==0.23.4
:: pip install Flask==1.0
:: pip install SQLAlchemy==1.2.18
:: Install DB Drivers - Postgres & MS SQL
pip install psycopg2
pip install pymssql
:: Open Scripts folder to do superset related stuff
cd venv\Scripts
:: Create application database
python superset db upgrade
:: Create admin user
set FLASK_APP=superset
flask fab create-admin
:: Load some data to play with (optional)
python superset load_examples
:: Create default roles and permissions
python superset init
:: Start web server on port 8088
python superset run -p 8088 --with-threads --reload --debugger
Click to expand!
This sample can be used as a reference if something does not work correctly or incase of any installation issues.
alembic==1.0.11
amqp==2.5.0
apispec==1.3.3
asn1crypto==0.24.0
attrs==19.1.0
Babel==2.7.0
billiard==3.6.0.0
bleach==3.1.0
boto3==1.4.7
botocore==1.7.48
cchardet==2.1.4
celery==4.3.0
certifi==2019.6.16
cffi==1.12.3
chardet==3.0.4
click==6.7
colorama==0.3.9
contextlib2==0.5.5
cryptography==2.7
defusedxml==0.6.0
docutils==0.15.2
et-xmlfile==1.0.1
Flask==1.0
Flask-AppBuilder==2.1.10
Flask-Babel==0.12.2
Flask-Caching==1.7.2
Flask-Compress==1.4.0
Flask-JWT-Extended==3.21.0
Flask-Login==0.4.1
Flask-Migrate==2.5.2
Flask-OpenID==1.2.5
Flask-SQLAlchemy==2.4.0
Flask-WTF==0.14.2
flower==0.9.3
future==0.16.0
geographiclib==1.49
geopy==1.20.0
gunicorn==19.9.0
humanize==0.5.1
idna==2.8
ijson==2.4
isodate==0.6.0
itsdangerous==1.1.0
jdcal==1.4.1
Jinja2==2.10.1
jmespath==0.9.4
jsonlines==1.2.0
jsonschema==3.0.2
kombu==4.6.3
linear-tsv==1.1.0
Mako==1.1.0
Markdown==3.1.1
MarkupSafe==1.1.1
marshmallow==2.19.5
marshmallow-enum==1.4.1
marshmallow-sqlalchemy==0.17.0
numpy==1.17.0
openpyxl==2.4.11
pandas==0.23.4
parsedatetime==2.4
pathlib2==2.3.4
polyline==1.4.0
prison==0.1.2
psycopg2==2.8.3
pure-sasl==0.6.1
pycparser==2.19
pydruid==0.5.6
PyHive==0.6.1
PyJWT==1.7.1
pymssql==2.1.4
pyrsistent==0.15.4
python-dateutil==2.8.0
python-editor==1.0.4
python-geohash==0.8.5
python3-openid==3.1.0
pytz==2019.2
PyYAML==5.1.2
requests==2.22.0
rfc3986==1.3.2
s3transfer==0.1.13
simplejson==3.16.0
six==1.12.0
SQLAlchemy==1.2.18
SQLAlchemy-Utils==0.34.1
sqlparse==0.3.0
superset==0.28.1
tableschema==1.6.0
tabulator==1.23.0
thrift==0.11.0
thrift-sasl==0.3.0
tornado==5.1.1
unicodecsv==0.14.1
Unidecode==1.1.1
urllib3==1.25.3
vine==1.3.0
webencodings==0.5.1
Werkzeug==0.15.5
WTForms==2.2.1
xlrd==1.2.0
This output can be obtained by running this command against your venv
pip freeze > requirements.txt
-
Direct Link to download Visual Studio Build Tools 2019 (might be broken)
-
Workaround - SQLAlchaemy package downgrade (Ref 1)
-
@philip-sparks suggestion from superset issue #5788
-
@hainv suggestion
-
@ronna update command - ref 1, ref 2
@ubersant - from what you have typed here, I think you are running the
venv
andsuperset db upgrade
command in the wrong directory.If you have prepared the folder
C:\superset
, you should open command prompt into this directory first and then follow the steps in the guide. In your case, it would be