Bigquery Doesn't take the first column as header when importing from sheet

user_6459056 0
Viewed 652

i'm trying to create a table from a google sheet sheet, I marked the header rows to skip to 1, however when I import the data I find :

  1. the columns name are : string_field_0, string_field_1 ...
  2. the header raw values existed as data in the table

I checked that in the sheet the first raw (number 1) is the header

google-bigquery
1 Answers

This error could be about 3 possible problems:

1.You need to set “Header rows to skip”, which is the number of rows that are at the top of the first row with data that includes the header or if there are some rows in blanks. You can do this in BigQuery UI.

enter image description here

2.Maybe all the header names are string type, with BigQuery you need to distinguish each header with something other than a String. In this case I will use integer. for example:

column1,column2,column3
foo,bar,1
cat,dog,2
fizz,buzz,3

You need to have something other than just Strings

3.You need to explicitly specify the schema yourself.

user_169291450
Related