26.5M 건의 외환 틱, 밀리초 단위로 답한다.
90분 실습 랩: 오브젝트 스토리지에서 약 26.5M 건의 외환 틱을 로드하고, 실제 시장 분석 쿼리를 실행하고, 내장 AI Assistant와 Agents를 사용해 봅니다. 본인의 데이터로 실시간 대시보드를 만드는 선택 과정도 있습니다.
What you will do
Create a free ClickHouse Cloud service and open the SQL Console — about five minutes, and the only prerequisite for everything that follows.
One CREATE TABLE for 26.5M forex ticks, and why base and quote lead the sort key — the decision you will feel in module 04.
The same 26.5M ticks loaded twice: ClickPipes, the managed pipeline you would use in production, then the s3() one-liner — and when to reach for which.
Seven queries against 26.5M ticks, each replacing a page of SQL: approximate counts, topK, OHLC candlesticks, percentiles, -If combinators, argMax, and the sort key finale.
Hand the full-scan query from module 04 to the ClickHouse Assistant and watch it diagnose the missing sort key, then offer a skip index and a projection with ready-to-run SQL.
Point ClickHouse Agents at the service you just loaded and ask questions in natural language — it writes the SQL, runs it, and draws the chart.
Run a containerised dashboard on your laptop against your own ClickHouse Cloud service, and watch the query time and rows scanned change as you filter.
Where to take the trial next, and the fallbacks for anything that went wrong along the way.