Preset logo
ANNOUNCEMENTS

Apache Superset 6.0 Release

Evan Rusackas
12 min read
2,303 words

We're thrilled to announce Apache Superset 6.0, a major release that represents the most significant visual and architectural transformation in Superset's history. This release delivers a complete design system overhaul with Ant Design v5, comprehensive dark mode support, powerful new features for data exploration, and hundreds of quality-of-life improvements that make Superset more intuitive and performant than ever before.

With contributions from 155 contributors including 101 first-time contributors, this release demonstrates the vibrant growth of the Superset community. The 6.0 release includes over 1,000 pull requests spanning major architectural improvements, new features, enhanced theming, and extensive bug fixes.

As usual, it's worth noting that Preset customers have already had much of this available to them, as we release at a more frequent cadence than the official Superset releases. We're constantly cherry-picking fixes and small features into our release branch. As of now, all customers have access to ALL the 6.0.0 features and fixes.

Download & Resources

It's also worth noting that you (yes, you!) can be a part of helping to shape, test, and vote on release candidates to help them along. Release management discussions happen regularly in both synchronous discussions available to anyone via the Superset Community Calendar, and asynchronously on Slack in the #release-feedback-and-questions channel. Releases are voted on via the Superset Dev mailing list, which you can subscribe to by sending an email to dev-subscribe@superset.apache.org.

Highlights

Complete Design System Overhaul with Ant Design v5

The most transformative change in Superset 6.0 is the migration to Ant Design v5's token-based theming system (#31590). This six-month effort touched 1,267 files and completely eliminated Bootstrap and Font Awesome dependencies, unlocking first-class dark mode support and dynamic theming capabilities.

The new theming architecture replaces hardcoded colors with semantic tokens, enabling administrators to customize Superset's appearance through a comprehensive theme management UI (#34182, #34560). Themes can be created, edited, imported, exported, and applied system-wide or per-dashboard, with full support for dark mode across all visualizations.

The new theme administration interface provides visual management with clear indicators—sun and moon icons denote system default and dark themes respectively. Administrators can set system themes through action menus, with confirmation dialogs ensuring deliberate changes and protection preventing deletion of active system themes.

If you want to learn more about theming in Preset and/or Superset, you can read more on the Preset Docs. There are even a few sample themes you can try on for size!

URL Prefix Support for Flexible Deployments

Superset can now be deployed under URL prefixes like /analytics or /superset (#30134), a critical capability for organizations running multiple applications behind reverse proxies. This feature enables cleaner multi-tenant deployments and better integration with existing application ecosystems.

Dataset Folders for Better Organization

A new hierarchical folder system for datasets (#32520, #32680, #33104) allows users to organize metrics and columns into logical groups within the Explore view. This addresses the long-standing 50-item display limitation and makes working with complex datasets much more manageable.

Security Groups (SIP-152 Phase 1)

User group-based access control is now available (#32121), enabling simplified permission management by assigning roles to groups rather than individual users. This provides group-based access control for databases, datasources, and schemas, significantly reducing administrative overhead in large organizations.

Advanced Table Chart with AG Grid

A new Table Chart V2 powered by AG Grid (#33517) supports up to 500,000 rows with server-side pagination, sorting, and search capabilities. This dramatically improves performance for large datasets while reducing browser memory consumption. The new table includes time comparison with shift controls, percentage metrics, conditional formatting, cell bars, column rearrangement, and full cross-filtering support for dashboard interactivity. Enable it with the FEATURE_AG_GRID_TABLE_ENABLED feature flag.

Enhanced Deck.gl Visualizations

Deck.gl charts received major upgrades including cross-filtering support (#33789), individual layer selection in FilterScope (#33769), OpenStreetMap as the default tile provider (#33603), and dynamic color controls with breakpoints (#34017).

Gantt Chart Visualization

A new native Gantt chart plugin (#33716) enables timeline visualizations for project management, event sequences, and temporal data analysis.

Improved Filter Experience

Native filters received extensive enhancements including "Exclude Filter Values" (#33054), improved slider controls (#33170), "Select all visible" functionality (#33043), and circular dependency prevention (#35317). The horizontal filter bar is now the default layout (#32317).

The new "Exclude Filter Values" feature transforms the static "Inverse Selection" checkbox into an interactive dropdown, allowing users to toggle between "IS" and "IS NOT" logic at runtime without reconfiguring filters.

Async Database Permission Sync

Database permission synchronization now runs asynchronously (#32231), preventing API server resource exhaustion when dealing with large schemas and enabling users to trigger re-sync operations without editing database connections.

Enhanced Embedded SDK

The embedded SDK gained critical new features including drill-to-detail support (#34319), data mask event emission (#31331), dynamic theme configuration (#34273), and configurable referrer policy (#32735).

Chart & Visualization Improvements

Time Series Charts

  • "Group remaining as Others" for series limit (#34308)
  • X-axis interval control for all ticks (#33729)
  • Configurable query identifiers for Mixed Timeseries (#34406)
  • Improved legend positioning and theming (#35123)
  • Better time shift color matching (#35826)

Big Number Charts

  • Toggleable comparison values (#28605)
  • Metric name display option (#33013, #33099)
  • Aggregation method selector (#32767)
  • None aggregation option (#33407)

Table Charts

  • Percentage metric calculation modes (#33656)
  • Server-side pagination, sorting, and search (#33357)
  • Time shift override support (#33947)
  • Excel export without index column (#32366)
  • Cell bar theming for dark mode (#35211)

Other Chart Enhancements

  • Pie chart "Threshold for Other" (#33348)
  • Heatmap customizable borders (#32358)
  • Box plot new parameter sets (#32170)
  • Pivot table pivoted Excel export (#33569)
  • Histogram NULL handling (#35693)
  • Bar chart label positioning fixes (#32849)

Dashboard Enhancements

A new confirmation modal now alerts users about unsaved changes when navigating away from Dashboard Edit mode or Explore, preventing accidental data loss (#33809). The dashboard editor also gained working undo/redo buttons for layout changes (#34777), making it easier to experiment with dashboard layouts.

Additional improvements:

  • Filter bar closed by default option (#32870)
  • Improved tab refresh behavior (#35265)
  • Better anchor link positioning (#34843)
  • Markdown edit mode improvements (#35336)
  • Chart background "Solid" option (#34655)
  • Cross-filter persistence fixes (#35998)

SQL Lab Updates

  • Template parameter persistence in saved datasets (#33195)
  • Format SQL and view in SQL Lab from Explore (#33341)
  • Query History improvements with real-time updates (#36359)
  • Better error handling and validation display (#35969)
  • Improved theme consistency (#34675)
  • Enhanced table schema view (#35341)

Performance & Reliability

  • Frontend bootstrap data caching (#31996)
  • Explore popover rendering optimization (#33501)
  • Async buildQuery support (#34383)
  • Chart properties modal performance (#34079, #34097)
  • Reduced unnecessary chart re-renders (#34874)
  • SupersetClient retry on 502-504 errors (#34290)
  • Catalog permission sync optimization (#33000)
  • Slack channels caching (#32529)

Security & Infrastructure

  • Python 3.12 support (#33434)
  • Flask-AppBuilder 5.0 upgrade (#33055)
  • Expanded disallowed SQL functions (#33084)
  • UUID support in REST APIs (#29573)
  • Enhanced Jinja macros: current_user_roles() (#32770), to_datetime (#32781), current_user_rls_rules() (#33614)
  • Customizable user agent (#32506)
  • Security manager improvements (#32340, #33577)

Database Support Improvements

  • TDengine driver support (#32041)
  • SingleStore engine specification (#32887)
  • BigQuery latest partition support (#30760)
  • ClickHouse dynamic schema support (#32610)
  • DuckDB catalog support (#28751)
  • Databricks string escaping fixes (#34180, #34991)
  • Doris catalog improvements (#34140)
  • Dremio sqlglot dialect (#33847)
  • Improved Athena, Pinot, DB2, and Impala support

Migration from SQLParse to SQLGlot

A major architectural improvement throughout 6.0 was the complete migration from the sqlparse library to sqlglot (#33542, #33564). This enables more robust SQL analysis, better dialect support, and improved query manipulation capabilities. The migration included implementations for limit extraction, CTEs, RLS, CVAS/CTAS, and adhoc subquery validation.

Upgrading to 6.0

Please review the full UPDATING.md for detailed upgrade instructions. Key changes to be aware of:

Authentication Changes

Flask-AppBuilder 5.0 (#33055): The AUTH_OID authentication type has been deprecated and is no longer available. OpenID (OID) is considered a deprecated authentication protocol. If you are using AUTH_OID, you must migrate to an alternative authentication method such as OAuth, LDAP, or database authentication before upgrading.

Security Views Migration (#32432): The List Roles FAB view has moved to the frontend and requires FAB_ADD_SECURITY_API to be enabled in your configuration. Run superset init after upgrading.

Embedded Drill Features (#34319): Drill to Detail and Drill By are now supported in Embedded mode and with DASHBOARD_RBAC. If you don't want to expose these features, ensure the roles used for Embedded/DASHBOARD_RBAC don't have the required permissions to perform D2D actions.

Theming & UI Changes

New Theming System (#31590): The THEME_OVERRIDES configuration is deprecated in favor of the new AntD v5-based theming system. This may require updates to your custom theming configurations.

Environment Tag Colors (#34536): ENVIRONMENT_TAG_CONFIG color values have changed to support only Ant Design semantic colors. Update your superset_config.py:

  • Change "error.base" to just "error"
  • Change any hex color values to one of: "success", "processing", "error", "warning", "default"
  • Custom colors are no longer supported

Horizontal Filter Bar (#32317): The horizontal filter bar is now the default and the HORIZONTAL_FILTER_BAR feature flag has been removed.

Docker & Deployment Changes

Chromium Not Included by Default (#34258): The default Docker image no longer includes Chromium (headless browser). Set the build arg INCLUDE_CHROMIUM=true if you need screenshot and report capabilities.

Tiled Screenshots (#34561): Playwright-based reports now use tiled screenshots for large dashboards (20+ charts or height exceeding 5000px). Pillow is now a required dependency (previously optional). The thumbnails optional dependency is deprecated and will be removed in 7.0.

Data & Export Changes

Dataset Export Filenames (#34782): Dataset exports now include the dataset ID in their filename. If managing assets as code, rename existing dataset YAMLs to include the ID to avoid duplicated files.

CSV Export Encoding (#34235): CSV exports now use utf-8-sig encoding by default to include a UTF-8 BOM, improving Excel compatibility.

Chart & Query Changes

X-Axis Sort Properties Renamed (#33116): In ECharts Series charts (Line, Area, Bar, etc.), x_axis_sort_series and x_axis_sort_series_ascending have been renamed to x_axis_sort and x_axis_sort_asc. A migration is included that may affect existing charts.

Expanded Disallowed SQL Functions (#33084): The DISALLOWED_SQL_FUNCTIONS configuration now includes additional potentially sensitive database functions across PostgreSQL, MySQL, SQLite, MS SQL Server, and ClickHouse. Review your SQL Lab queries and dashboards if you encounter "disallowed function" errors.

Map Tile Provider Change

OpenStreetMap Default (#34204): OpenStreetMap is now the default tile provider for Deck.gl visualizations (no API key required). If you have Mapbox configured and want to continue using it, follow the map tiles documentation.

Other Breaking Changes

  • Rockset: Database support removed due to product discontinuation (#33929)
  • Jest Test Environment (#34871): MessageChannel is now mocked in test environment to prevent Jest hanging (test environment only, no production impact)

Internationalization

  • Persian (Farsi) translations (#29580)
  • Polish language support (#31506)
  • Catalan translations (#33953)
  • Traditional Chinese (zh_TW) support (#33192)
  • Updated Italian, Portuguese (Brazil), French, Spanish, Russian, and Japanese translations

Dependency Updates

This release includes comprehensive dependency updates:

  • Node.js: Upgraded to v20.18.3
  • PostgreSQL: Docker images now use PostgreSQL 16
  • AG Grid: Updated to v34 with tree-shaking support
  • PyArrow: Upgraded to 18.1.0 (later versions supported)
  • Reselect: Upgraded to 5.1.1
  • Marshmallow-SQLAlchemy: Updated to 1.4.0
  • URLLib3: Upgraded to v2 for security fixes
  • Jest: Migrated to v30
  • Pandas: Updated to 2.1.4 minimum for Python 3.12 support
  • Hundreds of frontend dependency updates for security and performance

Contributors

This release was made possible by 155 contributors:

0xasritha, 125m125, AdalbertMemSQL, AdrianKoszalka, Antonio-RiveroMartnez, Bierbarbar, CharlesNkdl, ChrisChinchilla, CodeWithEmad, DamianPendrak, Dev10-34, DuanKuanJun, EmmanuelCbd, EnxDev, Eric-Brison, FelipeGLopez, GhaziTriki, Habeeb556, HarshithGamini, Joel-Haeberli, LevisNgigi, LisaHusband, MohamedHalat, ObservabilityTeam, Ookong, Pedro-Gato, PedroMartinSteenstrup, PolinaFam, Quatters, Radovenchyk, RealGreenDragon, SBIN2010, Sameerali0, SkinnyPigeon, Usiel, Vitor-Avila, WLCFaro, abhinav-1305, ag-ramachandran, aikawa-ohno, alexandrusoare, alveifbklsiu259, amaannawab923, amineBouilzmin, aminghadersohi, anmol-hpe, anthonyhungnguyen, arafoperata, asher-lab, bensku, bestlong, betodealmeida, bmaquet, brandon-kaplan, castodius, catpineapple, cbausaonebox, cbum-dev, clayheaton, codenamelxl, dankor, denodo-research-labs, dnskr, dogfootruler-kr, dpgaspar, drummerwolli, ekansh-shipmnts, eriks47, eschutho, ethan-l-geotab, fardin-developer, felipegranado, fhyy, gabotorresruiz, geido, gerbermichi, giuliosmall, guenp, hainenber, hamirmahal, harikirank, hugo19941994, hverlin, hzxa21, imcewen02, innovark37, irodriguez-nebustream, janani-gurram, jansule, jdorel, jobenjada, jonathanmv, jpchev, jqqin, junyoneyama, justinpark, kalai-logicsoft, kasiazjc, kgabryje, kidusmakonnen, landryb, lohart13, lourduradjou, luizotavio32, mPyKen, marcosmamorim, martimors, martyngigg, marunrun, mdusmanalvi, michael-s-molina, mistercrunch, mkramer5454, msyavuz, natilehrer, ngokturkkarli, nicob3y, nilmonto, omahs, ompharate, ongdisheng, oscep, payose, personofnorank, phillipleblanc, plavacquery, polRk, prochac, rad-pat, rebenitez1802, richardfogaca, rusackas, rytis-ulys, sadpandajoe, schollz, sfirke, sha174n, tahvane1, tarraschk, tjain-singlestore, trentlavoie, trentontrees, tshallenberger, tuantran0910, ved-kashyap-samsung, vedantprajapati, villebro, withnale, xavier-GitHub76, xneg, yong1le, yousoph, ysinghc

First-Time Contributors

Special recognition to our 101 first-time contributors: 0xasritha, 125m125, AdalbertMemSQL, AdrianKoszalka, Bierbarbar, CharlesNkdl, ChrisChinchilla, Dev10-34, DuanKuanJun, Eric-Brison, FelipeGLopez, GhaziTriki, HarshithGamini, Joel-Haeberli, LisaHusband, MohamedHalat, Ookong, Pedro-Gato, PedroMartinSteenstrup, PolinaFam, Radovenchyk, RealGreenDragon, Sameerali0, WLCFaro, abhinav-1305, ag-ramachandran, alveifbklsiu259, amaannawab923, amineBouilzmin, anmol-hpe, anthonyhungnguyen, arafoperata, asher-lab, bensku, bmaquet, brandon-kaplan, castodius, catpineapple, cbausaonebox, cbum-dev, clayheaton, dankor, dogfootruler-kr, ekansh-shipmnts, eriks47, ethan-l-geotab, felipegranado, fhyy, gabotorresruiz, giuliosmall, hamirmahal, harikirank, hugo19941994, hverlin, hzxa21, imcewen02, innovark37, irodriguez-nebustream, janani-gurram, jdorel, jobenjada, jonathanmv, jqqin, junyoneyama, kalai-logicsoft, kidusmakonnen, landryb, lourduradjou, mPyKen, marcosmamorim, marunrun, mdusmanalvi, natilehrer, ngokturkkarli, nilmonto, omahs, ompharate, ongdisheng, personofnorank, phillipleblanc, plavacquery, polRk, prochac, rad-pat, rebenitez1802, rytis-ulys, schollz, trentlavoie, trentontrees, tshallenberger, tuantran0910, yong1le

Get Involved

Interested in contributing to Apache Superset? Here's how to get started:

Again, we welcome contributions, or help with testing/voting our future releases through. If you have any questions, please don't hesitate to reach out on Slack.

What's Next

This is certainly far from the end of where things are going. We're currently steering toward multiple release targets as we publish this update.

  • Superset 6.0.1, featuring several bug fixes, already has a first release candidate built, and is up for a vote. Please test it out and provide votes/feedback!
  • Superset 6.1.0 is also "under construction" and will have a lot of new features centered around our evolving Extensions framework.
  • Superset 7.0.0 might be quite a ways off, but we're already building toward a number of SIPs that are shaping up to make Apache Superset (and Preset!) the most forward-looking, flexible, and powerful BI platform on the planet. Stay tuned for more updates!

Thank you to everyone who contributed to making Superset 6.0 our most ambitious release yet! Happy theming!

All the features of Superset (and more) without the hassles of scaling/managing/upgrading, with plenty of time to grow into it. Free for five users, forever.

Related Reading

Subscribe to our blog updates

Receive a weekly digest of new blog posts

Close