change column name in delta parquet file

Question

hello,
data fatory data flow is being used to upsert into delta parquet files.
The delta parquet files have several columns.
How is it possible to change the name of a column without affecting the data using the delta sink in the data flow?
for example, Columnc should be Column_C

Thank you

Answer 1

Hello @arkiboys,

Thanks for the details.

In your case, you need to update the column name of your delta table.

When column mapping is enabled for a Delta table, you can rename a column using the below syntax;

SQL

ALTER TABLE <table_name> RENAME COLUMN old_col_name TO new_col_name

Reference document: https://docs.databricks.com/delta/delta-column-mapping.html#:~:text=When%20%EE%80%80column%EE%80%81%20mapping%20is%20enabled%20for%20a%20%EE%80%80Delta%EE%80%81,Note%20Available%20in%20Databricks%20Runtime%2011.0%20and%20above.

Also, I found this blog helpful.

I hope this helps. Please let me know if you have any further questions.