Have you tried OFFSET / LIMIT, here is the SQL documentation
that describes it.
Essentially you can use
SELECT .... OFFSET x LIMIT y
where x is the starting point of a page and y is the number of rows you want in return.
Note that the docs mentions a few of cautions, including:
- If the data changes between consecutive queries for different pages (i.e. new streaming data is ingested), the contents may not be consistently paged because the data that is being paged through has changed.
- Skipped rows still need to be generated internally and then discarded, meaning that raising offsets to high values can cause queries to use additional resources.