How Can I Find a Sync's Start Time and Sync End Time?

Question

How can I use the Fivetran Platform Connector to find a sync's start and end time?

Environment

Fivetran Platform Connector

Answer

The Fivetran Platform Connector records sync activity in the LOG table. To find a sync's start and end times:

1. Filter the LOG table by connection_id.
2. Find the sync_start or sync_end event in the message_event column.
3. Use the event's timestamp value as the sync start or end time.

To find sync start times, run:

SELECT 
  id,
  time_stamp AS start_time,
  message_event,
  connection_id
FROM 
  <SCHEMA_NAME>.log
WHERE 
  message_event = 'sync_start' 
  AND connection_id = '<YOUR_CONNECTION_ID>'
ORDER BY 
  start_time DESC;

To find sync end times, rerun the query with message_event = 'sync_end'.