BigQuery - List Table Data - fetch more than 3500 records

I’m trying to sync a BQ table to Airtable.
The sync works well, but I’m limited to pulling 3500 records from BQ.
How can I fetch more than 3500 records?

Things I tried:

  • Playing with the limit attribute.
  • Using the BQ Write Query module instead.

Both of them still max out at 3500 records.

Using the dev tools, I see that make.com calls BQ in multiple API calls in chunks of 500 records but always stops after 7 calls.
7 calls x 500 records = 3500 records.

The limit is set to 15K:

Max 7 API calls in chunks of 500 records:

1 Like