ADF copy data from parquet file to snowflakes, if column title has special char (#), the daynamic mapping not works
Dong, Jacky
21
Reputation points
I have a parquet file ADF to Snowflakes. One column title of the parquet file has special char (#).
When import mapping, I can manually add column mapping and the ADF result is ok.
But I try to use dynamic mapping, the ADF result, all columns except CCATO# is correct. CCATO# is NULL.
May I know how to use dynamic copy mapping for column has special char?