As a customer I want to know when ELT was not succesful. I discovered that prior to Feb, almost 33% of the data is missing from Snowflake compared to Dynamodb.
A simple cloud function could do that. For instance, the lambda keeps track of the number of records on dynamodb once every 24 hours. and then 15 minutes later(that is our fivetran sync frequency), it checks how many records have been created on snowflake in the preceding 24 hours. If there is divergence of more than a certain threshold it creates an alert.
FiveTran can create this once for each source, destination combo and ask its customers to use it.