app.warehouse_destinations
TableRow level security on
A customer's own bucket that receives the org's nightly warehouse files (Section 4.6.4, Enterprise). The bucket credential lives in Supabase Vault and is never shown again.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.References app.organizations.id |
| provider | app.warehouse_provider | No | S3 (or S3-compatible), Google Cloud Storage, Azure Blob, BigQuery or Snowflake.References private.warehouse_providers.provider |
| display_name | text | No | Name the org knows the destination by. |
| bucket_name | text | No | Bucket or container the files go to. |
| region | text | Yes | Bucket region, for example us-east-1. |
| endpoint_url | text | Yes | HTTPS endpoint of an S3-compatible service other than AWS; NULL for AWS S3. Private and internal hosts are refused. |
| path_prefix | text | No | Folder inside the bucket; each delivery writes <prefix>/<date>/<delivery id>/. |
| file_format | app.warehouse_file_format | No | Parquet or CSV. |
| include_confidential | boolean | No | Whether Confidential columns are delivered; only a holder of data.export.confidential turns it on. Restricted columns are never delivered. |
| delivery_hour | smallint | No | Hour of the nightly delivery on the org's calendar (its locale.time_zone setting, UTC when unset). |
| destination_state | app.warehouse_destination_state | No | Active or Paused. |
| next_delivery_at | timestamp with time zone | Yes | When the next nightly delivery is queued. |
| credential_stored_at | timestamp with time zone | Yes | When the bucket credential was stored in Vault, or NULL. |
| last_delivered_at | timestamp with time zone | Yes | When the last delivery finished. |
| last_error_code | text | Yes | Rule code of the last failed delivery. |
| last_error_message | text | Yes | Message of the last failed delivery. |
| 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. |