Supported Table Structures

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:

  1. Your table needs to start in A1 cell
  2. 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
  3. There should be no blank columns in between non-blank columns => The table needs to be a coherent area
  4. There should be no random values on the sheet

Example 1

This table would go through because it’s a nice table meeting all the requirements.

Table Structure 1

Example 2

It’s OK to have empty rows in your table as long the table structure and data types are unchanged.

Table Structure 2

Example 3

Let’s now look on tables which will fail during upload.

This one will fail because there is blank column C.

Table Structure 3

Example 4

This one will fail because of the missing header in column C.

Table Structure 4

Example 5

This one will fail because of the blank column A.

Table Structure 5

Example 6

This one will fail because column A is blank and the header is not on row 1.

Table Structure 6

Example 7

This one will fail because of the random strings in column E and H.

Table Structure 7

We hope it’s now a bit clearer how to prepare your sheet and tables before pushing them to BigQuery.

Back to Help Center  Buy License Now


Leave a Reply

Your email address will not be published. Required fields are marked *