obelix74 opened a new pull request, #3523: URL: https://github.com/apache/polaris/pull/3523
Add new schema version 4 with tables for storing scan and commit metrics reports as first-class entities. New tables: - scan_metrics_report: Stores scan metrics with trace correlation - scan_metrics_report_roles: Junction table for principal roles - commit_metrics_report: Stores commit metrics with trace correlation - commit_metrics_report_roles: Junction table for principal roles Key design decisions: - PRIMARY KEY (realm_id, report_id) for multi-tenancy - Junction tables with CASCADE DELETE for roles - Timestamp index for retention cleanup - JSONB metadata column for extensibility (Postgres), TEXT for H2 Schema is self-contained (includes all tables from v1-v3) to support fresh installs. <!-- ๐ Describe what changes you're proposing, especially breaking or user-facing changes. ๐ See https://github.com/apache/polaris/blob/main/CONTRIBUTING.md for more. --> ## Checklist - [x] ๐ก๏ธ Don't disclose security issues! (contact [email protected]) - [x] ๐ Clearly explained why the changes are needed, or linked related issues: Fixes # - [ ] ๐งช Added/updated tests with good coverage, or manually tested (and explained how) - [ ] ๐ก Added comments for complex logic - [ ] ๐งพ Updated `CHANGELOG.md` (if needed) - [ ] ๐ Updated documentation in `site/content/in-dev/unreleased` (if needed) -- 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]
