removing
-
Safely Removing Column-Level Masking from a Production Unity Catalog Table
POST_START Safely Removing Column-Level Masking from a Production Unity Catalog Table Safely Removing Column-Level Masking from a Production Unity Catalog Table I’ve been working on a project where we needed to update a customer email column in our production table to remove column-level masking. The table in question is production.customers.customer_master, and the column we’re focusing…
A1, category:business, category:education, category:software, category:technology, coding, column-level, data engineering, data governance, databricks, education, Lakehouse, masking, 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, safely, sql, table, unity catalog -
Safely Removing Row-Level Security from a Production Unity Catalog Table
POST_START Safely Removing Row-Level Security from a Production Unity Catalog Table The Problem I recently inherited a table in the production environment that had row-level security (RLS) applied to it. The table was production.sales.customers, and it was used by multiple teams for reporting and analytics. While the RLS was initially implemented to enforce data access…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, 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, removing, row-level, safely, security, sql, table, unity catalog -
Removing Production Unity Catalog RBAC Privileges During User or Team Offboarding
POST_START Removing Production Unity Catalog RBAC Privileges During User or Team Offboarding I recently had to handle the offboarding of a data engineering team from our production environment. One of the critical steps in this process was ensuring that all team members no longer had access to sensitive data and systems. As part of the…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, during, education, Lakehouse, offboarding, 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, rbac, removing, sql, team, unity catalog, user -
Removing All Rows While Preserving a Table with TRUNCATE
POST_START <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Removing All Rows While Preserving a Table with TRUNCATE</title> </head> <body> <h1>Removing All Rows While Preserving a Table with TRUNCATE</h1> <p>I recently had a need to clear out all the data from a table while keeping the table structure intact. The table in question was <code>training.sales.customer_master</code>, and I…
(all), A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, preserving, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, removing, rows, sql, table, truncate, unity catalog, while
