System tables for DLT Expectations Quality Metrics

vamsi_simbus — Mon, 17 Nov 2025 07:07:16 GMT

Hi Everyone,

I’m working with Delta Live Tables (DLT) and using Expectations to track data quality, but I’m having trouble finding where the expectation quality metrics are stored in the DLT system tables.

My questions are:

Which specific system table(s) contain DLT expectation metrics?
Are these metrics available per expectation, per table, or only at the pipeline level?
Is there a sample query for retrieving these metrics?

If anyone has a working example or documentation pointer, I’d really appreciate it!

Thanks in advance!

Re: System tables for DLT Expectations Quality Metrics

ManojkMohan — Mon, 17 Nov 2025 07:56:26 GMT

@vamsi_simbus DLT captures data quality metrics in specialized system tables known as “event” and “metrics” tables. Specifically, look in the following table:

LIVE.DLT_EVENT_LOG or LIVE.DLT_METRICS: These tables contain granular event logs and metrics, including per-expectation data quality results for each table within your DLT pipeline. https://docs.databricks.com/aws/en/ldp/expectations

The metrics are available not only at the pipeline level but also for individual expectations applied to specific tables https://community.databricks.com/t5/technical-blog/monitoring-dlt-pipeline-performance-and-best-practices/ba-p/118220

Example

Replace LIVE.DLT_EVENT_LOG with the correct schema as used in your environment.
Columns such as table_name, expectation_name, num_violations, and violation_percentage will provide insight into data quality

topic System tables for DLT Expectations Quality Metrics in Data Engineering

System tables for DLT Expectations Quality Metrics

Re: System tables for DLT Expectations Quality Metrics