Open-source alternative to Looker

Metabase is a free, open-source Looker alternative that turns your business data into dashboards without code. Looker is sold on custom quotes for large companies; self-hosted Metabase has no per-viewer price.

1 alternative Free app Our pick: Metabase

At a glance

App Good for Code Import from Looker Ease of use
Metabase Teams that want shared dashboards without hiring a data analyst Code Open source Import from Looker No Some setup

Why look for an alternative to Looker?

Looker is Google Cloud's business intelligence platform. Data teams describe their data once in LookML, its modelling language, and the rest of the company explores it through dashboards and reports.

Teams look for an alternative because Looker is built and priced for larger companies: it is sold through Google Cloud sales on a platform licence plus users, and it needs someone who knows LookML to set up and maintain. Small and mid-sized teams often only need dashboards and answers from their own database. A self-hosted tool such as Metabase does that for no licence cost and no price per viewer, and is usually set up in an afternoon.

How Metabase compares

Turn your business data into charts your whole team can use.

Answers most of the questions teams use Looker for, with charts, dashboards, filters and scheduled reports, but without a modelling language to learn. Anyone can build a question from menus, and analysts can write SQL. It has no central semantic layer as rich as LookML.

Some setup Open source · AGPL-3.0-only

Moving from Looker

There is no import from Looker. Connect Metabase to the same database or warehouse Looker reads, then rebuild your most-used dashboards first; logic that lived in LookML becomes Metabase models, metrics and saved SQL questions. Most teams find a handful of dashboards cover what people actually open each week.

Questions

What is the best open-source alternative to Looker?

Metabase is the free, open-source alternative to Looker for business dashboards in the catalogue today. Answers most of the questions teams use Looker for, with charts, dashboards, filters and scheduled reports, but without a modelling language to learn. Anyone can build a question from menus, and analysts can write SQL. It has no central semantic layer as rich as LookML.

Does Metabase work with BigQuery, Snowflake and Redshift?

Yes. Metabase connects to BigQuery, Snowflake, Redshift, PostgreSQL, MySQL and many other databases.

Do I need to know SQL to use Metabase?

No. Its question builder works from menus, and SQL is there when you want it.

Is it really free?

Yes, the app is free. To run them you need Cloudgate and a server. Use hosted Cloudgate, which can also provide the server, or install Cloudgate on a server of your own for free. Cloudgate's plans and prices are at cloudgate.octabyte.io/pricing. One server can run several apps.

Do I need a developer?

No. Cloudgate installs the app on your server and gives it a secure web address. You use it in your browser.