sqlmesh icon indicating copy to clipboard operation
sqlmesh copied to clipboard
verified publisher icon TobikoData

fix(fabric): Alter table workaround

Open fresioAS opened this issue 3 months ago • 1 comments

Fix for issue described in #5399 - ALTER TABLE ALTER COLUMN is not supported for Fabric Warehouse

  1. Add new empty column
  2. Copy data from old column to new column
  3. Drop old column
  4. Rename new column to old column name

fresioAS avatar Oct 08 '25 22:10 fresioAS

@treysp @izeigerman @erindru Any comments to this PR? Not ideal since it changes the order of the columns, but 100% better than crashing out with Error:('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The specified ALTER TABLE statement is not supported in this edition of SQL Server. (24585) (SQLExecDirectW)')

fresioAS avatar Oct 28 '25 08:10 fresioAS

@georgesittas, can we get traction on this? It's causing some issues ☺️

mattiasthalen avatar Nov 23 '25 09:11 mattiasthalen

Thanks @fresioAS !

erindru avatar Dec 02 '25 18:12 erindru