Verbose logging

alex_svyatets
New Contributor II

Hello! I want audit access to some delta tables in unity catalog from jobs and notebooks. We enabled audit verbose logging. But not all queries that were run from notebooks are  written to system.access.audit, column_lineage and table_lineage tables

MadhuB
Valued Contributor

@alex_svyatetsFrom my understanding, audit logs only capture events or queries that involve UC managed objects. In cases where a Delta table is accessed directly via its file path instead of its registered table name, the query may not be logged. Similarly, queries involving temporary views might not appear in the audit. It is also important that clusters should be UC enabled by default.

Could you provide specific examples of queries that are not being logged?

alex_svyatets
New Contributor II

It are queries to registered table name.