The Guide for Time Series Data Projects is out.

Download now
Skip to content

Introduction to Time Series Visualization in CrateDB and Explo


Welcome to an insightful exploration of the integration between CrateDB and Explo, two powerful tools that can transform your data handling and visualization processes. In this blog post, we will delve into the capabilities of CrateDB, an open-source distributed SQL database designed for efficient management of structured and semi-structured data. Additionally, we will uncover the potential of Explo, a dynamic data visualization tool that enables the creation of interactive dashboards without the need for coding.

CrateDB offers exceptional scalability, allowing you to handle large volumes of data with ease. Its distributed architecture ensures optimal performance and seamless scalability, making it an ideal choice for managing various data types and the best choice as a time-series database.

Explo, on the other hand, simplifies the process of creating visually compelling dashboards. With its user-friendly interface and no-code approach, developers and business analysts can easily craft interactive visualizations that provide valuable insights into the underlying data.

By integrating CrateDB with Explo, you can leverage the strengths of both tools. CrateDB's robust data management capabilities and efficient querying can be seamlessly combined with Explo's dynamic visualization features, enabling real-time data visualizations that adapt as the data evolves.

Throughout this blog post, we will explore the integration process and highlight the benefits it brings. From scalability and versatility to user-friendliness and real-time insights, the integration of CrateDB and Explo opens up new possibilities for efficient data handling and impactful visualizations.

So, let's embark on this journey together and discover how the integration of CrateDB and Explo can revolutionize your data management and visualization practices.

Step 1: Install and Set up CrateDB and Explo

Before integrating, you need to have both CrateDB and Explo installed and set up. To sign up for an account with CrateDB's cloud offering, you may go here. To sign up for an Explo account, go here.

Step 2: Get Credentials from CrateDB

To get credentials from CrateDB, go to the javascript section of "Connecting to your cluster" and get the host, port, user and password.

CrateDB and Explo1

Step 3: Establish a Connection from CrateDB to Explo

Once both platforms are set up, you can establish a connection from CrateDB to Explo. In the Explo dashboard, go to the 'Data' tab and choose 'Connect Datasource'. Choose 'CrateDB' as your database, fill in your CrateDB credentials and establish the connection.

CrateDB and Explo2

CrateDB and Explo 3

Step 4: Create CrateDB Dashboard

Once your data is imported, you can start creating dashboards. Navigate to the 'Dashboards' tab and click 'Create Dashboard'.

CrateDB and Explo4

Step 5: Write SQL

In the dashboard, write SQL to access your data. Click 'Save and Run' to see a sample of your data.

CrateDB and Explo 5

Step 6: Create a Chart

Visualize your data via a chart in Explo. Drag on a chart, select the dataset to create a visualization from, define the x-axis and y-axis for the chart, then watch as you created your first visual from raw warehouse data!

CrateDB and Explo 6

CrateDB and Explo 7

Step 7: Embed in Your Application

CrateDB and Explo 7

CrateDB and Explo 8


In conclusion, the integration of CrateDB and Explo presents an exciting opportunity to enhance your data handling and visualization capabilities. By harnessing the power of CrateDB's scalable and efficient data management, combined with Explo's user-friendly dashboarding features, you can unlock the full potential of your data.

With CrateDB, you can seamlessly manage and query structured and semi-structured data, including time-series and IoT data, while Explo empowers you to create interactive and visually captivating dashboards without the need for coding expertise. Together, these tools offer a comprehensive solution for handling, analyzing, and visualizing data in real-time.

The benefits of this integration are vast. From the scalability and versatility of CrateDB to the user-friendly nature of Explo, you gain the ability to extract valuable insights, customize visualizations, and make data-driven decisions effortlessly. With live connections and real-time updates, you can stay up-to-date with the evolving nature of your data, ensuring that your visualizations are always accurate and relevant.

By embracing the integration of CrateDB and Explo, you embark on a path of data-driven excellence, where the power of efficient data management merges seamlessly with captivating visualizations. Empower your team, unlock new insights, and drive impactful decision-making with this powerful combination of tools.

So, don't hesitate to explore the possibilities that await you through the integration of CrateDB and Explo. Embrace the future of data handling and visualization, and unleash the true potential of your data.