Tableau vs Metabase

Quick verdict

Tableau is a visual analytics platform owned by Salesforce. Authors build workbooks in Tableau Desktop (Windows and macOS) or in the browser, and publish them to Tableau Cloud or self-hosted Tableau Server on Windows or Linux. Licences are role based: Creator, Explorer and Viewer. Tableau Public is free for public data, and Tableau Next is sold through the Tableau+ bundle.

Metabase is a browser-based BI tool. The open source edition is released under the AGPL and paid editions use the Metabase Commercial Software License. It runs as a Java JAR or Docker container, or as Metabase Cloud. Business users build questions with a graphical query builder, analysts write SQL in the native query editor, and curated models act as reusable starting points. Paid plans (Starter, Pro, Enterprise) add hosting, SSO, row and column permissions and advanced embedding.

Side by side

Key differences

Who builds the analysis

Tableau is built for analysts who explore data visually: dragging fields onto shelves, combining marks, building dashboards with fine layout control, and writing calculated fields and level of detail expressions. The Creator role includes Tableau Desktop and Tableau Prep Builder; Explorers edit in the browser on published data; Viewers interact.

Metabase aims at self-service by people who are not BI specialists. The query builder lets a business user filter, summarise and join without SQL, analysts can drop into SQL, and both can save results to dashboards and collections. In our assessment, Metabase covers common operational dashboards with far less setup, while Tableau gives more room for complex, highly designed analysis.

Working in SQL

In Metabase, SQL is a first-class path. The native editor runs a single read query, with variables and optional clauses for filter widgets, snippets for reuse, and references to saved questions and models. Metabase documents that it does not run multiple statements, stored procedures or DDL.

-- Metabase native query (PostgreSQL), with an optional variable
SELECT date_trunc('month', created_at) AS month,
       count(*) AS orders
FROM orders
WHERE 1 = 1
[[AND created_at >= {{start_date}}]]
GROUP BY 1
ORDER BY 1;

In Tableau, custom SQL defines a data source rather than a chart. Tableau documents that it must be a single SELECT, that Tableau wraps it in an outer query to add filters and grouping, and that parameters can replace literal values only. Most logic then moves into Tableau calculations, for example a FIXED level of detail expression, {FIXED [Region] : SUM([Sales])}, which a SQL user can read as a grouped subquery joined back to the detail rows.

Licensing and cost model

Tableau charges per role on annual contracts, with Standard and Enterprise editions and documented Display, usage-based and capacity-based options. Every deployment needs at least one Creator. Cost grows with the number of named users.

Metabase is free with unlimited users on the self-hosted open source edition, where your costs are the server, the application database and the people who run them. Paid plans include a number of users and charge for each additional user; Metabase counts embedded users of your product as users too. SSO, row and column-level permissions and SSO-based embedding are on Pro and Enterprise.

Deployment and embedding

Tableau Server runs on Windows or Linux; Tableau Cloud removes the hosting work. The Embedding API v3 embeds views and web authoring through a <tableau-viz> web component.

Metabase is a single Java application; Metabase recommends running the JAR on a supported JRE or using Docker, with PostgreSQL or MySQL as the production application database rather than the default embedded H2. Public links, guest (signed) embeds and full-app embedding are available on all plans including open source; modular embedding with SSO, advanced theming and data segregation need Pro or Enterprise. Note the AGPL obligations if you modify the open source code and offer it to others over a network.

Pricing and licensing

Tableau. Tableau publishes per-role list prices (Creator, Explorer, Viewer, billed annually) on its pricing page, which we could not load to confirm, so we do not quote them; check them there. Creator is the most expensive role, Enterprise edition costs more than Standard, and Tableau+ and the usage-based and capacity-based options are quoted by sales. Tableau Public is free for public data.

Metabase. The open source edition is free. Listed on Metabase's pricing page in October 2026 (USD): Pro at USD 575 per month (or USD 6,210 per year) with 10 users included, then USD 12 per extra user per month. Starter is a lower-priced plan with 5 users included, Enterprise is a custom quote, and Starter and Pro have a 14-day free trial. Optional usage-based add-ons are billed separately.

Pricing checked on the vendors' official pages on 7 October 2026. Prices change; confirm before buying.

Where each one leads

Limitations

When to choose each

When neither is right

• You want an open source tool with a full SQL IDE and many chart types: see Metabase vs Apache Superset.
• Your organisation runs on Microsoft 365: see Power BI vs Tableau and Power BI vs Metabase.
• You want governed metrics defined in code: see Tableau vs Looker.
• You want associative exploration with capacity-based pricing: see Qlik Sense vs Tableau.

Final recommendation

Frequently asked questions

Sources

• Metabase pricing
• Metabase: connecting to databases
• Metabase: SQL editor
• Metabase: embedding overview
• Metabase: running the JAR file
• Metabase on GitHub (licences)
• Tableau help: Understanding license models
• Tableau technical specifications
• Tableau help: Connect to a custom SQL query
• Tableau help: FIXED level of detail expressions
• Tableau Embedding API v3
• Salesforce: Tableau Next

Checked October 2026.

How we research comparisons: our editorial method.