[BUG] Delta Table with special Characted in Column Name.

[0xbadidea]

Bug

Which Delta project/connector is this regarding?

• [✓ ] Spark
• Standalone
• Flink
• Kernel
• Other (fill in here)

Describe the problem

I'm trying to create an empty Delta table using schema of a dataframe with special characters in the column name.

Steps to reproduce

1.  df_bad - Dataframe with special characters "(", ")", "`" and " " in column names.
    path = dbfs:/mnt/02arch/temp  #Mounted path on Databricks. (The path is empty)
   

2. 

``` (DeltaTable.createOrReplace(spark).tableName(f"default.{table_name.replace('-', '_')}")
    .property('delta.minReaderVersion', '2')
    .property('delta.minWriterVersion', '5')
    .property('delta.columnMapping.mode', 'name')     
    .addColumns(df_bad.schema)
    .location(path)
    .execute())

Observed results

== Specified ==
delta.columnMapping.mode=name
delta.minReaderVersion=2
delta.minWriterVersion=5

== Existing ==
delta.columnMapping.mode=name
delta.columnMapping.maxColumnId=72

Expected results

An empty Delta Table should have been created.

Further details

Environment information

• Databricks Runtime: DBR 10.4 LTS
• Delta Lake version:
• Spark version: Apache Spark 3.2.1.
• Scala version: 2.12

Willingness to contribute

The Delta Lake Community encourages bug fix contributions. Would you or another member of your organization be willing to contribute a fix for this bug to the Delta Lake code base?

• Yes. I can contribute a fix for this bug independently.
• Yes. I would be willing to contribute a fix for this bug with guidance from the Delta Lake community.
• No. I cannot contribute a bug fix at this time.