table
-
Recovering a Production Delta Table to a Known Good Version
POST_START Recovering a Production Delta Table to a Known Good Version Today, I encountered an issue with the production Delta table production.sales.orders. A recent update introduced some inconsistencies, and I needed to recover the table to a known good version. I decided to use Unity Catalog’s versioning features to identify and restore the table to…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, Delta, education, good, known, 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, recovering, sql, table, unity catalog, version -
Tracing Read Access Through Catalog Schema and Table Grants
POST_START Tracing Read Access Through Catalog Schema and Table Grants I was tasked with understanding how read access to a specific table in the Unity Catalog was granted. My goal was to trace the permissions from the catalog level down to the table level to ensure that only the right users could access the data.…
A1, Access, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, grants, 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, read, schema, sql, table, through, tracing, unity catalog -
Auditing RBAC Across Catalog Schema and Table Boundaries
POST_START Auditing RBAC Across Catalog Schema and Table Boundaries I recently needed to audit the role-based access control (RBAC) settings for a catalog in our Databricks environment. The goal was to understand who had access to which parts of the catalog, especially across schema and table boundaries. I started by checking the grants at the…
A1, Across, auditing, Boundaries, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, 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, rbac, schema, sql, table, unity catalog -
Designing RBAC Through Catalog Schema and Table Privilege Layers
POST_START Designing RBAC Through Catalog Schema and Table Privilege Layers I recently had the task of setting up role-based access control (RBAC) for a new team in our organization. The goal was to ensure that the sales team could access the necessary data without exposing sensitive information. I decided to leverage Databricks Unity Catalog to…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, designing, education, Lakehouse, layers, paragraph ordering, paragraph structure, paragraphorder, privilege, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, rbac, schema, sql, table, through, unity catalog -
Documenting a Production Table and Sensitive Column for Governance Review
POST_START Documenting a Production Table and Sensitive Column for Governance Review I recently took on the responsibility of ensuring that our production data assets are properly documented for governance review. One of the key tables in our system is the customer_master table in the production.customers schema. This table holds the core customer information, and it’s…
A1, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, documenting, education, Governance, 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, review, sensitive, sql, table, unity catalog -
Testing a Production Table Schema Change Before Grant Review
POST_START Testing a Production Table Schema Change Before Grant Review I recently needed to test a schema change for a production table before submitting it for grant review. The table in question was production.sales.orders, and the goal was to add a new column to track the status of a review process. Before making any changes,…
A1, before, category:business, category:education, category:software, category:technology, change, coding, data engineering, data governance, databricks, education, grant, 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, review, schema, sql, table, Testing, unity catalog
