row
-
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 -
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 -
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 -
Implementing Row-Level Access Control with Row Filters
POST_START Implementing Row-Level Access Control with Row Filters I recently needed to implement row-level access control for a sales team in Databricks. The goal was to ensure that only members of the ‘global_sales’ account group could see all customer data, while others could only access data for Germany. I decided to use Unity Catalog’s row…
A1, Access, category:business, category:education, category:software, category:technology, coding, control, data engineering, data governance, databricks, education, filters, implementing, 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, row-level, 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 -
Investigating a Row Filter That Hides Expected Production Records
POST_START Investigating a Row Filter That Hides Expected Production Records I recently encountered an issue where some expected production records were missing from our financial transactions table. My task was to investigate why these records weren’t showing up, even though they should have been in the dataset. I started by checking the table structure to…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, expected, filter, hides, investigating, 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, records, row, sql, That, unity catalog -
Investigating a Row Filter That Returns Too Many Production Records
POST_START Investigating a Row Filter That Returns Too Many Production Records I recently encountered a problem where a row filter was returning more records than expected from the production.finance.transactions table. The filter was intended to limit results to only active transactions, but the query was returning a large number of records, including some that were…
(many), A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, filter, investigating, 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, returns, row, sql, That, Too, unity catalog -
Combining Row Filters and Column Masks for Layered Production Protection
POST_START Combining Row Filters and Column Masks for Layered Production Protection I recently took on the task of securing sensitive customer data in our production environment. The goal was to implement layered protection using row filters and column masks to ensure that only authorized users could access specific data. To begin, I needed to understand…
A1, category:business, category:education, category:software, category:technology, coding, column, combining, data engineering, data governance, databricks, education, filters, Lakehouse, layered, masks, 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, row, sql, unity catalog
