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

[noorbasha534]

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?

[Vidhi_Khaitan]

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.

[noorbasha534]

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