Need to send email with Attachment from Matillion Tool

Question

I have checked SNS Message,Send Email component from Matillion but it does not have attachment option.

I have Error log table into Amazon Redshift and I want to retrieve those records and load into one file on daily basis( can be put on S3/SFTP ) this file I want to add as attachment to email and send it to vendor for further analysis.

Found this : https://metlcommunity.matillion.com/s/question/0D54G00007lwu2DSAQ/send-email-with-attachment-of-errors but couldn't help.

https://metlcommunity.matillion.com/s/question/0D54G00007lwu2DSAQ/send-email-with-attachment-of-errors

53epo · Accepted Answer · 2022-04-08 06:20:17Z

0

Based on this message on the Matillion site, it looks like currently there is no built-in component for sending an email with an attachment, but it is on the product roadmap to add one.

There are some hosted downloadable jobs that can send emails - e.g. this and this. It is not clear if they can handle attachments, but at least the Python code inside them might be helpful..

answered Apr 8, 2022 at 6:20

53epo

9197 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

peterb · Accepted Answer · 2022-04-08 19:45:38Z

0

You can do this with the python component in Matillion.

If the target file is on S3, you can use the python boto3 package to download the file to the matillion server.

Then you can use the smtp package in python to create the email and attach the file.

this is example code to attach a file where the filename is in the variable filename_out

filename_out = "/tmp/" + "myfile.logs"  
part = MIMEBase('application', "octet-stream")
part.set_payload(open(filename_out, "rb").read())
encoders.encode_base64(part)
part.add_header('Content-Disposition', 'attachment; filename=' + filename_out)
message.attach(part)

answered Apr 8, 2022 at 19:45

peterb

7373 silver badges11 bronze badges

2 Comments

Satis Chaudhar Over a year ago

:S3.Bucket(Bucket).download_file(Key, 'ErrorFile.csv') I have added this code so is this by default going to download file to /tmp/ location ?

Satis Chaudhar Over a year ago

#S3.Bucket(Bucket).download_file(Key, 'ErrorFile.csv') I have added this script for downloading file onto matillion server , so is it going to download the s3 file into /tmp/ location or do we need to specify any location ?

Collectives™ on Stack Overflow

Need to send email with Attachment from Matillion Tool

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related