audit
-
End-to-End Production Access Investigation from Namespace to Audit Trail
POST_START End-to-End Production Access Investigation from Namespace to Audit Trail I recently needed to investigate access to the production catalog in Databricks Unity Catalog. My goal was to understand who had access to what, what actions they could perform, and how their interactions were recorded in the audit trail. This is a common task when…
A1, Access, audit, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, End-to-End, investigation, Lakehouse, namespace, paragraph ordering, paragraph structure, paragraphorder, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, trail, unity catalog -
Investigating User Activity Against a Production Table with Audit Logs
POST_START Investigating User Activity Against a Production Table with Audit Logs I recently needed to investigate user activity against a production table in our data warehouse. The table in question was production.sales.orders, and I wanted to understand who had accessed it, what actions they performed, and when. Since we use Databricks Unity Catalog for access…
A1, Activity, against, audit, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, investigating, Lakehouse, logs, paragraph ordering, paragraph structure, paragraphorder, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, table, unity catalog, user -
Databricks SQL: Audit Effective Grants with SHOW GRANTS
Databricks SQL: Audit Effective Grants with SHOW GRANTS Tutorial Databricks SQL: Audit Effective Grants with SHOW GRANTS This tutorial demonstrates how to use the `SHOW GRANTS` command in Databricks SQL to audit effective grants on a table. We’ll progress through three scripts, each focusing on a slightly more complex scenario. Script 1: Basic Grant Audit…
A1, audit, category:computer, category:data cable, category:education, category:software, coding, data engineering, databricks, databricks sql, delta lake, education, Effective, grants, paragraph ordering, paragraph structure, paragraphorder, profession:data analyst, profession:data engineer, profession:data scientist, profession:linguist, profession:student, profession:teacher, profession:translator, progressive learning, Show, sql, sql engineering
