Recently I needed to match regular expressions patterns in Redshift, where both the string and the regular expression were dynamic values provided from table columns. Unfortunately REGEXP_COUNT and other similar functions in Redshift, do not support columns as the regular expression. Therefore I decided to solve this with a UDF.
In this post I provide a simple Python code which utilizes ssmtp with MIME in order to send an HTML based email with an embedded image.
Continue reading “HTML based emails from Python (ssmtp)”