SUPERSET

Apache Superset vs Metabase

Srini Kadamati

Open Source Business Intelligence

Data visualization and BI tools are essential for any modern organization to make fast, data-driven decisions. With a wide range of visualization tools available to choose from, it's important to know what makes each platform unique. After Databricks acquired Redash, Metabase and Apache Superset were the last two popular open-source business intelligence platforms left.

Although most BI platforms allow you to create data visualizations, perform complicated data analysis, and build interactive dashboards, open source BI tools offer even more benefits. Whether you're looking for cost effectiveness, customizability, wide-spread community support, enhanced security, or future-proofing features, open source BI is the way to go. And, with that in mind, Apache Superset is the most popular open source BI tool in the world (by Github stars).

In this post, we'll showcase where Metabase shines and struggles in comparison to Preset Cloud / Superset.

What is Preset Cloud?

Preset's founder and CEO is Max Beauchemin, the original creator of Apache Superset. At Preset, we're the experts of Superset and are proud to be the leading vendor offering Apache Superset as a cloud hosted service. In addition to all of the features that Superset has out of the box, Preset Cloud offers the following:

  • Preset Manager: The admin layer that lets you deploy multiple Superset workspaces in one click and manage user access permissions using role-based access control (RBAC).
  • Documentation & Training: The Preset team maintains high quality end-user focused documentation and offers live training and office hours.
  • Authentication, Data Security, and Network Security: Preset Cloud is SOC2 Type 2 compliant and offers security features such as single sign-on (SSO), SSH tunneling, SCIM integration, row-level security, and Managed Private Cloud for paid teams.
  • World-class Support: teams on a paid tier get access to our dedicated email and chat support.

Data Sources

The Superset community enjoys the benefit of being a project housed in the Apache Software Foundation. The barrier to contributing is low and the Superset community has added support for new databases at a breakneck pace.

Category Metabase Superset
SQL databases & engines 15 39
NoSQL databases 1 (MongoDB) 0 (possible through Trino / Presto)

Evaluate popular analytics software tools such as Apache Superset, Tableau, Looker, and more.

No-code Query Builder

Feature Metabase Superset
Support common SQL operations (Select, Filter, GroupBy, etc)
Preview visualization during iteration
Preview generated SQL query during iteration
View data transformation results as a table
Use virtual datasets to build charts
Ability to join tables

Both Metabase and Superset have no-code interfaces for crafting SQL queries.

Visualization Features

Business intelligence tools are only as good as the visualizations they enable.

Feature Metabase Superset
Common charts (pie, line, bar, etc)
Funnel visualizations
Sankey diagrams
Network visualization
Clear documentation on adding your own visualizations
Number of default charts 17 40 (and growing 📈)
Number of geospatial visualizations 3 10
Configuration options (e.g., tooltips, colors) Limited Robust
Custom charts (via plugins)

Similar to how the Superset community helped drive support for over 20 databases, they've also been the driving force behind the large array of visualizations in Superset. This is no surprise, since Superset's contributor community is significantly larger than Metabase's.

Advanced SQL Editor

Feature Metabase Superset
Export query results as CSV
Database metadata explorer
Linting and auto-complete
Support for variables in SQL queries
Multi-tab workflow
Save query for re-use
Semantic layer: save queries as virtual datasets
Semantic layer: define custom metrics
Semantic layer: calculated columns

Both Metabase and Superset ship with a powerful SQL editor and a lightweight semantic layer.

  1. Aggregate values across multiple columns and publish as Metrics.
  2. Metrics can be certified as authoritative by a specific user.
  3. Transform specific columns and publish as Calculated Columns.
  4. Write arbitrary SQL queries and publish as a Virtual Dataset.

In the no-code chart builder (Explore), metrics, columns, and virtual datasets all inherit the power that physical database tables have in Superset.

Feature Metabase Superset
Basic datetime, value, and range filters
Dashboard templating
Custom theming
Dashboard can contain charts from multiple data sources
Cross-filtering
Data drilling (drill-down, drill by)
Organization and configuration Limited Robust

Superset is widely known for the beautiful charts and interactive dashboards you can create quickly. Here's an example that's a community favorite:

Apache Superset slack dashboard

Enterprise Features

While you can customize enterprise features on Superset, Preset Cloud makes it easier to configure them from its UI. Below makes the comparison of key enterprise features between Metabase and Preset Cloud.

Category Feature Metabase Preset Cloud
Admin Multiple workspace deployment
Admin Usage and audit logs
Admin Admin API
Authentication Single sign-on (SSO)
Authentication SCIM integration
Data security Data connection via SSH Tunnels
Data security Row level security
Hosting SaaS cloud option
Hosting Self-hosted / on-prem deployment ✅ (Superset)
Hosting Hybrid deployment
Integration Integration with transformation layer
Product Embedded
User access Chart or dashboard level permissioning
User access Workspace level RBAC (role-based access control)
User access Viewer-only mode
User access Custom workspace roles (In development)

Preset extends Superset by adding powerful enterprise features. The following graphic helps visualize the differences:

Preset Crust

Conclusion

Whichever BI vendor you end up choosing, we strongly recommend choosing one that's built on open source.

If you'd like to try Superset, Preset Cloud offers a free-forever tier for you to try out all the bells and whistles in a hassle-free way.

Preset Cloud is now generally available for anyone to use and we're excited to launch with a free-forever tier. You can get started for free here!

Subscribe to our blog updates

Receive a weekly digest of new blog posts

Close