Skip to main content
ClickHouse and Metabase Integration

​
Task 2 Overview: Real-Time Analytics with ClickHouse

In this task, you’ll learn how to build a real-time analytics pipeline using ClickHouse, Kafka, and Metabase. You’ll deploy ClickHouse as both a server and client, ingest streaming data, and create interactive visualizations.

​
Learning Objectives

  • Deploy ClickHouse server and client
  • Integrate ClickHouse with Kafka for real-time streaming
  • Create materialized views for data processing
  • Connect ClickHouse to Metabase for visualization
  • Build interactive dashboards with geospatial data

​
ClickHouse Installation and Setup

​
Install ClickHouse

First, we need to install DuckDB to our Codespaces. DuckDB runs almost anywhere and it’s very easy to install.
Visit the ClickHouse quickstart page for installation instructions.For Codespaces, you can typically install it using:
curl https://clickhouse.com/ | sh

​
Start the ClickHouse Server

./clickhouse server

​
Test the ClickHouse Client

Test that ClickHouse is working correctly. 
# Connect to ClickHouse
./clickhouse client

-- Test basic queries
SELECT version();
SELECT currentDatabase();
SHOW DATABASES;
⌘I