table
-
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 -
Finding Excessive Table Privileges Assigned to Production Groups
POST_START Finding Excessive Table Privileges Assigned to Production Groups I recently took on the task of reviewing access controls for a few key tables in our production environment. One of the tables that raised my attention was production.finance.payments. I wanted to make sure that the right people had the right level of access and that…
A1, assigned, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, excessive, finding, groups, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, 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, table, unity catalog -
Troubleshooting a Service Principal That Lost Production Table Access
POST_START Troubleshooting a Service Principal That Lost Production Table Access Today, I encountered an issue where a service principal that was previously able to access a table in the production catalog suddenly lost access. The team was trying to run a critical ETL job, and the error message indicated that the service principal didn’t have…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, Lost, paragraph ordering, paragraph structure, paragraphorder, principal, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, service, sql, table, That, troubleshooting, unity catalog -
Safely Removing Column-Level Masking from a Production Unity Catalog Table
POST_START Safely Removing Column-Level Masking from a Production Unity Catalog Table Safely Removing Column-Level Masking from a Production Unity Catalog Table I’ve been working on a project where we needed to update a customer email column in our production table to remove column-level masking. The table in question is production.customers.customer_master, and the column we’re focusing…
A1, category:business, category:education, category:software, category:technology, coding, column-level, data engineering, data governance, databricks, education, Lakehouse, masking, 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, removing, safely, sql, table, unity catalog -
Safely Removing Row-Level Security from a Production Unity Catalog Table
POST_START Safely Removing Row-Level Security from a Production Unity Catalog Table The Problem I recently inherited a table in the production environment that had row-level security (RLS) applied to it. The table was production.sales.customers, and it was used by multiple teams for reporting and analytics. While the RLS was initially implemented to enforce data access…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, 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, removing, row-level, safely, security, sql, table, unity catalog -
Tracing a Production Table Query Failure Through Catalog, Schema, and Table Privileges
POST_START Tracing a Production Table Query Failure Through Catalog, Schema, and Table Privileges Tracing a Production Table Query Failure Through Catalog, Schema, and Table Privileges I was working on a critical data pipeline that was failing with an unexpected error. The query was attempting to access a table in the production catalog, but it was…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, failure, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, query, schema, sql, table, through, tracing, unity catalog -
Controlling Table Data Changes with MODIFY Privileges
POST_START Controlling Table Data Changes with MODIFY Privileges I recently had the task of ensuring that only specific data engineers could modify the customer data in our training database. The goal was to prevent accidental or unauthorized changes to the training.sales.customers table while still allowing the team to perform necessary updates. I decided to use…
A1, category:business, category:education, category:software, category:technology, changes, coding, controlling, data, data engineering, data governance, databricks, education, Lakehouse, modify, paragraph ordering, paragraph structure, paragraphorder, privileges, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, table, unity catalog -
Controlling Table Read Access with SELECT Privileges
POST_START Controlling Table Read Access with SELECT Privileges Controlling Table Read Access with SELECT Privileges I started my day by reviewing the access control requirements for the training catalog. The team needed to ensure that analysts could read specific tables, but not access other parts of the catalog. I knew that Databricks Unity Catalog provides…
A1, Access, category:business, category:education, category:software, category:technology, coding, controlling, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, read, select, sql, table, unity catalog -
Removing All Rows While Preserving a Table with TRUNCATE
POST_START <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Removing All Rows While Preserving a Table with TRUNCATE</title> </head> <body> <h1>Removing All Rows While Preserving a Table with TRUNCATE</h1> <p>I recently had a need to clear out all the data from a table while keeping the table structure intact. The table in question was <code>training.sales.customer_master</code>, and I…
(all), A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, preserving, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, removing, rows, sql, table, truncate, unity catalog, while
