cgrant
Databricks Employee
Databricks Employee

‎12-03-2024 10:51 PM

One alternative is to re-order the columns into the order you'd like using the ALTER COLUMN API

Taking your example, 

ALTER TABLE catalog.schema.table ALTER COLUMN colB FIRST;
ALTER TABLE catalog.schema.table ALTER COLUMN colC AFTER colB;