Compare data in Snowflake tables before insertion

Hi,

We have a requirement to build a pipeline to identify if the data from source is updated in Snowflake table or not. Essentially, I have to compare, pre and post results from the tables using SnapLogic pipeline and set-up an email alert that provides details associated with the newly loaded data (whether it is updated or not, timestamp, new record count, etc). 

Any material or source to look into ?