brockb
Databricks Employee
Databricks Employee

Hi,

Information about the delta table such as history information could be found by running a `describe history table_name`. A `rename column` operation could be found in the `operation` column with a value of `RENAME COLUMN`. 

If you then look at the corresponding delta transaction json file in the table's `_delta_log` directory, you will find the details. For example, if the column rename occurred in Delta version 1, you could go to the `<tableLocation>/_delta_log/00000000000000000001.json` file for the details.

You could read this json file with `spark.read.json(path)`. Much of the data of interest to you would be in the  `metaData.schemaString` column.

I hope this helps.