From column-oriented, distributed data in Apache Druid, to insights in Metabase
If you’re using Druid, you’re probably looking for a business intelligence tool that can keep up with massive quantities of time-series and event data. Metabase lets your whole team visualize and explore your data in Apache Druid with or without SQL. Run native queries on nested data and scale indefinitely.
- Analyze vast amounts of data with a querying layer that sits on top of your data warehouse so your reports run as quick as Druid.
- Metabase lets everyone in your team visualize, query, and run reports without technical skills or needing to ask your data team for help.
Easy-to-use data exploration tools for people of all levels
Get a BI tool with friendly UX that lets everyone make sense of your data in Druid.
- Query data in plain English with Metabot, your AI data assistant. Chat with your database, generate and debug SQL, get AI-generated summaries on charts, and more
- Interactive dashboards that load as fast as Druid does with click-to-explore functionality.
- Click to drill through on interactive charts and dashboards, zoom in on timelines or areas of interest, and break out for more context on a specific area.
- Ask questions with nothing more than clicks in the Query Builder—no SQL required (or use the SQL editor if that’s more your style).
- Set up models and metrics to give less technical teammates metadata-rich starting points, with trickier stuff like joins taken care of.
Give data access with granularity
Keep everyone in their own lane.
- Granular permissions for viewing and querying data, so people can see (and do) what they need to and nothing else.
- Map permissions to user groups and attributes with SSO.
- Detailed usage analytics lets you see who did what when.
Lots of options for sharing charts and dashboards with your team—or your customers
With as much interactivity and room to pull threads (or as little) as you want.
- Customer-facing analytics is just a snippet away. Embed all of Metabase in your app, or just a dashboard.
- Export charts and dashboards to PDF, CSV, or share via a public link.
- Set up subscriptions for regularly scheduled updates. Even to people without a Metabase login.
- Get alerts when things change unexpectedly.
Keep your data in Druid
Metabase runs queries directly in Druid, so your reports are always up-to-date.
Metabase features with Druid
Available with all data sources
- Unlimited queries, charts, and dashboards
- Send dashboards and reports via email and Slack
- Connect to multiple data sources and integrations
- Single sign on via SAML, LDAP, or JWT
- Interactive embedding with white label customization
- Granular row- and column level permissions
Not available with Druid
- Pivot tables
- Data segregation
- Saved questions as data sources
See all features
Keep everything in your own cluster
Self-host Metabase and Druid to keep everything on your terms. Get your token and go. Both are open source, with optional cloud-hosting.
Frequently asked questions
Metabase is one of the only business intelligence tools that allows you to work with Druid without a custom connector. Most business intelligence tools are designed to work with tabular, row-and-column data.
Metabase is the most effective way to let everyone in the team start working with data. * Because of sophisticated but easy-to-use data tools like the query builder, which lets people ask questions without SQL, Metabase has a low learning curve. Simple drill-through, zoom-in, and breakout functionality lets people learn more from data with just a few clicks.
You can set up and connect Metabase to Druid in about 5 minutes and begin querying immediately, with drill-through functionality automatically generated and ready for people to start uncovering insights. Metabase is also open source and affordable, with plans and pricing that scales with you.
You can connect to Druid when you’re setting up a new Metabase instance, or add a database connection any time in your admin settings.
You can connect your Metabase to Druid by using Metabase fields to input your connection details.
To add a database connection, click on the gear icon in the top right, and navigate to Admin settings > Databases > Add a database.
For the full details on connecting Metabase to Druid, check out our documentation.
Druid permissions can't be impersonated in Metabase. (This is currently possible for PostgreSQL, Redshift, ClickHouse, and Snowflake databases).
With granular row-level permissions and user group mapping, you can effectively set up permissions to match those applied in Druid.
Metabase fits with Druid as a querying and visualization layer on top of your data. With Metabase you can query data in Druid - with or without SQL - to create a broad range of data visualizations and types and tell a story with interactive dashboards. Viewers can filter and drill-through to get what’s most relevant, and dig deeper on what’s important to them. Visualizations and dashboards can even be shared or embedded in your app.
Druid lets you store and analyze non-tabular, distributed data sets - but you’ll likely need pretty advanced data and technical skills to be able to do it.
Metabase makes it possible for everyone in the team to run their own reports, without data skills or relying on someone else to write SQL for them. People used to working in Excel can leverage skills usually reserved for spreadsheets to get the answers they need from data in Druid.
Metabase lets you bring together charts, visualizations, and questions into interactive dashboards that can be shared with your team and customers.
The automatically generated drill-through menu lets people click on charts to zero in on a particular category or parameter for further analysis; view individual records, or zoom in on a targeted date range. You can also add filters to let people slice the data on what’s most important to them, and add custom-click behaviors to guide data discovery (e.g. send people to a related dashboard).