new run-query param: skip #926
Description
Is your feature request related to a problem? Please describe.
Large resultsets would benefit from being able to return a portion at a time. BigQuery supports this via https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#limit_and_offset_clause however our portfolio of run-queries already has another meaning for the parameter named offset.
Describe the solution you'd like
Introduce a new parameter for any query at risk of returning "too many" (TBD) results. This parameter would be named skip, have a default value of 0, and be plugged into a LIMIT .. OFFSET clause per the documentation linked above.
Describe alternatives you've considered
Repurposing the existing offset param seems too impactful. Another alternative is to do nothing and leave it to the query caller to request smaller resultsets.
Additional context
https://jira.corp.adobe.com/browse/AEMEO-6829