Skip to main content

Datadog Metrics Reference

This page lists Onehouse metrics that are exposed to Datadog when you follow the Datadog integration setup steps. These are the same metrics that power the pre-built Onehouse Grafana dashboards in Advanced Monitoring, surfaced through the Spark driver's OpenMetrics endpoint at http://<driver>:9091/metrics (namespace onehouse in Datadog).

Metric naming

DeltaStreamer (ingestion) jobs emit metrics with the ohds_ prefix. SQL cluster jobs emit the equivalent per-action metrics with the ohsql_ prefix. The action source (deltastreamer, deltacommit, compaction, replacecommit, clean) follows the prefix, then the metric suffix. Each metric carries table and database labels so you can filter and aggregate per table.

DeltaStreamer Metrics

Track ingestion lag, sync timing, and failures.

DescriptionMetric Name
Number of Kafka source messages pending to be ingestedohds_deltastreamer_kafkaDelayCount
Number of consecutive sync lagsohds_deltastreamer_numConsecutiveSyncLags
Sync Frequencyohds_deltastreamer_syncIntervalSecs
Sync Durationohds_deltastreamer_syncDurationSecs
Absolute time of the last syncohds_deltastreamer_lastSync
Number of sync failuresohds_deltastreamer_numFailedCommits

Write Stats

Track records and bytes written by ingestion commits.

DescriptionMetric Name
Total bytes writtenohds_deltacommit_totalBytesWritten
Records Written over timeohds_deltacommit_totalRecordsWritten
Records Upserted Over Timeohds_deltacommit_totalUpdateRecordsWritten
Records Inserted Over Timeohds_deltacommit_totalInsertRecordsWritten
Total Number of Records Deletedohds_deltacommit_totalRecordsDeleted
Total partitions written in Ingestion Commitsohds_deltacommit_totalPartitionsWritten

Compaction Metrics

Track compaction service runs.

DescriptionMetric Name
Time taken by Compaction Commitsohds_compaction_duration
Number of bytes compacted by Compaction Commitsohds_compaction_totalBytesWritten
Number of partitions touched by Compaction Commitsohds_compaction_totalPartitionsWritten

Clustering Stats

Track clustering service runs.

DescriptionMetric Name
Time taken by Clustering Commitsohds_replacecommit_duration
Total Bytes Written by Clustering Commitsohds_replacecommit_totalBytesWritten
Total Partitions Written By Clustering Commitsohds_replacecommit_totalPartitionsWritten

Cleaner Service Stats

Track cleaner service runs.

DescriptionMetric Name
Cleaner Durationohds_clean_duration
Number of Clean Files Deletedohds_clean_numFilesDeleted

SQL Cluster Metrics

SQL clusters emit the same per-action write, compaction, clustering, and cleaner metrics as OneFlow, but with the ohsql_ prefix instead of ohds_. Use these to monitor table-level activity driven by SQL workloads.

DescriptionMetric Name
Total bytes written by SQL commitsohsql_deltacommit_totalBytesWritten
Records written over time by SQL commitsohsql_deltacommit_totalRecordsWritten
Records upserted over time by SQL commitsohsql_deltacommit_totalUpdateRecordsWritten
Records inserted over time by SQL commitsohsql_deltacommit_totalInsertRecordsWritten
Total number of records deleted by SQL commitsohsql_deltacommit_totalRecordsDeleted
Total partitions written by SQL commitsohsql_deltacommit_totalPartitionsWritten
Time taken by SQL Compaction Commitsohsql_compaction_duration
Number of bytes compacted by SQL Compaction Commitsohsql_compaction_totalBytesWritten
Number of partitions touched by SQL Compaction Commitsohsql_compaction_totalPartitionsWritten
Time taken by SQL Clustering Commitsohsql_replacecommit_duration
Total bytes written by SQL Clustering Commitsohsql_replacecommit_totalBytesWritten
Total partitions written by SQL Clustering Commitsohsql_replacecommit_totalPartitionsWritten
SQL Cleaner Durationohsql_clean_duration
Number of Clean Files Deleted by SQL Cleanerohsql_clean_numFilesDeleted
note

SQL clusters do not emit ohsql_deltastreamer_* family. Use Copy-On-Write equivalents (ohsql_commit_*) if your SQL workloads write to COW tables.

If you need additional metrics beyond the ones listed here, file a support ticket with Onehouse.