modifying
-
Modifying Table Structure and Properties with ALTER TABLE
POST_START Modifying Table Structure and Properties with ALTER TABLE I recently needed to update the structure of a table in Unity Catalog to better align with our data modeling standards. The table in question was training.sales.customers, and the first change I wanted to make was to add a new column called phone of type STRING.…
A1, alter, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, modifying, 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, properties, sql, structure, table, unity catalog -
Preventing Interactive Users from Modifying Production Tables
POST_START Preventing Interactive Users from Modifying Production Tables I recently took on the task of securing our production database to ensure that only authorized users can modify critical tables. One of the main concerns was preventing interactive users from making changes to the production tables, which could lead to data integrity issues or accidental deletions.…
A1, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Interactive, Lakehouse, modifying, paragraph ordering, paragraph structure, paragraphorder, preventing, 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, tables, unity catalog, users -
Modifying Table Structure and Properties with ALTER TABLE
POST_START <h1>Modifying Table Structure and Properties with ALTER TABLE</h1> <p>I started my day by reviewing the latest requirements for the sales team. They needed to track customer phone numbers for better outreach and support. The existing customer table in the training.sales schema didn't have a phone column, so I decided to modify the table structure…
A1, alter, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, Lakehouse, modifying, 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, properties, sql, structure, table, unity catalog
