investigating
-
Investigating a Column Mask That Exposes Sensitive Production Values
POST_START Investigating a Column Mask That Exposes Sensitive Production Values I recently encountered an issue while reviewing the customer data in our production environment. A column mask was supposed to protect sensitive information, but it appeared to be exposing some production values. I needed to investigate the table structure and data to understand what was…
A1, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, exposes, investigating, Lakehouse, mask, 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, sensitive, sql, That, unity catalog, values -
Investigating a Column Mask That Blocks an Approved Production User
POST_START Investigating a Column Mask That Blocks an Approved Production User I recently encountered an issue where an approved production user was unable to access certain data in the customer_master table. The user had the necessary permissions, but when they tried to query the table, some columns were masked or hidden. My task was to…
A1, approved, blocks, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, investigating, Lakehouse, mask, 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, sql, That, unity catalog, user -
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 -
Investigating Unexpected Cross-Catalog Production Access
POST_START Investigating Unexpected Cross-Catalog Production Access Investigating Unexpected Cross-Catalog Production Access Today, I was tasked with investigating an unexpected access issue in our Databricks environment. A team member noticed that some users were able to access data from the production catalog, even though they shouldn’t have had permission. I needed to figure out how this…
A1, Access, category:business, category:education, category:software, category:technology, coding, cross-catalog, data engineering, data governance, databricks, education, 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, sql, Unexpected, unity catalog -
Investigating Effective Access Across Catalog Schema and Table Grants
POST_START Investigating Effective Access Across Catalog Schema and Table Grants I recently needed to understand how access permissions propagate across different levels in Unity Catalog, specifically looking at how grants on a catalog affect access to schemas and tables within it. I started by examining the production catalog, which contains several schemas and tables that…
A1, Access, Across, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Effective, grants, investigating, 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, schema, sql, table, unity catalog
