Question
How can I get a notification when a sync has been completed?
Environment
Destination: BigQuery
Answer
Please see the below approach that can be used to receive a notification when the sync is completed:
- TheFivetran Log connector syncs a table named
Log. When a sync ends, this table is updated with anevententry equal tosync_end. - In BigQuery, you can set up a logging alert to notify you when this row is updated in the
fivetran_log.logtable. See Google's Documentation on creating logging alerts.