Warning/Caution message on a special case in workflow

Question

Hi Team,

There is a workflow that picks sql scripts and backfill multiple tables in one go. Due to some reasons, for couple of tables, no records get backfilled. And we only get to know when we check final tables because workflow is not throwing any error.

Please suggest that how we can set a warning/caution message in this case.

Purpose is to know that in how many tables we have zero records.

gabrielvilella · Answer

Here is an example of how to use the Messages tool.

Messages.yxmd

Vikas038 · Answer

Hi Gabriel,

It would be really helpful if you share screen shot of a sample workflow for validation.

Thanks,

Vikas

gabrielvilella · Answer

You can build the validation in the workflow and use the Message tool to trigger warnings/erros.