security
-
End-to-End Production Security Review for Row and Column Protection
POST_START End-to-End Production Security Review for Row and Column Protection I recently had the opportunity to perform a comprehensive security review of a customer data pipeline in Databricks Unity Catalog. The goal was to ensure that both row-level and column-level data protection were properly implemented and enforced. I started by understanding the functions and tables…
A1, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, End-to-End, 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, protection, review, row, security, 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 -
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 -
Auditing Security Function Ownership Used by Row Filters
POST_START Auditing Security Function Ownership Used by Row Filters I recently had to audit the security ownership of a row filter function used in our production environment. The function, production.security.region_filter, is used to enforce regional access controls across multiple datasets. My goal was to understand who owns the function and what permissions are granted on…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, filters, function, Lakehouse, 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, row, security, sql, unity catalog, Used -
Auditing Security Function Ownership Used by Column Masks
POST_START Auditing Security Function Ownership Used by Column Masks I recently had to audit the security function ownership used by column masks in our Databricks Unity Catalog environment. The goal was to ensure that the functions used for data masking were properly secured and that only authorized users had access to them. I started by…
A1, auditing, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, function, Lakehouse, masks, 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, security, sql, unity catalog, Used -
Designing Department-Based Row-Level Security for Enterprise Tables
POST_START Designing Department-Based Row-Level Security for Enterprise Tables Setting Up the Security Function I started by thinking about how to secure our enterprise tables based on department access. I needed a way to filter rows so that users could only see data relevant to their department. The solution was to create a security function that…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, department-based, designing, education, Enterprise, 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, row-level, security, sql, tables, unity catalog -
Testing Column-Level Security for Privileged and Standard Users
POST_START Testing Column-Level Security for Privileged and Standard Users I recently needed to verify how column-level security is enforced in our Databricks environment. My task was to test whether privileged users could access certain columns in a table, while standard users were restricted. To do this, I started by examining the structure of the customer_master…
A1, category:business, category:education, category:software, category:technology, coding, column-level, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileged, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, security, sql, standard, Testing, unity catalog, users -
Designing Region-Based Row-Level Security for Shared Production Data
POST_START Designing Region-Based Row-Level Security for Shared Production Data I recently took on the responsibility of securing access to a shared production dataset in Databricks. The dataset, production.sales.regional_orders, contains sensitive customer information, and I needed to ensure that users only saw data relevant to their region. The goal was to implement region-based row-level security using…
A1, category:business, category:education, category:software, category:technology, coding, data, data engineering, data governance, databricks, designing, 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, region-based, row-level, security, shared, sql, unity catalog -
Testing Row-Level Security for Multiple Production User Roles
POST_START Testing Row-Level Security for Multiple Production User Roles I recently took on the task of verifying that row-level security (RLS) policies are correctly configured for multiple user roles in the production environment. My goal was to ensure that each role only sees the data it’s authorized to access. To start, I needed to understand…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, multiple, 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, roles, row-level, security, sql, Testing, unity catalog, user
