sql
-
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 -
Transferring Production Table Ownership to a Platform Administration Group
POST_START Transferring Production Table Ownership to a Platform Administration Group I recently had the task of transferring ownership of a production table from its current owner to a platform administration group. This was part of a broader initiative to centralize governance and ensure that all production tables are managed by a dedicated team. The table…
A1, administration, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, group, Lakehouse, ownership, paragraph ordering, paragraph structure, paragraphorder, Platform, 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, transferring, unity catalog -
Building Least-Privilege Analyst Access to a Production Sales Table
POST_START Building Least-Privilege Analyst Access to a Production Sales Table I recently had the task of granting analysts access to a production sales table while ensuring that they had the minimum necessary privileges. This was a critical step in maintaining data security and compliance within our organization. I started by understanding the structure of the…
A1, Access, analyst, building, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, least-privilege, 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, sales, sql, table, unity catalog
