app.warehouse_deliveries
TableRow level security on
Every warehouse delivery (Section 7.3 warehouse_deliveries): when it ran, what it wrote and how many classified columns it withheld. Audited; written only by the delivery RPCs.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.warehouse_destinations on insert; never accepted from the caller and never changed.References app.organizations.id |
| warehouse_destination_id | uuid | No | Destination the files went to.References app.warehouse_destinations.id |
| delivery_state | app.warehouse_delivery_state | No | Queued, Running, Delivered, Retrying or Failed. |
| requested_manually | boolean | No | True when a person asked for it with Deliver now; false for the nightly schedule. |
| file_format | app.warehouse_file_format | No | Format the delivery writes, fixed when it is queued. |
| include_confidential | boolean | No | Whether Confidential columns are delivered, fixed when it is queued. |
| attempt | smallint | No | Attempts started so far. |
| max_attempts | smallint | No | Attempts before the delivery is Failed. |
| next_attempt_at | timestamp with time zone | Yes | When a Queued or Retrying delivery is due. |
| snapshot_at | timestamp with time zone | Yes | Cut-off of the delivery: rows created after it wait for the next delivery. |
| started_at | timestamp with time zone | Yes | When the current or last attempt started. |
| finished_at | timestamp with time zone | Yes | When the delivery was Delivered or Failed. |
| object_prefix | text | Yes | Folder in the bucket the files were written to. |
| schema_version | text | Yes | Version of the published schema the files follow. |
| tables_delivered | integer | No | Tables written. |
| rows_delivered | bigint | No | Rows written across all files. |
| bytes_delivered | bigint | No | Bytes written across all files. |
| columns_withheld | integer | No | Classified or encrypted columns left out across all tables. |
| error_code | text | Yes | Rule code of the last failure. |
| error_message | text | Yes | Message of the last failure. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |