03-03-2023 06:02 AM
The UNPIVOT clause is now supported by Databricks SQL. Use the UNPIVOT
clause to rotate columns of a table-valued expression into column values https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-unpivot.html
