Superset Clickhouse Testing

Dummy data for testing:

-- CREATE TABLE sales_table
-- (
-- id Int32,
-- sale_date Date,
-- sales Float64
-- )
-- ENGINE = MergeTree()
-- ORDER BY id;
-- INSERT INTO sales_table (id, sale_date, sales) VALUES
-- (1, '2026-01-01', 100.50),
-- (2, '2026-01-02', 200.75),
-- (3, '2026-01-03', 150.00),
-- (4, '2026-01-04', 300.25),
-- (5, '2026-01-05', 250.10);
SELECT * from default.sales_table;

SQLAlchemy URI:

clickhousedb://default:@newsuz-0.newsuz.harshith.svc.cluster.local:8123/default

Create a dataset

SQL LAB / Editor

Example line chart