Install superset on Windows with WSL and docker

Apache Superset is an open-source platform for data visualization and exploration, offering an intuitive web interface for creating interactive dashboards and charts.

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.

1. Go to Control Panel > Programs and Features > Turn Windows Features on or off. Activate the Windows Subsystem for Linux.
2. Visit the Microsoft Store and install the latest version of Ubuntu.
3. Upon installation, the command prompt will open, prompting you for a UNIX username and password
4. 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.
5. 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.
6. Launch Ubuntu from the Start menu.
7. Execute docker -vIf all steps were followed correctly, you should see the expected output.
8. If there's an error, revisit step 5
9. To check your current location in Ubuntu, run ls -a
10. Clone Apache Superset with

    git clone https://github.com/apache/superset.git

    
11. After cloning, enter the Superset directory using cd superset
12. Start Docker and launch Apache Superset by running

    sudo docker-compose -f docker-compose-non-dev.yml up -d

    This process may take some time.
13. 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.
14. To monitor user requests in the Ubuntu terminal, execute

    docker-compose -f docker-compose-non-dev.yml up

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

    code .

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