OFFSET vs keyset pagination for sequential export of an append-only BigQuery table
Goal is to bound and page through a large append-only BigQuery table with stable monotonic ordering for sequential export. The constraint is per-page processed bytes and result consistency across pages, with no random access requirement. Two documented approaches are OFFSET-based pagination with LIMIT and keyset pagination using a filter on the last seen ord
google