Install superset on Windows with WSL and docker


It connects to various data sources, supporting real-time data analysis. Superset is efficient with large data sets, provides advanced SQL querying capabilities, and facilitates collaboration by allowing users to share insights easily.
It's designed for data professionals seeking a customizable and comprehensive visualization tool.
Unfortunately, Superset doesn't support Windows directly. In this article, I'll show you how we can install and use Superset on a Windows machine.
Go to Control Panel > Programs and Features > Turn Windows Features on or off.

Activate the Windows Subsystem for Linux.

Visit the Microsoft Store and install the latest version of Ubuntu.

Upon installation, the command prompt will open, prompting you for a UNIX username and password

Set Password for root user
sudo su
This will ask for the current user password & switch to
rootuser
passwd
This will ask you to set password for
rootuser
Let's explore the Ubuntu file system we've just installed. In Windows Explorer,
paste \\wsl$ into the address bar and press Enter.

This might take a moment, depending on your system.

By default, this directory appears in the terminal when you launch Ubuntu.

Install Docker Desktop, then navigate to Docker settings. Enable integration with my default WSL distro and Enable integration with additional distros, where your Ubuntu version will appear.

Launch Ubuntu from the Start menu.

Execute docker -v

If all steps were followed correctly, you should see the expected output.
If there's an error, revisit step 5

To check your current location in Ubuntu, run ls -a

Clone Apache Superset with
git clone --depth=1 https://github.com/apache/superset.git
- The
--depth=1argument insures a shallow clone meaning only the most recent commit will be cloned, hence it will be faster.- You can remove it if you want to clone the entire repository

After cloning, enter the Superset directory using
cd superset

Start Docker and launch Apache Superset by running
Option #1 - for an interactive development environment
docker compose up --build
The
--buildargument insures all the layers are up-to-date
Option #2 - build a set of immutable images from the local branch
sudo docker compose -f docker-compose-non-dev.yml up -d

This process may take some time.
Once completed, you can access the interface at http://localhost:8088/
The default username and password are both admin.
You should also see a new container in Docker Desktop.

Follow the instructions of this image to open superset in your browser

The default username and password are both admin.

For further documentation, refer to Apache Superset Documentation
To edit code, open another Ubuntu terminal and execute
code .

This will download the necessary packages and open the codebase in VS Code.

To stop the container, run
docker compose down

Now, if you check your Docker Desktop, you should see the container stopped.


The complete guide to running pgAdmin 4 Web in WSL. Learn how to install, configure, and connect to your PostgreSQL database directly from your Windows browser.

Tired of missing VS Code extensions in remote projects? Learn 4 easy ways to sync your local extensions to SSH, WSL, and Docker environments automatically.

Stuck with SQLite errors in Superset? Learn why your metadata DB is locked and how to fix it permanently by migrating to PostgreSQL.