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

victor

posted on 30 Oct 19

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