How Can I Get a Notification When a Sync Has Been Completed?

Question

How can I get a notification when a sync has been completed?

Environment

BigQuery destination

Answer

You can use the following approach to receive a notification when the sync is completed:

1. The Fivetran Platform connector syncs a table named LOG. When a sync ends, we update the event column as sync_end.
2. In BigQuery, you can set up a logging alert to notify you when this column is updated in the LOG table. For more information, see Google's Alert on log-based metrics documentation.