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...
hina_walia's avatar
hina_walia
New Contributor
6 years ago
Copy Link

Please see attached, (i have 2 issues- csv file not generated and file not sent in email).I am not able to send data of sql to csv file.Please see attached

  • anubhav_nautiya's avatar
    anubhav_nautiya
    Contributor
    6 years ago
    Copy Link

    Do you get any data when you validate the pipeline? or you dont get the output in validation too

    • hina_walia's avatar
      hina_walia
      New Contributor
      6 years ago
      Copy Link

      I am getting cannot connect to email server, though same server works in another application tool for sending email. Can this be a access issue?
      Reason:

      Failed to send email message: Could not connect to SMTP host: xxx, port: 25

      Hide Details…

      Email Sender[58b7a2f5ba6d563aff5d73d9_6dded5c7-fe3c-4525-a1b1-2640e8cf9562 – d3383eb5-462b-4d09-b45e-beb2f059f42e]
      com.snaplogic.snap.api.SnapDataException: Failed to send email message

      at com.snaplogic.snaps.email.EmailSender.writeErrorView(EmailSender.java:629