Forum Discussion

dyordanov's avatar
dyordanov
Regular Visitor
9 months ago
Solved

How to send an email with a csv attachment

Hi guys,  I have a question. So I saw there is a thread here that somewhat answers the question but I think Microsoft have stopped the ability to a user to be able to attach a csv o anything in the ...
data engineering
data pipeline
lakehouse
notebook
dyordanov's avatar
dyordanov
Regular Visitor
9 months ago

So thanks for all answers as of now, so the file i am about the send is about 15mb each. After I send it another notebook will calculate things based on the file I sent and the excel is about 50 mb. So would that change any of the workflow ? 

spencer_sa's avatar
spencer_sa
Icon for Impactful Individual rankImpactful Individual
9 months ago

One alternative if you're not too set on actually emailing a csv (and is better for large files) is to write the CSV file to an ADLS Gen II container, build an SAS token/link for it, and email that link to your recipient.  You can then apply an expiry date if you need to and all you're emailing is a a URL so won't hit any size limits.
I have tested this and it works exactly as promised - Copy Activity to upload, notebook to generate the SAS token/URL, and an Email activity to send the email.