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?

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