Databricks Dataframe: Merge exception for string column in delta table with change detectio enabled.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2026 09:08 AM
Hi,
I am trying to append change data records into delta table using dataframe. However, I am encountering an issue while appending new records to existing data in delta table. The exception raised is
Cannot merge columns 'ColumnX' into 'ColumnX'
Both new dataframe column datatype and delta table column datatype is string.
Is there any way to avoid this issue ?
Code Line:
df_result.write.format("delta").mode("append").option("delta.enableChangeDataFeed", "true").saveAsTable(table_target)
Attached script code.
Labels:
- Labels:
-
Azure Databricks Delta Table
