Currently the email notification for failed Coalesce transformations is very generic as seen below in the screenshot from our emails.  A nice enhancement would be the ability for Fivetran to pull back the actual error message from Coalesce for a more meaningful notification