filter
-
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 -
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 -
Implementing Production Row-Level Security with a Country-Based Unity Catalog Row Filter
POST_START Implementing Production Row-Level Security with a Country-Based Unity Catalog Row Filter The Problem: Securing Data Access by Country I recently had to implement row-level security for a customer database in Databricks. The requirement was simple but critical: only users in the global_sales account group should be able to access all data, while others should…
A1, category:business, category:education, category:software, category:technology, coding, country-based, data engineering, data governance, databricks, education, filter, implementing, 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, row, row-level, security, sql, unity catalog -
Databricks SQL: Filter Sort and Limit Result Sets
Databricks SQL: Filter, Sort, and Limit Tutorial Databricks SQL: Filter, Sort, and Limit Result Sets This tutorial demonstrates how to filter, sort, and limit result sets using Databricks SQL. We’ll work through several scripts, each building upon the previous one, focusing on the core concepts. All code is intended to be executed directly within the…
A1, category:data cable, category:desktop pc, category:education, category:laptop, category:software, coding, data engineering, databricks, databricks sql, delta lake, education, filter, limit, paragraph ordering, paragraph structure, paragraphorder, profession:data analyst, profession:data scientist, profession:linguist, profession:software developer, profession:student, profession:teacher, profession:translator, progressive learning, result, sets, sort, sql, sql engineering
