Skip to content

[BYO-S3] Schema: user_warehouse #6931

Description

@mengw15

Task Summary

Part of #6870. Add the database table that records each user's warehouses (base columns; the
assume-role columns come in a later PR).

  • user_warehouse table — one row per warehouse: whid (PK), uid (owner, FK → user),
    name (user-facing), warehouse_name (the catalog name user-<uid>-<name>, unique),
    lakekeeper_warehouse_id, flavor, s3_bucket, s3_endpoint, s3_region, created_at.
    Ownership FK + UNIQUE(uid, name).
  • jOOQ codegen — regenerate the UserWarehouse POJO/DAO from the new table (and update
    texera_ddl.sql).

Schema only — nothing reads or writes it yet.

Task Type

  • Other (feature implementation)

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions