We believe there needs to be a clarity on what structures of tables you can actually push to BigQuery. This article shows several examples of tables which would successfully be uploaded and which would fail.
The basic rules for success are:
- Your table needs to start in A1 cell
- The first row in Google Sheets will always be the column names in BigQuery so you cannot leave row 1 blank if row 2 has data in it
- There should be no blank columns in between non-blank columns => The table needs to be a coherent area
- There should be no random values on the sheet
This table would go through because it’s a nice table meeting all the requirements.
It’s OK to have empty rows in your table as long the table structure and data types are unchanged.
Let’s now look on tables which will fail during upload.
This one will fail because there is blank column C.
This one will fail because of the missing header in column C.
This one will fail because of the blank column A.
This one will fail because column A is blank and the header is not on row 1.
This one will fail because of the random strings in column E and H.
We hope it’s now a bit clearer how to prepare your sheet and tables before pushing them to BigQuery.