I run a pipeline daily to create a table that may contain errors in our source data. If the updated table and corresponding object set contains any rows, I want to trigger an action.
I want to create an Automation that will send an email notification to designated recipients that contains either:
Option 1) An Excel Spreadsheet as an attachment that contains an export of the table in question.
or
Option 2) A link to the table in Foundry.
I do not want to send any email if there are no rows in the updated table on that day.
I will appreciate any suggestion on how to configure this criterion.
Regards,
LenStringer