I am attempting to create a table using a .tsv file in BigQuery, but keep getting the following error:

"Failed to create table: Error while reading data, error message: Could not parse '41.66666667' as INT64 for field Team_Percentage (position 8) starting at location 14419658 with message 'Unable to parse'"

I am not sure what to do as I am completely new to this.

Here is a file with the first 100 lines of the full data:

https://wetransfer.com/downloads/25c18d56eb863bafcfdb5956a46449c920220502031838/f5ed2f

Here are the steps I am currently taking to to create the table:

https://i.gyazo.com/07815cec446b5c0869d7c9323a7fdee4.mp4

Appreciate any help I can get!

CodePudding user response：

As confirmed with OP (@dan), the error encountered is caused by selecting Auto detect when creating a table using a .tsv file as the source.

The fix for this is to manually create a schema and define the data type for each column properly. For more reference on using schema in BQ see this document.