mengw15 opened a new pull request, #7386: URL: https://github.com/apache/texera/pull/7386
### What changes were proposed in this PR? Adds the `user_warehouse` table (umbrella #6870): one row per warehouse a user registers — owner (`uid`, FK → `user`, cascade on delete), user-facing `name` (unique per user), the Lakekeeper catalog name `warehouse_name` (globally unique), `lakekeeper_warehouse_id` (UUID), `flavor`, the S3 location columns, and `created_at`. Base columns only; the assume-role (BYO-S3) columns come in a later change. Schema only — nothing reads or writes the table yet. The DDL, the incremental migration (`sql/updates/32.sql`), and the changelog registration ship together; jOOQ classes are generated from the live database at build time as usual. ### Any related issues, documentation, discussions? Closes #6931. Part of #6870 (design discussions #5293 and #6040). ### How was this PR tested? A new `UserWarehouseSpec` (MockTexeraDB, embedded Postgres) pins the DDL's structural properties against the generated jOOQ classes: insert/read-back of a registered warehouse, the per-user name uniqueness, and the ownership cascade. Verified locally with `sbt "DAO/testOnly *UserWarehouseSpec"` plus scalafmt/scalafix; the cascade case was deliberately broken once to confirm it fails red. ### Was this PR authored or co-authored using generative AI tooling? Generated-by: Claude Code (claude-fable-5) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
