Question

A data engineer at a healthcare company needs to determine which downstream tables and dashboards would be affected if a source table containing patient records is modified. The company uses Unity Catalog to govern all data assets. Which Unity Catalog capability should the engineer use to identify these downstream dependencies?

Accepted Answer

Data lineage, which automatically captures upstream and downstream relationships across tables, columns, notebooks, and dashboards

Answer

The GRANT statement, which lists all principals who currently have SELECT on the table

Answer

DESCRIBE HISTORY, which returns the transaction log of operations performed on the table

Answer

Dynamic view functions, which mask sensitive columns based on the querying user's group