I received an Array Size Limit error message. What does this mean, and why does it occur?
The array size limit changes based on the array, anything that has an unlimited array can hit this limit in failure. The BigQuery request size limit is 10 mb per API call and each array within the API call has an individual limit of 1mb.
Note:
The maximum size must be smaller for any array size, parameter size, and all parameters in the call. It is also important to be specific with APIs. Each API call can contain up to 10,000 individual arrays.