The maximum number of records per page the provider returns when requesting data from Google Drive.

Data Type

int

Default Value

-1

Remarks

When processing a query, instead of requesting all of the queried data at once from Google Drive, the connector can request the queried data in pieces called pages.

This connection property determines the maximum number of results that the connector requests per page. A value of -1 sets the page size to the maximum allowed, typically 100 or 1000 depending on the table. However, the API may return fewer results—such as 100 rows—even if the maximum is higher, based on the selected fields.

Note that setting large page sizes may improve overall query execution time, but doing so causes the connector to use more memory when executing queries and risks triggering a timeout.