sql
-
Transferring Production Table Ownership to a Platform Administration Group
POST_START Transferring Production Table Ownership to a Platform Administration Group I recently had the task of transferring ownership of a production table from its current owner to a platform administration group. This was part of a broader initiative to centralize governance and ensure that all production tables are managed by a dedicated team. The table…
A1, administration, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, group, Lakehouse, ownership, paragraph ordering, paragraph structure, paragraphorder, Platform, 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, transferring, unity catalog -
Building Least-Privilege Analyst Access to a Production Sales Table
POST_START Building Least-Privilege Analyst Access to a Production Sales Table I recently had the task of granting analysts access to a production sales table while ensuring that they had the minimum necessary privileges. This was a critical step in maintaining data security and compliance within our organization. I started by understanding the structure of the…
A1, Access, analyst, building, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, least-privilege, 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, sales, sql, table, unity catalog -
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 a production Delta table that had been accidentally modified. The table in question was production.sales.orders, and the latest version contained incorrect data that was causing downstream processes to fail. I needed to recover the table to a known…
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 -
Comparing Current and Historical Production Data After a Suspected Bad Write
POST_START Comparing Current and Historical Production Data After a Suspected Bad Write Yesterday, I noticed some unusual behavior in our production data pipeline. A new batch of data was written to the production.sales.orders table, but when I checked the latest records, it looked like some entries were missing or had incorrect values. I suspected a…
A1, after, bad, category:business, category:education, category:software, category:technology, coding, Comparing, current, data, data engineering, data governance, databricks, education, historical, 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, suspected, unity catalog
