Skip to content

Instantly share code, notes, and snippets.

@AnanthaRajuC

AnanthaRajuC/Apache Superset-0.35.2--Installation Guide for Windows 10.md

Forked from Jamesvasanth21/Apache Superset-0.35.2--Installation Guide for Windows 10.md
Created May 4, 2022 11:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AnanthaRajuC/082649186f22fb3ea8416e4e2d0ba422 to your computer and use it in GitHub Desktop.
Save AnanthaRajuC/082649186f22fb3ea8416e4e2d0ba422 to your computer and use it in GitHub Desktop.
Download ZIP
This is a guide for apache superset(0.35.2) installation on Windows 10.
Raw
Apache Superset-0.35.2--Installation Guide for Windows 10.md

System Requirements

  1. Apache Superset requires Python evironment. Install Python 3.6.
  2. Install Microsoft Visual C++ 14.0 with Build Tools for Visual Studio 2019. Make sure the following tools are selected.
    • MSVC v142 - VS 2019 C++ x64/x86 build tools (v14.24)
    • Windows 10 SDK (10.0.18362.0)

Requirements and Environment Set-Up

The below steps are used to setup the environment

  1. Open Command Prompt in Administrator Mode move to C:\
  2. Check whether your python installation contains pip package and It should be above version 20.0.2. Check version by using following cmd 
    pip -V
    If pip version is not 20.0.2, then download get-pip.py, and run python get-pip.py
  3. Superset stores database connection information in its metadata database. For that purpose, we use Cryptography Library which is a Python library to encrypt connection passwords. This library has OS level dependencies, so to install this admin previleges is neccesary. Run this command. 
    pip install cryptography
  4. It is recommended to install Superset inside a virtualenv. Python 3 already ships virtualenv. But if it’s not installed in your environment for some reason, you can install it from pip. Run this command. 
    pip install virtualenv
  5. You can create and activate a virtualenv by: 
    python3 -m venv venv
venv\Scripts\activate
    Once you activated your virtualenv everything you are doing is confined inside the virtualenv.If you wish to deactivate virtual environment, run this command. 
    venv\Scripts\deactivate
  6. Put all the chances on your side by getting the very latest pip and setuptools libraries. 
    pip install --upgrade setuptools pip
    Make sure the setuptools and pip are present. -setuptools in c:\venv\lib\site-packages (46.0.0) -pip in c:\venv\lib\site-packages (20.0.2)

Superset installation and initialization.

Please type the following commands inside the virtual environment. Follow these few simple steps to install Superset:

  1. Install superset 
    pip install apache-superset
  2. Install DB Drivers. I am using MS SQL Server and based on your database requirement. Select the pypi package from here 
    pip install pymssql
  3. Initialize the database 
    cd venv
python3 Scripts\superset db upgrade
  4. Create an admin user (you will be prompted to set a username, first and last name before setting a password) 
    cd ..
set FLASK_APP=superset
flask fab create-admin
cd venv
  5. Load some data to play with 
    python3 Scripts\superset load_examples
  6. Create default roles and permissions 
    python3 Scripts\superset init
  7. To start a development web server on port 8088, use -p to bind to another port 
    python3 Scripts\superset run -p 8088 --with-threads --reload –debugger
    After installation, you should be able to point your browser to the right hostname:port http://localhost:8088, login using the credential you entered while creating the admin account, and navigate to Menu -> Admin -> Refresh Metadata. This action should bring in all of your datasources for Superset to be aware of, and they should show up in Menu -> Datasources, from where you can start playing with your data!

References:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment