Transfer status table

Database and data warehouse destinations receive a _transfer_status artifact in the destination schema after each successful transfer. It contains one row per model with the timestamp of the last successful sync.

Schema

Column	Type	Description
`data_model_name`	string	Name of the data model (matches the destination table name).
`transfer_last_updated_at`	timestamp	Timestamp of the most recent completed transfer for this model. Note that new data may not have been written on the last successful sync (e.g., if there were no changes).

BigQuery

For BigQuery destinations, _transfer_status is a view rather than a physical table. It is backed by BigQuery's __TABLES__ metadata and a _transfer_status_cache table, which caches timestamps to prevent schema evolution operations from inflating the last-modified time.

The _transfer_status_cache table is also present in the destination schema and is used internally by the view; it does not need to be queried directly.