Hello Engineers, please I would like to retrieve emails from snowflake and use them to send email remainders, please I would appreciate any help, Thank You.

Lots of folks would point you to a "reverse elt" vendor like hightouch / census. I think something like 1. dbt run -m +email_notifications 2. (use a select filter to only point to the email_notifications table) meltano run tap-snowflake target-apprise (or whatever target you want maybe a specific one for target-mailchimp or others) Apprise may or may not be what you're after here but it's worth a look as they do notifications to email services. Something more specefic for your use case may be required which means you'd need to write a target like

target-mailchimp

etc

FWIW, you don't need to write your own target. Inside the squared repo we're just utilizing a custom plugin to run code. You could for instance run Python code or bash code (we run AWSCLI code) to do reverse ETL. It's pretty straight forward.

+1 on the utility approach. We use a sendgrid utility - our requirement was to distribute an email to the same list of recipients. like the idea of a target-sendgrid

apprise supposedly supports sendgrid https://github.com/caronc/apprise/wiki/Notify_email#:~:text=mailto%3A//%7Buser%7D%3A%7Bpassword%7D[…]d.com%3Ffrom%3Dnoreply%40%7Bvalidated_domain%7D 😮

Yeah, it does. No attachments was the issue for us as I recall.

It supports those too 🤷 whatever works though honestly