Data visualization with GreptimeDB and Metabase

In today's data-driven world, organizations are flooded with time-series data, but making sense of this information to drive real business insights can be challenging. That's where powerful business intelligence (BI) tools like Metabase come in.

Metabase is a powerful, open-source business intelligence and analytics tool that empowers organizations to explore and visualize their data with ease. It offers a user-friendly interface for creating interactive dashboards, charts, and reports without requiring extensive technical knowledge.

By pairing GreptimeDB with Metabase, users can effortlessly visualize, query, and analyze their time-series data, making it easier to understand system performance, user behavior, and trends.

Thanks to the SQL based interface and compatibility with Postgres wire protocol, we are able to create a Metabase driver for GreptimeDB with little effort. This driver allows you to add GreptimeDB as a database in Metabase, and create queries and visualizations.

How to Connect GreptimeDB with Metabase ​

Download the Plugin ​

To install the plugin, you can download the packaged jar file from the release page.

Install the Plugin ​

When you finish downloading the plgin, place it in plugins/ directory of your metabase workspace.

Configure GreptimeDB in Metabase ​

From the admin settings or setup guide, you will be able to select GreptimeDB from Database type and access the connection information. This driver works for both self-managed GreptimeDB and fully managed instances from GreptimeCloud.

You can find more information from our docs about the connection details.

Once you add the database, Metabase will scan and cache table information from it.

Query Data from GreptimeDB Tables

Then you are ready to create queries from these tables.

This driver plugin is also open sourced and available from github.

If you are new to Metabase, we have a Metabase docker image that includes our plugin by default:

docker pull greptime/metabase-greptimedb:latest
docker run -p 3000:3000 greptime/metabase-greptimedb:latest

This integration allows users to fully leverage the capabilities of GreptimeDB for real-time time-series data analysis. With Metabase’s user-friendly dashboards and GreptimeDB’s high-performance storage, you can seamlessly monitor system trends and optimize business operations without needing in-depth technical expertise.

Conclusion ​

We are excited to see how you utilize GreptimeDB and Metabase to supercharge your data insights. Whether you're visualizing system metrics or tracking user activity, this integration opens up new possibilities. At Greptime, we are dedicated to building a strong ecosystem around time-series data storage and analysis. We welcome your feedback on new integrations that can further enrich the value of our solutions. If you have any question or suggestion, we'd love to hear your thoughts - reach out to us or joining our community Slack.

About Greptime ​

We help industries that generate large amounts of time-series data, such as Connected Vehicles (CV), IoT, and Observability, to efficiently uncover the hidden value of data in real-time.

Visit the latest version from any device to get started and get the most out of your data.

• GreptimeDB, written in Rust, is a distributed, open-source, time-series database designed for scalability, efficiency, and powerful analytics.
• Edge-Cloud Integrated TSDB is designed for the unique demands of edge storage and compute in IoT. It tackles the exponential growth of edge data by integrating a multimodal edge-side database with cloud-based GreptimeDB Enterprise. This combination reduces traffic, computing, and storage costs while enhancing data timeliness and business insights.
• GreptimeCloud is a fully-managed cloud database-as-a-service (DBaaS) solution built on GreptimeDB. It efficiently supports applications in fields such as observability, IoT, and finance.

Star us on GitHub or join GreptimeDB Community on Slack to get connected. Also, you can go to our contribution page to find some interesting issues to start with.