ADF copy data from parquet file to snowflakes, if column title has special char (#), the daynamic mapping not works

Dong, Jacky 21 Reputation points
2022-08-26T07:16:26.637+00:00

I have a parquet file ADF to Snowflakes. One column title of the parquet file has special char (#).
235164-title.jpg

When import mapping, I can manually add column mapping and the ADF result is ok.
235050-image.png

But I try to use dynamic mapping, the ADF result, all columns except CCATO# is correct. CCATO# is NULL.
235115-image.png

May I know how to use dynamic copy mapping for column has special char?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,443 questions
{count} votes