category:technology
-
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 -
Auditing Production Catalog Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Catalog Privileges Through INFORMATION_SCHEMA I recently needed to audit the privileges assigned to the production catalog in our Databricks environment. This was part of a routine security review to ensure that only authorized users had access to sensitive data. I decided to use the INFORMATION_SCHEMA to get a clear and structured view…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, through, unity catalog -
Auditing Production Table Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Table Privileges Through INFORMATION_SCHEMA Today, I needed to audit the privileges assigned to a specific table in the production environment. The table in question was orders from the sales schema. My goal was to understand who has access to this table and what kind of privileges they hold. I decided to use…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, table, through, unity catalog -
Auditing Production Schema Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Schema Privileges Through INFORMATION_SCHEMA I recently needed to audit the privileges assigned to the sales schema in the production catalog. This is a common task when ensuring that only authorized users have access to sensitive or critical data. I decided to use the INFORMATION_SCHEMA to get a clear and structured view of…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, through, unity catalog -
Removing an Obsolete Governance Tag from a Production Table
POST_START Removing an Obsolete Governance Tag from a Production Table I recently had to address an outdated governance tag on a production table in our data lake. The table, production.customers.customer_master, was marked with a legacy_classification tag that was no longer relevant. My task was to remove this tag and verify that it was successfully removed.…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Governance, Lakehouse, obsolete, 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, removing, sql, table, tag, unity catalog -
Granting Controlled Execute Access to a Governance Function
POST_START Granting Controlled Execute Access to a Governance Function I recently had the task of granting controlled access to a governance function within our Unity Catalog setup. The goal was to ensure that only specific teams could execute a function called region_filter while maintaining strict access controls. I needed to follow a precise process to…
A1, Access, category:business, category:education, category:software, category:technology, coding, controlled, data engineering, data governance, databricks, education, execute, function, Governance, granting, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, unity catalog -
Inspecting Security Functions Used by Row Filters and Column Masks
POST_START Inspecting Security Functions Used by Row Filters and Column Masks I recently had the task of understanding how security functions are applied to our data in the production environment. As part of this, I needed to inspect the row filters and column masks that are used to control access to sensitive information. I started…
A1, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, filters, Functions, inspecting, Lakehouse, masks, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, row, security, sql, unity catalog, Used
