Code Breakfast: Materialize with Metabase to implement real-time dashboards

Traditionally, performing real-time analytics on streams of data has been perceived as something hard that requires some skills that are difficult to find. You can build these skills yourself, of course, but imagine that you could do complex streaming analytics just writing a few lines of SQL and forget about Java or Scala.

That is what Materialize brings, an easy way to perform analytics on top of streams of data or continuously changing transactional databases. With Materialize, you can even combine streams of data in real-time, perform aggregations, and even publish your results to another topic to be consumed by a downstream service. In this real-time coding session, we will set up a local Materialize instance using Docker, subscribe to a stream of data and perform real-time analytics on it!

After that, we’ll be using Metabase, an open source data visualization tool, to display some real-time visuals on top of the Materialize views.