Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
I try to use "ordinal" instead of source name, still not work.
Here is the ADF result. only CCATO column is NULL, all other columns are correct.
With your earlier example of manual vs dynamic mapping I thought it might be some weird problem in Data Factory, but now that you show me ordinals only not working, I must reconsider my view. I can't imagine any reason the ordinal would fail. Just to be sure, are ANY rows expected to have CCATO null?
Hmm. Parquet can be wierd at times. I don't have a snowflake set up to repro with. One thing to test, if you change sink from Snowflake to delimited text, does CCATO still come out null?
Thank you for your reply.
continue last post.
Sink to csv looks ok, but my destination is Snowflake.
Strange thing is if I use customized mapping instead of dynamic mapping, the result is ok. looks lik it's dynamic copy mapping JSON translator issue.
Sign in to comment