sql
-
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 -
Combining Row Filtering and Column Masking on the Same Customer Table
POST_START Combining Row Filtering and Column Masking on the Same Customer Table I recently had the task of securing sensitive customer data in our production environment. The goal was to ensure that only authorized users could access specific rows and columns in the customer table. I decided to implement both row filtering and column masking…
A1, category:business, category:education, category:software, category:technology, coding, column, combining, customer, data engineering, data governance, databricks, education, filtering, Lakehouse, masking, 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, same, sql, table, unity catalog -
Rolling Back a Production Column Mask After Policy Testing
POST_START Rolling Back a Production Column Mask After Policy Testing I recently had to roll back a column mask on a production table after completing a policy testing phase. The table in question was production.customers.customer_master, and the column that was masked was email. I needed to verify the current state of the table, remove the…
A1, after, Back,, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, Lakehouse, mask, paragraph ordering, paragraph structure, paragraphorder, policy, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, rolling, sql, Testing, unity catalog -
Masking Customer Email Addresses for Non-Privileged Users
POST_START Masking Customer Email Addresses for Non-Privileged Users I recently had the task of ensuring that customer email addresses are masked for non-privileged users in our data lake. The goal was to maintain data privacy while still allowing team members with the right access to view the full email addresses. I decided to use Databricks…
A1, addresses, category:business, category:education, category:software, category:technology, coding, customer, data engineering, data governance, databricks, education, email, Lakehouse, masking, non-privileged, 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, users -
Removing a Row Filter During a Controlled Security Policy Rollback
POST_START Removing a Row Filter During a Controlled Security Policy Rollback I recently had to roll back a security policy that had been applied to a critical table in our data warehouse. The policy had introduced a row filter that restricted access to certain customer records. Now, as part of a controlled rollback, I needed…
A1, category:business, category:education, category:software, category:technology, coding, controlled, data engineering, data governance, databricks, during, education, filter, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, policy, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, removing, rollback, row, security, sql, unity catalog -
Transferring a Production Schema to a Governed Owner Group
POST_START Transferring a Production Schema to a Governed Owner Group I recently had the task of transferring a production schema from its current owner group to a more governed owner group within our Databricks Unity Catalog. This was part of a larger initiative to ensure that all production schemas are managed by a centralized team…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, governed, group, Lakehouse, owner, 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, schema, sql, transferring, unity catalog
