investigating
-
Investigating a Production Table Rename Through Object Discovery
POST_START Investigating a Production Table Rename Through Object Discovery Today, I was tasked with investigating a recent table rename in the production environment. The team had renamed a table from orders to orders_archive, and I needed to verify that the change was correctly applied and understand the impact on the system. I started by checking…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, discovery, education, investigating, Lakehouse, object, 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, rename, sql, table, through, unity catalog -
Investigating a Specific User During a Production Access Incident
POST_START Investigating a Specific User During a Production Access Incident I was called in to investigate a potential access incident involving a user with the email address engineer@example.com. The incident report mentioned that a user might have accessed production data, and I needed to trace their activity using Databricks Unity Catalog’s audit logs. I started…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, during, education, incident, investigating, Lakehouse, 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, Specific, sql, unity catalog, user -
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 -
Investigating Revoked Production Access Still Reported by a Consumer
POST_START Investigating Revoked Production Access Still Reported by a Consumer I recently encountered an issue where a consumer reported they were still able to access data in the production catalog, even though their access had been revoked. I needed to investigate why this was happening. To start, I decided to look at the grants assigned…
A1, Access, category:business, category:education, category:software, category:technology, coding, consumer, data engineering, data governance, databricks, education, investigating, Lakehouse, 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, reported, revoked, sql, still, unity catalog -
Investigating Unexpected Production Volume Write Access
POST_START Investigating Unexpected Production Volume Write Access Today, I was tasked with investigating an unexpected production volume write access issue. A team member reported that some data in the production.files.documents volume was being written to without proper authorization. My goal was to determine who had access and whether any unauthorized writes had occurred. Checking Volume…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, investigating, Lakehouse, 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, Unexpected, unity catalog, Volume., Write
