Hi Sacha CLEMENTE:
Thanks for reaching out to Microsoft Q&A.
when i check the copy activity of the snowflake sink it say: data written 1mb and 2 k rows written while the xml file is 33mb.
it necessarily need not have to match the exact size of the xml file, the original content that is available inside the xml file to be written row-by-row may be only 2k rows which might constitute to only ~2mb.
Pls note that ADF by design does not have any restrictions on the amount of data that can be transferred in the pipelines. Also note that it succeeded and you dont have a failure of this pipeline hence it proves that the entire ingestion was complete with readable rows that can be inserted into the SF table.
Please 'Upvote’(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.