[I] [BYO-S3] Schema: assume-role fields (role ARN / external ID / pending identity) [texera]

["mengw15 (via GitHub)" <gi...@apache.org>]

mengw15 opened a new issue, #6934:
URL: https://github.com/apache/texera/issues/6934

   ### Task Summary
   
   Part of #6870. Add the columns and table needed for the assume-role (Path B) credential model.
   
   - **Two columns on `user_warehouse`** — `role_arn` (the IAM role Texera assumes) and `external_id`
     (the per-warehouse ID tied to it), set only for AWS warehouses (null for Local).
   - **`user_s3_pending_identity` table** — holds the external ID reserved for a user **before** their
     warehouse exists, so they can set up their IAM role first: `uid` (PK, FK → `user`), `external_id`
     (UUID), `created_at`.
   - **jOOQ codegen** — regenerate for the new column(s) and table (and update `texera_ddl.sql`).
   
   ### Task Type
   - [x] Other (feature implementation)
   


-- 
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: notifications-unsubscribe@texera.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org