Hi I'm using send email component for automatic mail sending, in that I need to add some attachments file from source like S3,Sftp...etc. I used file iterator to fetch file from source and passed it through Variable in send mail component but it returned only name of the file but not the whole file data. So is there any way to attach file in send mail component any ideas.
Hey @HariRamK! This is indeed possible; alas, you need to use a bit of Python. See the KB article here: https://support.matillion.com/s/article/HowToSendanemailwithanattachmentgeneratedfromaDWtableusings3.
There's also an open idea on the roadmap for the same thing in Data Productivity Cloud here: https://roadmap.matillion.com/p/add-ability-to-send-an-email-with-an-attachment.
Reach out if you've got any more questions!
Thanks,
Johnathan
Hi @johnathan.law I'm also using python script for this, if idea on the roadmap got implemented it would be great help on Matillion ETL. Once again thanks for the quick response.😇