Monitoring & Run History

​

Transfer List View

• Status badge: Active, Paused, or Error
• Last run result: Success, Partial Success, Failed, or Running
• Last run time: When the most recent sync completed
• Row count: Total rows loaded in the last run
• Next run: When the next scheduled sync will execute

​

Real-Time Sync Progress

• Current table: Which table in the group is being processed
• Tables completed: Progress across all tables (e.g., “3 of 7 tables”)
• Rows loaded: Running total of rows loaded so far
• Bytes loaded: Total data volume processed
• Chunk progress: For large syncs, progress within the current table (e.g., “Chunk 4 of 12”)
• Start time: When the current sync began

​

Run History

​

Run Summary

​

Per-Table Results

• Row count: Rows loaded for this table
• Status: Success, Failed, or Skipped
• Sync mode: Which mode was used
• Error details: If the table failed, the specific error message

​

Run Types

​

Run Statuses

​

Action History

• Transfer created / updated / deleted
• Syncs started / completed / failed
• Paused / resumed
• Settings changed
• Resyncs triggered

​

Monitoring in BigQuery

​

Useful Monitoring Queries

SELECT
  table_name,
  MAX(completed_at) as last_sync,
  TIMESTAMP_DIFF(CURRENT_TIMESTAMP(), MAX(completed_at), HOUR) as hours_ago
FROM `project.dataset._detrics_sync_log`
WHERE status = 'success'
GROUP BY table_name
ORDER BY hours_ago DESC

SELECT
  table_name,
  COUNT(*) as sync_count,
  ROUND(AVG(duration_ms) / 1000, 1) as avg_duration_seconds,
  ROUND(AVG(row_count), 0) as avg_rows
FROM `project.dataset._detrics_sync_log`
WHERE status = 'success'
  AND started_at >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY)
GROUP BY table_name
ORDER BY avg_duration_seconds DESC

SELECT
  table_name,
  error_message,
  started_at
FROM `project.dataset._detrics_sync_log`
WHERE status = 'failed'
  AND started_at >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)
ORDER BY started_at DESC