zhoulii opened a new issue, #10932: URL: https://github.com/apache/paimon/issues/10932
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Motivation Snapshots can store properties such as checkpoint and recovery metadata, but the `$snapshots` system table does not expose them. Users must inspect snapshot JSON or use an API to view these properties. Exposing them through SQL would make commit inspection and troubleshooting easier. ### Solution - Append a nullable `properties MAP<STRING, STRING>` column to `$snapshots`. - Return `NULL` when a snapshot has no properties. - Allow queries to select and filter properties by key: ```sql SELECT snapshot_id, properties['source.batch-id'] AS batch_id FROM my_table$snapshots WHERE properties['source.batch-id'] = '42'; ``` ### Anything else? This exposes existing metadata without changing the snapshot storage format or commit behavior. ### Are you willing to submit a PR? - [x] I'm willing to submit a PR! -- 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]
