how to i able to read column mapping metadata for delta tables

sher
Valued Contributor II

i want to read column mapping metadata

https://github.com/delta-io/delta/blob/master/PROTOCOL.md#column-mapping

in above link we can able to find the code block with json data. the same data i want to read in pyspark.. is there any option to read that metadata from databricks please let me know

below code block i want to read for my delta tables

{
    "name" : "e",
    "type" : {
      "type" : "array",
      "elementType" : {
        "type" : "struct",
        "fields" : [ {
          "name" : "d",
          "type" : "integer",
          "nullable" : false,
          "metadata" : { 
            "delta.columnMapping.id": 5,
            "delta.columnMapping.physicalName": "col-a7f4159c-53be-4cb0-b81a-f7e5240cfc49"
          }
        } ]
      },
      "containsNull" : true
    },
    "nullable" : true,
    "metadata" : { 
      "delta.columnMapping.id": 4,
      "delta.columnMapping.physicalName": "col-5f422f40-de70-45b2-88ab-1d5c90e94db1"
    }
  }