BigQuery error in load operation: Too many total leaf fields: 27500
The Maximum columns per table value that bigquery supports is 10,000 which means that the error message was thrown since the load job exceeded the maximum number of fields allowed in the schema.
Based on this, an available workaround is to split the table up into smaller tables in order to reduce the number of fields contained; In this way, you will be able to avoid this issue
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds