The PIVOT keyword is used to rotate rows of a table by turning unique row values into separate columns, effectively converting the table from a long format to a wide format. This operation is particularly useful for data analysis and reporting purposes. Reference: Databricks SQL Documentation