Free & Open Source Software

Today was one of the most fulfilling days for me in a long time. I got to do one of my absolute favorite things and that was to do a technical deep dive into software. Today it was Apache Superset! ♾️

Associate Staff @ MIT Lincoln Laboratory | Analyst | Architect | Engineer

USD Coin

Beyond fulfilling all requirements, I gained valuable insights into several unique aspects of the application. For instance, it is platform-independent and can run on Linux, macOS, and Windows systems by leveraging Docker for deployment. When a file is uploaded, Superset automatically loads the data into a PostgreSQL database. Out of the box, Superset provides a wide variety of visualization options—including correlation, flow, distribution graphs, maps, and ranking visualizations. One noteworthy edge case involves column names that conflict with SQL keywords. To avoid errors in such cases, the column names must be wrapped in quotes. 🔍