What you will learn in this TP
- Configure the ClickHouse exporter
- Write SQL analyses
- Speed up with a materialised view
Introduction #
What you will learn in this section
- Configure the ClickHouse exporter
- Write SQL analyses
- Speed up with a materialised view
Context. Your data team wants to combine telemetry with its own ClickHouse tables. You set up direct OpenTelemetry ingestion and demonstrate the value of SQL.
Prerequisites: Docker Compose · Estimated time: 50 min
Telemetry in ClickHouse, queryable with SQL.Setup #
Guided steps, with their solutions.
1. Write the Compose file
Why? ClickHouse and a contrib Collector are all you need.
Create the Compose file and the Collector configuration.2. Generate data
Why? Traces from two services and a few errors give you something to analyse.
Send traces for two services, some of them with errors.3. Explore the schema
Why? Know the columns before writing queries.
List the tables created and describeotel_traces.4. Analyse in SQL
Why? Analytical queries answer operational questions in a single line.
Calculate, per service, the number of spans, the error rate and the p95 latency.5. Materialised view and compression
Why? A pre-aggregated view makes dashboards instant; compression justifies choosing ClickHouse.
Create a per-minute materialised view, send traces again, query the view, then measure compression.
Difficulty level : ●●●●○ (4/5)
My progress
Sign in to track your progress and take notes. Sign in
Recommended Articles
Analyser l'expérience utilisateur dans Dynatrace : sessions, traces, analyses et USQL
Exploiter les données d'expérience utilisateur (DEM) : Apdex et Core Web Vitals, sessions utilisa...
Collector OpenTelemetry : connecteurs, extensions et observabilité du Collector
Aller plus loin avec le Collector : connecteurs (spanmetrics, servicegraph, count, routing, failo...
Architecture OpenTelemetry : Comprendre les 3 niveaux
Plongée au cœur de l'architecture OpenTelemetry. Apprenez comment les données circulent de l'appl...
OpenTelemetry sur Kubernetes : Operator, auto-instrumentation et Collector
Déployer OpenTelemetry sur Kubernetes : modes de déploiement du Collector (DaemonSet, Deployment,...
OpenTelemetry Collector : les Processors (transformer, filtrer et protéger la télémétrie)
Maîtriser les processors du Collector OpenTelemetry : batch, memory_limiter, attributes, resource...
OpenTelemetry et Dynatrace : OTLP, collecteur et instrumentation
Intégrer OpenTelemetry à Dynatrace : endpoint OTLP et jetons, Dynatrace OTel Collector, traces, m...
Bindplane : gérer ses pipelines de télémétrie OpenTelemetry
Comprendre Bindplane : plan de contrôle des collecteurs OpenTelemetry via OpAMP, BDOT Collector, ...
Corréler traces, métriques, logs et profils avec OpenTelemetry
Relier les quatre signaux pour diagnostiquer vite : ressource commune, trace_id dans les logs, ex...
Les profils, le quatrième signal d'OpenTelemetry : profilage continu et corrélation avec les traces
Comprendre le nouveau signal profile d'OpenTelemetry : profilage continu, flame graphs, modèle de...