Ashwin_DSA
Databricks Employee
Databricks Employee

Hi @IM_01,

event_log(TABLE(...)) always returns the entire pipeline’s event log, not just rows for that one dataset. Passing a table is just a shortcut to find the owning pipeline. It doesn’t filter the log to that table.

To restrict to a specific table like customers_summary_mv, add an explicit filter on the flow name (and usually event type). Sample given below.

SELECT *
FROM event_log(TABLE(workspace.default.customers_summary_mv))
WHERE event_type = 'flow_progress'
  AND origin.flow_name = 'customers_summary_mv';
What are you looking for?  Expectation metrics for that table?
 

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***