topic Re: Is there a way to see Job/Workflow in the lineage of a table/view in Administration & Architecture

Is there a way to see Job/Workflow in the lineage of a table/view

noorbasha534 — Sat, 28 Jun 2025 22:45:35 GMT

Hi all

One frequent question I get from the data users is - how often a view is refreshed? ((users are given access to views not tables))

I was thinking to guide them to leverage lineage for the same. However, I noticed the lineage tab in the catalog explorer displays jobs in the tabular view but not in the graph view.

My idea is to let users click on the underlying table of the view first, then check the job that processes that table, and check its run schedule.

On a side note, other than lineage and the challenge written above, any other ideas to to meet the user need?

Re: Is there a way to see Job/Workflow in the lineage of a table/view

Vidhi_Khaitan — Mon, 30 Jun 2025 09:11:55 GMT

Hi team,

I believe the lineage UI graph view may not surface job details—these may only appear in the tabular view.

However, for materialized views (MVs), Databricks stores refresh metadata such as the timestamp of the last refresh and other properties (e.g., UP_TO_DATE, REFRESH_MODE). Users with SELECT privilege on a view may see these in the output of metadata queries, depending on configuration.

Re: Is there a way to see Job/Workflow in the lineage of a table/view

noorbasha534 — Mon, 30 Jun 2025 13:44:54 GMT

@Vidhi_Khaitan the user wants to know the frequency of the schedule, not whether the view/table is fresh...