Installing Apache Superset on Windows 10

apache-superset-on-windows10.md

Installing Apache Superset on Windows 10

⚠️ WARN: This doc might be outdated. Use with caution. Only tested with Python v3.7

🙋‍♂️ INFO: If you have fixes/suggestions to for this doc, please comment below.

🌟 STAR: This doc if you found this document helpful.

---

Pre-Requisites

1. Install Microsoft Visual C++ 14.x standalone: Build Tools for Visual Studio 2019 (x86, x64, ARM, ARM64)

   1. Select latest version of MSVCv142 - VS 2019 C++ x64/x86 build tools

   2. Select Windows 10 SDK

2. Install Python 3.7.x

   1. Install PIP within the installer

   2. Add Python 3.7 to PATH

3. Use CMD to execute below commands (Recommended)

Installation

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

(OUTDATED) Sample requirements.txt

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

🔎 References

1. Superset Installation Guide

2. Windows Compilers for Python

3. Direct Link to download Visual Studio Build Tools 2019 (might be broken)

4. Stackoverflow - Remove PIP installed packages

5. Workaround - Pandas package downgrade (Ref 1, Ref 2)

6. Workaround - SQLAlchaemy package downgrade (Ref 1)

7. @philip-sparks suggestion from superset issue #5788

8. @hainv suggestion

9. @ronna update command - ref 1, ref 2

---

mark05e / apache-superset-on-windows10.md

Hi @mark05e, can ths work with python 3.9.+ and 3.10.+? There was a point during one of my earlier attempts at installation with 3.10 that I got an error about one of the requirements needing a python version less than 3.9

@primarchsolutions I have not used superset in a while so I am unsure if it works with 3.9 or 3.10. On the installation guide they mention that that they are using 3.8.12 in their docker editions - probably a safe bet to try this version.

• Quote from the installation guide
• Docker Hub Superset Image details

Hi @mark05e I successfully setup superset on a windows server and wanted to migrate it to another server. I am having challenges moving the superset database to the new server. When I run superset init I get an "invalid decryption key error" and on the superset front end the database list does not load. how do I overcome this error. I have tried using the old SECRET KEY , but still does not work.

I have a better solution

and also offer portable version

https://github.com/alitrack/superset_app

Hi @alitrack - I'm trying to follow steps mentioned in https://github.com/alitrack/superset_app#readme
However, it looks like the link to download 3rd file is not working. Can you please share the correct location of this file?
python_geohash‑0.8.5‑cp38‑cp38‑win_amd64.whl
Thanks!!

@misbadigitalai
download link fixed,
you can download from here, https://www.lfd.uci.edu/~gohlke/pythonlibs/

Hi @mark05e I successfully setup superset on a windows server and wanted to migrate it to another server. I am having challenges moving the superset database to the new server. When I run superset init I get an "invalid decryption key error" and on the superset front end the database list does not load. how do I overcome this error. I have tried using the old SECRET KEY , but still does not work.

Go through these steps to fix "Invalid decryption key" error

and when upgrade from lower version to 1.4 or newer version , also meets this kind error, and I have a solution talk about it, feel free to have a look(Chinese).

set SUPERSET_CONFIG_PATH=superset_config.py 
set FLASK_APP=superset 
superset   version

you need tell where to find your config file, for example,

set SUPERSET_CONFIG_PATH=superset_config.py 
set FLASK_APP=superset 
superset   version

Thank you for the assist @alitrack

Hello guys, can you help me fixed this problem.

Little update for 2023: I needed to install C++ build tools as shown in the following screenshot:

Otherwise the build fails at package geohash.

Another note: I had so set FLASK_APP variable before running anythin in superset. I also had many issues while trying to use a local SQLite database for testing. Using a MySQL database running on a server, everythin works perfectly.

Thank you anyway for this great step-by-step gist for setting up a local test instance of superset! Thats what we need :-)

Thank you for sharing @sebastianknopf !

First of all THANK YOU for getting it to work on Windows. I have tried and failed several times to get it to work on Windows, and gave up after several hours each time. I did get it to work on Windows Virtual Box Ubuntu, but that was a hassle to keep running locally.

Thank you for providing detailed instructions on how to use a compiler to update specific Python wheels or other packages that were not portable from Linux to Windows. I will try this, but first I have some questions.

### HAS ANYONE GOTTEN THE INSTALLATION PROCEDURE ABOVE TO WORK INSIDE A CONDA VIRTUAL ENVIRONMENT?

What is required to make this happen? Which packages are not available in conda format? What would it take to do this?

Frankly I am scared of using pip outside of conda environments, because I have corrupted my Anaconda "base" installation a couple of times by "pipping" packages into a specific virtual environment and it somehow affects my base environment.

I successfully install and use conda and pip installed in all my new conda environments. This keeps the environment packages isolated and all located in one place where conda can located and manage all conda and pip packages: C:\ProgramData\Anaconda3\envs<>" )

I have a beef about the Superset development team philosophy and have a rant / kvetch about how it has never been supported on Windows... The Superset Development Team was no help with Superset on Windows over the past several years. I asked 2, 3, and 4 years ago, and each time I tried and failed to get it to work on Windows, wasting many hours in the process, before giving up and giving in to Linux hacking. I got the same party line statement everywhere from the Superset development team leader(s), "Superset is not officially supported on Windows, but go ahead and try... try Docker on Linux". When maintenance was taken over by Preset Consulting, Preset Consulting continued with that same party line "not officially supported on Windows, try Docker on Linux". Nobody would even answer technical questions, nor provide any insight on specific errors, nor recommended anything to attempt when trying fix the common errors. Too busy with their consulting startup, so they could charge expensive pay-by-the-hour IT consulting services to answer the same questions. That attitude is not helpful at all and holds back adoption by the masses; relegating it to expensive pay-by-the-hour IT consulting services. You had to be a paying customer to get answers on how to install Free Open Source Software? And on Micro$oft-Windows, the world's largest computer user base operating system? Frankly it did not make sense for open source software from Apache Foundation. OFF SOAP-BOX !!

This is more proper steps below.

mkdir D:\superset
cd /d D:\superset

pip install --upgrade setuptools pip

python -m venv venv

venv\Scripts\activate

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py --ssl-no-revoke
python get-pip.py

pip install --upgrade setuptools pip

pip install apache-superset
pip install psycopg2
pip install pymssql
pip install mysqlclient

set FLASK_APP=superset
set SUPERSET_SECRET_KEY="oh-so-secret"

cd venv\Scripts

superset db upgrade
superset fab create-admin
superset init
superset run -p 8088 --with-threads --reload --debugger

If your app (superset) to be accessible from other machines other than 'localhost', you may want to run the app with host 0.0.0.0 as below.
superset run --host=0.0.0.0 -p 8088 --with-threads --reload --debugger

Hello

During the installation in Windows (by following in detail the commands indicated in this document) a series of errors occur that I do not know how to solve?

I think I am doing everything correctly, so I think it is a problem with the installation process.

I think the problems start during the execution of the command

pip install apache-superset

where at one point I get this message

DEPRECATION: celery 4.4.7 has a non-standard dependency specifier pytz>dev. pip 24.1 will enforce this behaviour change. A possible replacement is to upgrade to a newer version of celery or contact the author to suggest that they release a version with a conforming dependency specifiers. Discussion can be found at https://github.com/pypa/pip/issues/12063
`

I get the same message when executing the commands

pip install psycopg2
pip install pymssql

Finally, when executing the upgrade command, an error occurs.

python superset db upgrade

Traceback (most recent call last):
  File "superset", line 18, in <module>
    from superset.cli import superset
  File "c:\superset\venv\lib\site-packages\superset\__init__.py", line 18, in <module>
    from flask import current_app, Flask
  File "c:\superset\venv\lib\site-packages\flask\__init__.py", line 14, in <module>
    from jinja2 import escape
  File "c:\superset\venv\lib\site-packages\jinja2\__init__.py", line 12, in <module>
    from .environment import Environment
  File "c:\superset\venv\lib\site-packages\jinja2\environment.py", line 25, in <module>
    from .defaults import BLOCK_END_STRING
  File "c:\superset\venv\lib\site-packages\jinja2\defaults.py", line 3, in <module>
    from .filters import FILTERS as DEFAULT_FILTERS  # noqa: F401
  File "c:\superset\venv\lib\site-packages\jinja2\filters.py", line 13, in <module>
    from markupsafe import soft_unicode
ImportError: cannot import name 'soft_unicode' from 'markupsafe' (c:\superset\venv\lib\site-packages\markupsafe\__init__.py)

I would appreciate any help, thanks in advance

I attach the complete LOG

c:\superset>python --version
Python 3.7.0

c:\superset>pip --version
pip 24.0 from C:\Python37\lib\site-packages\pip (python 3.7)

c:\superset>systeminfo | findstr /C:"operativo"
Nombre del sistema operativo:              Microsoft Windows Server 2019 Standard
Versión del sistema operativo:             10.0.17763 N/D Compilación 17763
Fabricante del sistema operativo:          Microsoft Corporation
Configuración del sistema operativo:       Servidor independiente
Tipo de compilación del sistema operativo: Multiprocessor Free

:: to avoid problems with previous attempts
c:\superset>pip uninstall apache-superset
Found existing installation: apache-superset 0.36.0
Uninstalling apache-superset-0.36.0:
  Would remove:
    c:\python37\lib\site-packages\apache_superset-0.36.0.dist-info\*
    c:\python37\lib\site-packages\superset\*
    c:\python37\scripts\superset
Proceed (Y/n)? y
  Successfully uninstalled apache-superset-0.36.0

c:\superset>pip install --upgrade setuptools pip
Requirement already satisfied: setuptools in c:\python37\lib\site-packages (68.0.0)
Requirement already satisfied: pip in c:\python37\lib\site-packages (24.0)

c:\superset>python -m venv venv

c:\superset>venv\Scripts\activate

(venv) c:\superset>curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py --ssl-no-revoke
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 2574k  100 2574k    0     0  17.4M      0 --:--:-- --:--:-- --:--:-- 17.7M

(venv) c:\superset>python get-pip.py
Collecting pip
  Using cached pip-24.0-py3-none-any.whl.metadata (3.6 kB)
Collecting wheel
  Using cached wheel-0.42.0-py3-none-any.whl.metadata (2.2 kB)
Using cached pip-24.0-py3-none-any.whl (2.1 MB)
Using cached wheel-0.42.0-py3-none-any.whl (65 kB)
Installing collected packages: wheel, pip
  Attempting uninstall: pip
    Found existing installation: pip 10.0.1
    Uninstalling pip-10.0.1:
      Successfully uninstalled pip-10.0.1
Successfully installed pip-24.0 wheel-0.42.0

(venv) c:\superset>pip install --upgrade setuptools pip
Requirement already satisfied: setuptools in .\venv\lib\site-packages (39.0.1)
Collecting setuptools
  Using cached setuptools-68.0.0-py3-none-any.whl.metadata (6.4 kB)
Requirement already satisfied: pip in .\venv\lib\site-packages (24.0)
Using cached setuptools-68.0.0-py3-none-any.whl (804 kB)
Installing collected packages: setuptools
  Attempting uninstall: setuptools
    Found existing installation: setuptools 39.0.1
    Uninstalling setuptools-39.0.1:
      Successfully uninstalled setuptools-39.0.1
Successfully installed setuptools-68.0.0

(venv) c:\superset>pip install apache-superset
Collecting apache-superset
  Using cached apache-superset-1.5.3.tar.gz (29.7 MB)
  Preparing metadata (setup.py) ... done
Collecting backoff>=1.8.0 (from apache-superset)
  Using cached backoff-2.2.1-py3-none-any.whl.metadata (14 kB)
Collecting bleach<4.0.0,>=3.0.2 (from apache-superset)
  Using cached bleach-3.3.1-py2.py3-none-any.whl.metadata (23 kB)
Collecting cachelib<0.5,>=0.4.1 (from apache-superset)
  Using cached cachelib-0.4.1-py3-none-any.whl.metadata (2.0 kB)
Collecting celery!=4.4.1,<5.0.0,>=4.3.0 (from apache-superset)
  Using cached celery-4.4.7-py2.py3-none-any.whl.metadata (19 kB)
Collecting click<8 (from apache-superset)
  Using cached click-7.1.2-py2.py3-none-any.whl.metadata (2.9 kB)
Collecting colorama (from apache-superset)
  Using cached colorama-0.4.6-py2.py3-none-any.whl.metadata (17 kB)
Collecting croniter>=0.3.28 (from apache-superset)
  Using cached croniter-2.0.5-py2.py3-none-any.whl.metadata (25 kB)
Collecting cron-descriptor (from apache-superset)
  Using cached cron_descriptor-1.4.3-py3-none-any.whl.metadata (5.7 kB)
Collecting cryptography>=3.3.2 (from apache-superset)
  Using cached cryptography-42.0.7-cp37-abi3-win_amd64.whl.metadata (5.4 kB)
Collecting deprecation<2.2.0,>=2.1.0 (from apache-superset)
  Using cached deprecation-2.1.0-py2.py3-none-any.whl.metadata (4.6 kB)
Collecting flask<2.0.0,>=1.1.0 (from apache-superset)
  Using cached Flask-1.1.4-py2.py3-none-any.whl.metadata (4.6 kB)
Collecting flask-appbuilder<4.0.0,>=3.4.5 (from apache-superset)
  Using cached Flask_AppBuilder-3.4.5-py3-none-any.whl.metadata (10 kB)
Collecting flask-caching>=1.10.0 (from apache-superset)
  Using cached Flask_Caching-2.1.0-py3-none-any.whl.metadata (2.2 kB)
Collecting flask-compress (from apache-superset)
  Using cached Flask_Compress-1.15-py3-none-any.whl.metadata (8.4 kB)
Collecting flask-talisman (from apache-superset)
  Using cached flask_talisman-1.1.0-py2.py3-none-any.whl.metadata (18 kB)
Collecting flask-migrate (from apache-superset)
  Using cached Flask_Migrate-4.0.7-py3-none-any.whl.metadata (3.1 kB)
Collecting flask-wtf (from apache-superset)
  Using cached Flask_WTF-1.1.1-py3-none-any.whl.metadata (1.9 kB)
Collecting func_timeout (from apache-superset)
  Using cached func_timeout-4.3.5.tar.gz (44 kB)
  Preparing metadata (setup.py) ... done
Collecting geopy (from apache-superset)
  Using cached geopy-2.4.1-py3-none-any.whl.metadata (6.8 kB)
Collecting graphlib-backport (from apache-superset)
  Using cached graphlib_backport-1.1.0-py3-none-any.whl.metadata (4.4 kB)
Collecting gunicorn>=20.1.0 (from apache-superset)
  Using cached gunicorn-22.0.0-py3-none-any.whl.metadata (4.4 kB)
Collecting hashids<2,>=1.3.1 (from apache-superset)
  Using cached hashids-1.3.1-py2.py3-none-any.whl.metadata (5.5 kB)
Collecting holidays==0.10.3 (from apache-superset)
  Using cached holidays-0.10.3.tar.gz (114 kB)
  Preparing metadata (setup.py) ... done
Collecting humanize (from apache-superset)
  Using cached humanize-4.6.0-py3-none-any.whl.metadata (7.9 kB)
Collecting itsdangerous<2.0.0,>=1.0.0 (from apache-superset)
  Using cached itsdangerous-1.1.0-py2.py3-none-any.whl.metadata (3.1 kB)
Collecting isodate (from apache-superset)
  Using cached isodate-0.6.1-py2.py3-none-any.whl.metadata (9.6 kB)
Collecting markdown>=3.0 (from apache-superset)
  Using cached Markdown-3.4.4-py3-none-any.whl.metadata (6.9 kB)
Collecting msgpack<1.1,>=1.0.0 (from apache-superset)
  Using cached msgpack-1.0.5-cp37-cp37m-win_amd64.whl.metadata (9.0 kB)
INFO: pip is looking at multiple versions of apache-superset to determine which version is compatible with other requirements. This could take a while.
Collecting apache-superset
  Using cached apache-superset-1.5.2.tar.gz (29.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.5.1.tar.gz (29.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.5.0.tar.gz (29.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.4.2.tar.gz (32.9 MB)
  Preparing metadata (setup.py) ... done
Collecting cachelib<0.2,>=0.1.1 (from apache-superset)
  Using cached cachelib-0.1.1-py3-none-any.whl.metadata (1.2 kB)
Collecting apache-superset
  Using cached apache-superset-1.4.1.tar.gz (32.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.4.0.tar.gz (32.9 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.3.2.tar.gz (31.4 MB)
  Preparing metadata (setup.py) ... done
Collecting gunicorn<20.1,>=20.0.2 (from apache-superset)
  Using cached gunicorn-20.0.4-py2.py3-none-any.whl.metadata (3.5 kB)
INFO: pip is still looking at multiple versions of apache-superset to determine which version is compatible with other requirements. This could take a while.
Collecting apache-superset
  Using cached apache-superset-1.3.1.tar.gz (31.4 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.3.0.tar.gz (31.4 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.2.0.tar.gz (25.3 MB)
  Preparing metadata (setup.py) ... done
Collecting contextlib2 (from apache-superset)
  Using cached contextlib2-21.6.0-py2.py3-none-any.whl.metadata (4.1 kB)
Collecting apache-superset
  Using cached apache-superset-1.1.0.tar.gz (24.7 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-1.0.1.tar.gz (23.9 MB)
  Preparing metadata (setup.py) ... done
Collecting pandas<1.2,>=1.1.2 (from apache-superset)
  Using cached pandas-1.1.5-cp37-cp37m-win_amd64.whl.metadata (4.7 kB)
Collecting parsedatetime (from apache-superset)
  Using cached parsedatetime-2.6-py3-none-any.whl.metadata (4.7 kB)
Collecting pathlib2 (from apache-superset)
  Using cached pathlib2-2.3.7.post1-py2.py3-none-any.whl.metadata (3.5 kB)
Collecting pgsanity (from apache-superset)
  Using cached pgsanity-0.2.9.tar.gz (7.5 kB)
  Preparing metadata (setup.py) ... done
Collecting polyline (from apache-superset)
  Using cached polyline-2.0.2-py3-none-any.whl.metadata (6.4 kB)
Collecting python-dateutil (from apache-superset)
  Using cached python_dateutil-2.9.0.post0-py2.py3-none-any.whl.metadata (8.4 kB)
Collecting python-dotenv (from apache-superset)
  Using cached python_dotenv-0.21.1-py3-none-any.whl.metadata (21 kB)
Collecting python-geohash (from apache-superset)
  Using cached python_geohash-0.8.5-cp37-cp37m-win_amd64.whl
Collecting pyarrow<1.1,>=1.0.1 (from apache-superset)
  Using cached pyarrow-1.0.1-cp37-cp37m-win_amd64.whl.metadata (2.8 kB)
Collecting pyyaml>=5.1 (from apache-superset)
  Using cached PyYAML-6.0.1-cp37-cp37m-win_amd64.whl.metadata (2.1 kB)
Collecting PyJWT<2,>=1.7.1 (from apache-superset)
  Using cached PyJWT-1.7.1-py2.py3-none-any.whl.metadata (3.9 kB)
Collecting redis (from apache-superset)
  Using cached redis-5.0.4-py3-none-any.whl.metadata (9.3 kB)
Collecting retry>=0.9.2 (from apache-superset)
  Using cached retry-0.9.2-py2.py3-none-any.whl.metadata (5.8 kB)
Collecting selenium>=3.141.0 (from apache-superset)
  Using cached selenium-4.11.2-py3-none-any.whl.metadata (7.0 kB)
Collecting simplejson>=3.15.0 (from apache-superset)
  Using cached simplejson-3.19.2-cp37-cp37m-win_amd64.whl.metadata (3.2 kB)
Collecting slackclient==2.5.0 (from apache-superset)
  Using cached slackclient-2.5.0-py2.py3-none-any.whl.metadata (11 kB)
Collecting sqlalchemy!=1.3.21,<2.0,>=1.3.16 (from apache-superset)
  Using cached SQLAlchemy-1.4.52-cp37-cp37m-win_amd64.whl.metadata (10 kB)
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime. See https://pip.pypa.io/warnings/backtracking for guidance. If you want to abort this run, press Ctrl + C.
Collecting apache-superset
  Using cached apache-superset-1.0.0.tar.gz (34.7 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-0.38.1.tar.gz (33.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-0.38.0.tar.gz (33.6 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-0.37.2.tar.gz (41.2 MB)
  Preparing metadata (setup.py) ... done
Collecting dataclasses<0.7 (from apache-superset)
  Using cached dataclasses-0.6-py3-none-any.whl.metadata (3.0 kB)
Collecting pandas<1.1,>=1.0.3 (from apache-superset)
  Using cached pandas-1.0.5-cp37-cp37m-win_amd64.whl.metadata (4.7 kB)
Collecting pyarrow<0.18,>=0.17.0 (from apache-superset)
  Using cached pyarrow-0.17.1-cp37-cp37m-win_amd64.whl.metadata (2.8 kB)
Collecting apache-superset
  Using cached apache-superset-0.37.1.tar.gz (41.2 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache-superset-0.37.0.tar.gz (41.2 MB)
  Preparing metadata (setup.py) ... done
  Using cached apache_superset-0.36.0-py3-none-any.whl
Collecting flask-appbuilder<2.4.0,>=2.3.1 (from apache-superset)
  Using cached Flask_AppBuilder-2.3.4-py3-none-any.whl.metadata (8.5 kB)
Collecting msgpack<0.7.0,>=0.6.1 (from apache-superset)
  Using cached msgpack-0.6.2-cp37-cp37m-win_amd64.whl.metadata (10 kB)
Collecting pandas<1.0,>=0.25.3 (from apache-superset)
  Using cached pandas-0.25.3-cp37-cp37m-win_amd64.whl.metadata (4.8 kB)
Collecting pyarrow<0.17.0,>=0.16.0 (from apache-superset)
  Using cached pyarrow-0.16.0-cp37-cp37m-win_amd64.whl.metadata (3.0 kB)
Collecting sqlalchemy-utils>=0.33.2 (from apache-superset)
  Using cached SQLAlchemy_Utils-0.41.2-py3-none-any.whl.metadata (4.2 kB)
Collecting sqlparse<0.4,>=0.3.0 (from apache-superset)
  Using cached sqlparse-0.3.1-py2.py3-none-any.whl.metadata (2.4 kB)
Collecting wtforms-json (from apache-superset)
  Using cached WTForms_JSON-0.3.5-py3-none-any.whl
Collecting packaging (from bleach<4.0.0,>=3.0.2->apache-superset)
  Using cached packaging-24.0-py3-none-any.whl.metadata (3.2 kB)
Collecting six>=1.9.0 (from bleach<4.0.0,>=3.0.2->apache-superset)
  Using cached six-1.16.0-py2.py3-none-any.whl.metadata (1.8 kB)
Collecting webencodings (from bleach<4.0.0,>=3.0.2->apache-superset)
  Using cached webencodings-0.5.1-py2.py3-none-any.whl.metadata (2.1 kB)
Collecting pytz>dev (from celery!=4.4.1,<5.0.0,>=4.3.0->apache-superset)
  Using cached pytz-2024.1-py2.py3-none-any.whl.metadata (22 kB)
Collecting billiard<4.0,>=3.6.3.0 (from celery!=4.4.1,<5.0.0,>=4.3.0->apache-superset)
  Using cached billiard-3.6.4.0-py3-none-any.whl.metadata (4.5 kB)
Collecting kombu<4.7,>=4.6.10 (from celery!=4.4.1,<5.0.0,>=4.3.0->apache-superset)
  Using cached kombu-4.6.11-py2.py3-none-any.whl.metadata (2.6 kB)
Collecting vine==1.3.0 (from celery!=4.4.1,<5.0.0,>=4.3.0->apache-superset)
  Using cached vine-1.3.0-py2.py3-none-any.whl.metadata (2.4 kB)
Collecting cffi>=1.12 (from cryptography>=3.3.2->apache-superset)
  Using cached cffi-1.15.1-cp37-cp37m-win_amd64.whl.metadata (1.1 kB)
Collecting Werkzeug<2.0,>=0.15 (from flask<2.0.0,>=1.1.0->apache-superset)
  Using cached Werkzeug-1.0.1-py2.py3-none-any.whl.metadata (4.7 kB)
Collecting Jinja2<3.0,>=2.10.1 (from flask<2.0.0,>=1.1.0->apache-superset)
  Using cached Jinja2-2.11.3-py2.py3-none-any.whl.metadata (3.5 kB)
Collecting apispec<2,>=1.1.1 (from apispec[yaml]<2,>=1.1.1->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached apispec-1.3.3-py2.py3-none-any.whl.metadata (9.4 kB)
Collecting email-validator<2,>=1.0.5 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached email_validator-1.3.1-py2.py3-none-any.whl.metadata (23 kB)
Collecting Flask-Babel<2,>=1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Flask_Babel-1.0.0-py3-none-any.whl.metadata (2.2 kB)
Collecting Flask-Login<0.5,>=0.3 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Flask_Login-0.4.1-py2.py3-none-any.whl
Collecting Flask-OpenID<2,>=1.2.5 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Flask_OpenID-1.3.0-py3-none-any.whl.metadata (1.4 kB)
Collecting Flask-SQLAlchemy<3,>=2.4 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl.metadata (3.1 kB)
Collecting flask-wtf (from apache-superset)
  Using cached Flask_WTF-0.15.1-py2.py3-none-any.whl.metadata (2.1 kB)
Collecting Flask-JWT-Extended<4,>=3.18 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Flask_JWT_Extended-3.25.1-py2.py3-none-any.whl
Collecting jsonschema<4,>=3.0.1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached jsonschema-3.2.0-py2.py3-none-any.whl.metadata (7.8 kB)
Collecting marshmallow<3.0.0,>=2.18.0 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached marshmallow-2.21.0-py2.py3-none-any.whl.metadata (7.4 kB)
Collecting marshmallow-enum<2,>=1.4.1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached marshmallow_enum-1.5.1-py2.py3-none-any.whl.metadata (2.5 kB)
Collecting marshmallow-sqlalchemy<1,>=0.16.1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached marshmallow_sqlalchemy-0.29.0-py2.py3-none-any.whl.metadata (6.8 kB)
Collecting prison<1.0.0,>=0.1.3 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached prison-0.2.1-py2.py3-none-any.whl.metadata (973 bytes)
Collecting PyJWT>=1.7.1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached PyJWT-2.8.0-py3-none-any.whl.metadata (4.2 kB)
Collecting WTForms (from flask-wtf->apache-superset)
  Using cached WTForms-3.0.1-py3-none-any.whl.metadata (3.2 kB)
Requirement already satisfied: setuptools>=3.0 in .\venv\lib\site-packages (from gunicorn<20.1,>=20.0.2->apache-superset) (68.0.0)
Collecting importlib-metadata>=4.4 (from markdown>=3.0->apache-superset)
  Using cached importlib_metadata-6.7.0-py3-none-any.whl.metadata (4.9 kB)
Collecting numpy>=1.13.3 (from pandas<1.0,>=0.25.3->apache-superset)
  Using cached numpy-1.21.6-cp37-cp37m-win_amd64.whl.metadata (2.2 kB)
Collecting decorator>=3.4.2 (from retry>=0.9.2->apache-superset)
  Using cached decorator-5.1.1-py3-none-any.whl.metadata (4.0 kB)
Collecting py<2.0.0,>=1.4.26 (from retry>=0.9.2->apache-superset)
  Using cached py-1.11.0-py2.py3-none-any.whl.metadata (2.8 kB)
Collecting urllib3<3,>=1.26 (from urllib3[socks]<3,>=1.26->selenium>=3.141.0->apache-superset)
  Using cached urllib3-2.0.7-py3-none-any.whl.metadata (6.6 kB)
Collecting trio~=0.17 (from selenium>=3.141.0->apache-superset)
  Using cached trio-0.22.2-py3-none-any.whl.metadata (4.7 kB)
Collecting trio-websocket~=0.9 (from selenium>=3.141.0->apache-superset)
  Using cached trio_websocket-0.11.1-py3-none-any.whl.metadata (4.7 kB)
Collecting certifi>=2021.10.8 (from selenium>=3.141.0->apache-superset)
  Using cached certifi-2024.2.2-py3-none-any.whl.metadata (2.2 kB)
Collecting greenlet!=0.4.17 (from sqlalchemy!=1.3.21,<2.0,>=1.3.16->apache-superset)
  Using cached greenlet-3.0.3-cp37-cp37m-win_amd64.whl.metadata (3.9 kB)
Collecting cachelib<0.10.0,>=0.9.0 (from flask-caching>=1.10.0->apache-superset)
  Using cached cachelib-0.9.0-py3-none-any.whl.metadata (1.9 kB)
Collecting brotli (from flask-compress->apache-superset)
  Using cached Brotli-1.1.0-cp37-cp37m-win_amd64.whl.metadata (5.6 kB)
Collecting zstandard (from flask-compress->apache-superset)
  Using cached zstandard-0.21.0-cp37-cp37m-win_amd64.whl.metadata (3.0 kB)
Collecting alembic>=1.9.0 (from flask-migrate->apache-superset)
  Using cached alembic-1.12.1-py3-none-any.whl.metadata (7.3 kB)
Collecting geographiclib<3,>=1.52 (from geopy->apache-superset)
  Using cached geographiclib-2.0-py3-none-any.whl.metadata (1.4 kB)
Collecting Mako (from alembic>=1.9.0->flask-migrate->apache-superset)
  Using cached Mako-1.2.4-py3-none-any.whl.metadata (2.9 kB)
Collecting typing-extensions>=4 (from alembic>=1.9.0->flask-migrate->apache-superset)
  Using cached typing_extensions-4.7.1-py3-none-any.whl.metadata (3.1 kB)
Collecting importlib-resources (from alembic>=1.9.0->flask-migrate->apache-superset)
  Using cached importlib_resources-5.12.0-py3-none-any.whl.metadata (4.1 kB)
Collecting pycparser (from cffi>=1.12->cryptography>=3.3.2->apache-superset)
  Using cached pycparser-2.21-py2.py3-none-any.whl.metadata (1.1 kB)
Collecting dnspython>=1.15.0 (from email-validator<2,>=1.0.5->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached dnspython-2.3.0-py3-none-any.whl.metadata (5.2 kB)
Collecting idna>=2.0.0 (from email-validator<2,>=1.0.5->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached idna-3.7-py3-none-any.whl.metadata (9.9 kB)
Collecting Babel>=2.3 (from Flask-Babel<2,>=1->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached Babel-2.14.0-py3-none-any.whl.metadata (1.6 kB)
Collecting python3-openid>=2.0 (from Flask-OpenID<2,>=1.2.5->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached python3_openid-3.2.0-py3-none-any.whl.metadata (1.6 kB)
Collecting zipp>=0.5 (from importlib-metadata>=4.4->markdown>=3.0->apache-superset)
  Using cached zipp-3.15.0-py3-none-any.whl.metadata (3.7 kB)
Collecting MarkupSafe>=0.23 (from Jinja2<3.0,>=2.10.1->flask<2.0.0,>=1.1.0->apache-superset)
  Using cached MarkupSafe-2.1.5-cp37-cp37m-win_amd64.whl.metadata (3.1 kB)
Collecting attrs>=17.4.0 (from jsonschema<4,>=3.0.1->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached attrs-23.2.0-py3-none-any.whl.metadata (9.5 kB)
Collecting pyrsistent>=0.14.0 (from jsonschema<4,>=3.0.1->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached pyrsistent-0.19.3-cp37-cp37m-win_amd64.whl.metadata (975 bytes)
Collecting amqp<2.7,>=2.6.0 (from kombu<4.7,>=4.6.10->celery!=4.4.1,<5.0.0,>=4.3.0->apache-superset)
  Using cached amqp-2.6.1-py2.py3-none-any.whl.metadata (1.0 kB)
INFO: pip is looking at multiple versions of marshmallow-sqlalchemy to determine which version is compatible with other requirements. This could take a while.
Collecting marshmallow-sqlalchemy<1,>=0.16.1 (from flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached marshmallow_sqlalchemy-0.28.2-py2.py3-none-any.whl.metadata (6.8 kB)
  Using cached marshmallow_sqlalchemy-0.28.1-py2.py3-none-any.whl.metadata (6.8 kB)
  Using cached marshmallow_sqlalchemy-0.28.0-py2.py3-none-any.whl.metadata (6.8 kB)
  Using cached marshmallow_sqlalchemy-0.27.0-py2.py3-none-any.whl.metadata (6.8 kB)
  Using cached marshmallow_sqlalchemy-0.26.1-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.26.0-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.25.0-py2.py3-none-any.whl.metadata (6.7 kB)
INFO: pip is still looking at multiple versions of marshmallow-sqlalchemy to determine which version is compatible with other requirements. This could take a while.
  Using cached marshmallow_sqlalchemy-0.24.3-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.24.2-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.24.1-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.24.0-py2.py3-none-any.whl.metadata (6.7 kB)
  Using cached marshmallow_sqlalchemy-0.23.1-py2.py3-none-any.whl.metadata (6.7 kB)
Collecting sortedcontainers (from trio~=0.17->selenium>=3.141.0->apache-superset)
  Using cached sortedcontainers-2.4.0-py2.py3-none-any.whl.metadata (10 kB)
Collecting outcome (from trio~=0.17->selenium>=3.141.0->apache-superset)
  Using cached outcome-1.3.0.post0-py2.py3-none-any.whl.metadata (2.6 kB)
Collecting sniffio (from trio~=0.17->selenium>=3.141.0->apache-superset)
  Using cached sniffio-1.3.1-py3-none-any.whl.metadata (3.9 kB)
Collecting exceptiongroup>=1.0.0rc9 (from trio~=0.17->selenium>=3.141.0->apache-superset)
  Using cached exceptiongroup-1.2.1-py3-none-any.whl.metadata (6.6 kB)
Collecting wsproto>=0.14 (from trio-websocket~=0.9->selenium>=3.141.0->apache-superset)
  Using cached wsproto-1.2.0-py3-none-any.whl.metadata (5.6 kB)
Collecting pysocks!=1.5.7,<2.0,>=1.5.6 (from urllib3[socks]<3,>=1.26->selenium>=3.141.0->apache-superset)
  Using cached PySocks-1.7.1-py3-none-any.whl.metadata (13 kB)
Collecting defusedxml (from python3-openid>=2.0->Flask-OpenID<2,>=1.2.5->flask-appbuilder<2.4.0,>=2.3.1->apache-superset)
  Using cached defusedxml-0.7.1-py2.py3-none-any.whl.metadata (32 kB)
Collecting h11<1,>=0.9.0 (from wsproto>=0.14->trio-websocket~=0.9->selenium>=3.141.0->apache-superset)
  Using cached h11-0.14.0-py3-none-any.whl.metadata (8.2 kB)
Using cached backoff-2.2.1-py3-none-any.whl (15 kB)
Using cached bleach-3.3.1-py2.py3-none-any.whl (146 kB)
Using cached celery-4.4.7-py2.py3-none-any.whl (427 kB)
Using cached vine-1.3.0-py2.py3-none-any.whl (14 kB)
Using cached click-7.1.2-py2.py3-none-any.whl (82 kB)
Using cached croniter-2.0.5-py2.py3-none-any.whl (20 kB)
Using cached cryptography-42.0.7-cp37-abi3-win_amd64.whl (2.9 MB)
Using cached Flask-1.1.4-py2.py3-none-any.whl (94 kB)
Using cached Flask_AppBuilder-2.3.4-py3-none-any.whl (1.7 MB)
Using cached colorama-0.4.6-py2.py3-none-any.whl (25 kB)
Using cached Flask_WTF-0.15.1-py2.py3-none-any.whl (13 kB)
Using cached gunicorn-20.0.4-py2.py3-none-any.whl (77 kB)
Using cached Markdown-3.4.4-py3-none-any.whl (94 kB)
Using cached msgpack-0.6.2-cp37-cp37m-win_amd64.whl (68 kB)
Using cached pandas-0.25.3-cp37-cp37m-win_amd64.whl (9.2 MB)
Using cached pyarrow-0.16.0-cp37-cp37m-win_amd64.whl (20.4 MB)
Using cached python_dateutil-2.9.0.post0-py2.py3-none-any.whl (229 kB)
Using cached PyYAML-6.0.1-cp37-cp37m-win_amd64.whl (153 kB)
Using cached retry-0.9.2-py2.py3-none-any.whl (8.0 kB)
Using cached selenium-4.11.2-py3-none-any.whl (7.2 MB)
Using cached simplejson-3.19.2-cp37-cp37m-win_amd64.whl (75 kB)
Using cached SQLAlchemy-1.4.52-cp37-cp37m-win_amd64.whl (1.6 MB)
Using cached SQLAlchemy_Utils-0.41.2-py3-none-any.whl (93 kB)
Using cached sqlparse-0.3.1-py2.py3-none-any.whl (40 kB)
Using cached contextlib2-21.6.0-py2.py3-none-any.whl (13 kB)
Using cached Flask_Caching-2.1.0-py3-none-any.whl (28 kB)
Using cached Flask_Compress-1.15-py3-none-any.whl (8.6 kB)
Using cached Flask_Migrate-4.0.7-py3-none-any.whl (21 kB)
Using cached flask_talisman-1.1.0-py2.py3-none-any.whl (18 kB)
Using cached geopy-2.4.1-py3-none-any.whl (125 kB)
Using cached humanize-4.6.0-py3-none-any.whl (109 kB)
Using cached isodate-0.6.1-py2.py3-none-any.whl (41 kB)
Using cached parsedatetime-2.6-py3-none-any.whl (42 kB)
Using cached pathlib2-2.3.7.post1-py2.py3-none-any.whl (18 kB)
Using cached polyline-2.0.2-py3-none-any.whl (6.0 kB)
Using cached python_dotenv-0.21.1-py3-none-any.whl (19 kB)
Using cached alembic-1.12.1-py3-none-any.whl (226 kB)
Using cached apispec-1.3.3-py2.py3-none-any.whl (23 kB)
Using cached billiard-3.6.4.0-py3-none-any.whl (89 kB)
Using cached cachelib-0.9.0-py3-none-any.whl (15 kB)
Using cached certifi-2024.2.2-py3-none-any.whl (163 kB)
Using cached cffi-1.15.1-cp37-cp37m-win_amd64.whl (179 kB)
Using cached decorator-5.1.1-py3-none-any.whl (9.1 kB)
Using cached email_validator-1.3.1-py2.py3-none-any.whl (22 kB)
Using cached Flask_Babel-1.0.0-py3-none-any.whl (9.5 kB)
Using cached Flask_OpenID-1.3.0-py3-none-any.whl (9.3 kB)
Using cached Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl (17 kB)
Using cached geographiclib-2.0-py3-none-any.whl (40 kB)
Using cached greenlet-3.0.3-cp37-cp37m-win_amd64.whl (291 kB)
Using cached importlib_metadata-6.7.0-py3-none-any.whl (22 kB)
Using cached itsdangerous-1.1.0-py2.py3-none-any.whl (16 kB)
Using cached Jinja2-2.11.3-py2.py3-none-any.whl (125 kB)
Using cached jsonschema-3.2.0-py2.py3-none-any.whl (56 kB)
Using cached kombu-4.6.11-py2.py3-none-any.whl (184 kB)
Using cached marshmallow-2.21.0-py2.py3-none-any.whl (50 kB)
Using cached marshmallow_enum-1.5.1-py2.py3-none-any.whl (4.2 kB)
Using cached marshmallow_sqlalchemy-0.23.1-py2.py3-none-any.whl (18 kB)
Using cached numpy-1.21.6-cp37-cp37m-win_amd64.whl (14.0 MB)
Using cached prison-0.2.1-py2.py3-none-any.whl (5.8 kB)
Using cached py-1.11.0-py2.py3-none-any.whl (98 kB)
Using cached PyJWT-1.7.1-py2.py3-none-any.whl (18 kB)
Using cached pytz-2024.1-py2.py3-none-any.whl (505 kB)
Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Using cached trio-0.22.2-py3-none-any.whl (400 kB)
Using cached trio_websocket-0.11.1-py3-none-any.whl (17 kB)
Using cached urllib3-2.0.7-py3-none-any.whl (124 kB)
Using cached Werkzeug-1.0.1-py2.py3-none-any.whl (298 kB)
Using cached WTForms-3.0.1-py3-none-any.whl (136 kB)
Using cached Brotli-1.1.0-cp37-cp37m-win_amd64.whl (357 kB)
Using cached packaging-24.0-py3-none-any.whl (53 kB)
Using cached webencodings-0.5.1-py2.py3-none-any.whl (11 kB)
Using cached zstandard-0.21.0-cp37-cp37m-win_amd64.whl (659 kB)
Using cached amqp-2.6.1-py2.py3-none-any.whl (48 kB)
Using cached attrs-23.2.0-py3-none-any.whl (60 kB)
Using cached Babel-2.14.0-py3-none-any.whl (11.0 MB)
Using cached dnspython-2.3.0-py3-none-any.whl (283 kB)
Using cached exceptiongroup-1.2.1-py3-none-any.whl (16 kB)
Using cached idna-3.7-py3-none-any.whl (66 kB)
Using cached MarkupSafe-2.1.5-cp37-cp37m-win_amd64.whl (17 kB)
Using cached pyrsistent-0.19.3-cp37-cp37m-win_amd64.whl (62 kB)
Using cached PySocks-1.7.1-py3-none-any.whl (16 kB)
Using cached python3_openid-3.2.0-py3-none-any.whl (133 kB)
Using cached typing_extensions-4.7.1-py3-none-any.whl (33 kB)
Using cached wsproto-1.2.0-py3-none-any.whl (24 kB)
Using cached zipp-3.15.0-py3-none-any.whl (6.8 kB)
Using cached importlib_resources-5.12.0-py3-none-any.whl (36 kB)
Using cached Mako-1.2.4-py3-none-any.whl (78 kB)
Using cached outcome-1.3.0.post0-py2.py3-none-any.whl (10 kB)
Using cached pycparser-2.21-py2.py3-none-any.whl (118 kB)
Using cached sniffio-1.3.1-py3-none-any.whl (10 kB)
Using cached sortedcontainers-2.4.0-py2.py3-none-any.whl (29 kB)
Using cached h11-0.14.0-py3-none-any.whl (58 kB)
Using cached defusedxml-0.7.1-py2.py3-none-any.whl (25 kB)
DEPRECATION: celery 4.4.7 has a non-standard dependency specifier pytz>dev. pip 24.1 will enforce this behaviour change. A possible replacement is to upgrade to a newer version of celery or contact the author to suggest that they release a version with a conforming dependency specifiers. Discussion can be found at https://github.com/pypa/pip/issues/12063
Installing collected packages: webencodings, sortedcontainers, pytz, python-geohash, PyJWT, parsedatetime, msgpack, marshmallow, flask-talisman, brotli, billiard, apispec, zstandard, zipp, Werkzeug, vine, urllib3, typing-extensions, sqlparse, sniffio, six, simplejson, pyyaml, python-dotenv, pysocks, pyrsistent, pycparser, py, polyline, packaging, numpy, marshmallow-enum, MarkupSafe, itsdangerous, idna, gunicorn, greenlet, geographiclib, exceptiongroup, dnspython, defusedxml, decorator, contextlib2, colorama, click, certifi, cachelib, backoff, Babel, WTForms, retry, python3-openid, python-dateutil, pyarrow, prison, pathlib2, Jinja2, isodate, importlib-resources, importlib-metadata, h11, geopy, email-validator, cffi, bleach, amqp, wtforms-json, wsproto, sqlalchemy, pandas, markdown, Mako, kombu, humanize, flask, cryptography, croniter, attrs, sqlalchemy-utils, outcome, marshmallow-sqlalchemy, jsonschema, flask-wtf, Flask-SQLAlchemy, Flask-OpenID, Flask-Login, Flask-JWT-Extended, flask-compress, flask-caching, Flask-Babel, celery, alembic, trio, flask-migrate, flask-appbuilder, trio-websocket, selenium, apache-superset
Successfully installed Babel-2.14.0 Flask-Babel-1.0.0 Flask-JWT-Extended-3.25.1 Flask-Login-0.4.1 Flask-OpenID-1.3.0 Flask-SQLAlchemy-2.5.1 Jinja2-2.11.3 Mako-1.2.4 MarkupSafe-2.1.5 PyJWT-1.7.1 WTForms-3.0.1 Werkzeug-1.0.1 alembic-1.12.1 amqp-2.6.1 apache-superset-0.36.0 apispec-1.3.3 attrs-23.2.0 backoff-2.2.1 billiard-3.6.4.0 bleach-3.3.1 brotli-1.1.0 cachelib-0.9.0 celery-4.4.7 certifi-2024.2.2 cffi-1.15.1 click-7.1.2 colorama-0.4.6 contextlib2-21.6.0 croniter-2.0.5 cryptography-42.0.7 decorator-5.1.1 defusedxml-0.7.1 dnspython-2.3.0 email-validator-1.3.1 exceptiongroup-1.2.1 flask-1.1.4 flask-appbuilder-2.3.4 flask-caching-2.1.0 flask-compress-1.15 flask-migrate-4.0.7 flask-talisman-1.1.0 flask-wtf-0.15.1 geographiclib-2.0 geopy-2.4.1 greenlet-3.0.3 gunicorn-20.0.4 h11-0.14.0 humanize-4.6.0 idna-3.7 importlib-metadata-6.7.0 importlib-resources-5.12.0 isodate-0.6.1 itsdangerous-1.1.0 jsonschema-3.2.0 kombu-4.6.11 markdown-3.4.4 marshmallow-2.21.0 marshmallow-enum-1.5.1 marshmallow-sqlalchemy-0.23.1 msgpack-0.6.2 numpy-1.21.6 outcome-1.3.0.post0 packaging-24.0 pandas-0.25.3 parsedatetime-2.6 pathlib2-2.3.7.post1 polyline-2.0.2 prison-0.2.1 py-1.11.0 pyarrow-0.16.0 pycparser-2.21 pyrsistent-0.19.3 pysocks-1.7.1 python-dateutil-2.9.0.post0 python-dotenv-0.21.1 python-geohash-0.8.5 python3-openid-3.2.0 pytz-2024.1 pyyaml-6.0.1 retry-0.9.2 selenium-4.11.2 simplejson-3.19.2 six-1.16.0 sniffio-1.3.1 sortedcontainers-2.4.0 sqlalchemy-1.4.52 sqlalchemy-utils-0.41.2 sqlparse-0.3.1 trio-0.22.2 trio-websocket-0.11.1 typing-extensions-4.7.1 urllib3-2.0.7 vine-1.3.0 webencodings-0.5.1 wsproto-1.2.0 wtforms-json-0.3.5 zipp-3.15.0 zstandard-0.21.0

(venv) c:\superset>pip install psycopg2
Collecting psycopg2
  Using cached psycopg2-2.9.9-cp37-cp37m-win_amd64.whl.metadata (4.5 kB)
Using cached psycopg2-2.9.9-cp37-cp37m-win_amd64.whl (1.2 MB)
DEPRECATION: celery 4.4.7 has a non-standard dependency specifier pytz>dev. pip 24.1 will enforce this behaviour change. A possible replacement is to upgrade to a newer version of celery or contact the author to suggest that they release a version with a conforming dependency specifiers. Discussion can be found at https://github.com/pypa/pip/issues/12063
Installing collected packages: psycopg2
Successfully installed psycopg2-2.9.9

(venv) c:\superset>pip install pymssql
Collecting pymssql
  Using cached pymssql-2.3.0-cp37-cp37m-win_amd64.whl.metadata (7.6 kB)
Using cached pymssql-2.3.0-cp37-cp37m-win_amd64.whl (2.0 MB)
DEPRECATION: celery 4.4.7 has a non-standard dependency specifier pytz>dev. pip 24.1 will enforce this behaviour change. A possible replacement is to upgrade to a newer version of celery or contact the author to suggest that they release a version with a conforming dependency specifiers. Discussion can be found at https://github.com/pypa/pip/issues/12063
Installing collected packages: pymssql
Successfully installed pymssql-2.3.0

(venv) c:\superset>cd venv\Scripts

(venv) c:\superset\venv\Scripts>python superset db upgrade
Traceback (most recent call last):
  File "superset", line 18, in <module>
    from superset.cli import superset
  File "c:\superset\venv\lib\site-packages\superset\__init__.py", line 18, in <module>
    from flask import current_app, Flask
  File "c:\superset\venv\lib\site-packages\flask\__init__.py", line 14, in <module>
    from jinja2 import escape
  File "c:\superset\venv\lib\site-packages\jinja2\__init__.py", line 12, in <module>
    from .environment import Environment
  File "c:\superset\venv\lib\site-packages\jinja2\environment.py", line 25, in <module>
    from .defaults import BLOCK_END_STRING
  File "c:\superset\venv\lib\site-packages\jinja2\defaults.py", line 3, in <module>
    from .filters import FILTERS as DEFAULT_FILTERS  # noqa: F401
  File "c:\superset\venv\lib\site-packages\jinja2\filters.py", line 13, in <module>
    from markupsafe import soft_unicode
ImportError: cannot import name 'soft_unicode' from 'markupsafe' (c:\superset\venv\lib\site-packages\markupsafe\__init__.py)

(venv) c:\superset\venv\Scripts>

@mark05e
Help with this pr for windows development env
https://github.com/apache/superset/issues@/30422