SQLines Tools sql-server-to-databricks
https://www.sqlines.com/
2026-04-15T02:52:08+00:00SQLines Tools
https://www.sqlines.com/
https://www.sqlines.com/lib/images/favicon.icotext/html2024-07-25T11:24:58+00:00UNPIVOT in SELECT Statements - SQL Server to Databricks Migration
https://www.sqlines.com/sql-server-to-databricks/unpivot?rev=1721906698&do=diff
In SQL Server you can use the UNPIVOT clause to rotate (unpivot) columns into rows. Databricks also supports UNPIVOT clause.
Consider a sample table:
CREATE TABLE colors
(
yellow INT,
blue INT,
green INT,
red INT,
orange INT
);
INSERT INTO colors VALUES (1, 2, 3, 4, 5);