How to adjust the Google BigQuery page size parameter when importing many columns at once

When importing data from Google BigQuery, if you select a lot of columns in your SQL query, the query may not return all the results.

In this case, select the Data Connections menu from the following menu.

Click the Edit button for the Google BigQuery.

Now the Google BigQuery Configuration dialog opens and there is an item called Page Size, set it to a smaller value than the default (for example, 5000).