filters
-
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 -
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 -
Removing Row-Level Filters from Tables
POST_START Removing Row-Level Filters from Tables I recently encountered a situation where a table in our data lake had been filtered at the row level, and we needed to remove those filters to access the full dataset. The table in question was training.sales.customers, and the filters were applied as part of a row-level security policy.…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, filters, 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, removing, row-level, sql, tables, 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 -
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 -
Troubleshooting Unexpected Row-Level Access Results from Unity Catalog Row Filters
POST_START Troubleshooting Unexpected Row-Level Access Results from Unity Catalog Row Filters I was working on a query against the production.sales.customers table and noticed that some rows were not being returned as expected. I suspected that Unity Catalog row filters might be at play, but I wasn’t sure why the results didn’t align with what I…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, filters, 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, results, row, row-level, sql, troubleshooting, Unexpected, unity catalog
