> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prequel.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Transfer status table

> Per-model transfer completion timestamps written to database and data warehouse destinations

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.