Governance
-
Delegating Governance Administration with MANAGE Instead of Ownership Transfer
POST_START Delegating Governance Administration with MANAGE Instead of Ownership Transfer I recently needed to delegate governance responsibilities for a table in our data lake. The table, production.sales.orders, was being used by multiple teams, and the current owners were overwhelmed with managing access and compliance. I decided to explore the MANAGE privilege as a way to…
A1, administration, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, delegating, education, Governance, instead, Lakehouse, manage, ownership, 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, transfer, unity catalog -
Masking Multiple PII Columns with Separate Governance Functions
POST_START Masking Multiple PII Columns with Separate Governance Functions I recently had the task of masking multiple Personally Identifiable Information (PII) columns in the customer master table. The goal was to ensure that sensitive data like phone numbers and emails were only accessible to authorized users. I decided to use Unity Catalog’s masking capabilities along…
A1, category:business, category:education, category:software, category:technology, coding, columns, data engineering, data governance, databricks, education, Functions, Governance, Lakehouse, masking, multiple, paragraph ordering, paragraph structure, paragraphorder, pii, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, separate, sql, unity catalog -
Documenting a Production Table and Sensitive Column for Governance Review
POST_START Documenting a Production Table and Sensitive Column for Governance Review I recently took on the responsibility of ensuring that our production data assets are properly documented for governance review. One of the key tables in our system is the customer_master table in the production.customers schema. This table holds the core customer information, and it’s…
A1, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, documenting, education, Governance, 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, review, sensitive, sql, table, 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
