In addition to time travel queries, it would be extremely useful to be able to query Iceberg data appended since a specific snapshot. Similar to what you can do in spark using
spark.read()
.format("iceberg")
.option("start-snapshot-id", "10963874102873")
.option("end-snapshot-id", "63874143573109")
.load("path/to/table")
The functionality is already there for incremental reflection refresh, so it “just” needs to be exposed through SQL.