Stop logic river if no file found

I am setting up a logic river does the following steps.

  1. Pull a file from an SFTP and load into snowflake.
  2. Run a select from a view and put results into an S3 bucket.
  3. Send an email with link to data in S3 bucket.

This process runs every 15 minutes to see if the file exists in the SFTP. I am looking for a way to stop the process if no file is found. Currently it will send an email every 15 minutes.

If I truncate the table I load into I will not get an email, but I can’t find a way to truncate the table after this process completes so it will not send another email.


I am new here but a real enthusiast and loving this community so far. I have a background in teaching logics and in education and feel I could help with documentation, at least for starters.