Forum Discussion

hina_walia's avatar
hina_walia
New Contributor
6 years ago

Load sql query data to csv file and send this file in email as an attachment

Load sql query data to csv file and send this file in email as an attachment. I tried using snowflake execute snap to get sql data and then use csv parser and write to file writer.The data is not s...
anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy Link

are you getting an error?, you have to write the file in sldb, also I believe the attachment size should be less than 25 MB, after your file writer snap use an email sender snap and set the attachment property to $filename, This should work fine.
file writer output :
email sender:

Regards
Anubhav