Can Assert transformation log file name be customised in Azure Data Factory

Question

Hi,

In ADF, Assert Transformation logs data in storage container but the file name is very cryptic.

Can this be customized to give it a more meaningful name? Is any configuration possible anywhere?

Also if the structure of the contents present in the CSV file can be changed?

Please help.

Regards,
Partha

Answer 1

Hi @Partha Das ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you want to know if there is any way to explicitly provide the file name to the log files after assert transformation is failing for the errored rows. Please let me know if that is not the ask.

I tried to repro your case, and got to notice that it's not possible to explicitly provide the file name for the log file capturing error rows after assert transformation.

However, the workaround you can go for is to filter out and get only the errored row using filter transformation and load them into a separate sink (.csv file) and provide the filename explicitly.

For more details, kindly check out : https://www.youtube.com/watch?v=VFRx0wjlA4s

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators