LinkedIn
Twitter
Hi,
I have tables for which I upload csv files on a regular basis where I append the csv files to existing tables, but since yesterday, I have been unable to do so as I am getting the error message below.
The file I am uploading is indeed a csv and has the same schema (I have created a similar table and the schema came out the same as the existing table I was trying to append).
I have never seen this before, does anyone know what this mean?
Show More
" Invalid value at 'job.configuration.load.schema.fields[0]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[1]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[2]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[3]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[4]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[5]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[6]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[7]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[8]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[9]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[10]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[11]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. Invalid value at 'job.configuration.load.schema.fields[12]' (Map), Cannot bind a list to map for field 'dataGovernanceTags'. "
Solved
1 ACCEPTED SOLUTION
I found the error.
The column headers of the csv file I upload contain spaces.
i.e. one of the column headers in the csv is 'Completed Date'.
In the past, BigQuery would upload this as Field Name = Completed_Date. Anytime I would upload a csv file, the header would remain the same ('Completed Date') and would go through without any issues.
Something must have changed since June 3 (last time I uploaded any csv files), as now, BigQuery uploads the same Field without the underscore hence the error I get (which sucks to get as an error as it doesn't explain what is a very simple error).
The field name is now 'Completed Date'.
See screenshot below, on the left is the schema and field names the way they would get uploaded. On the right, is how it shows and where the column headers from csv files now have to match 100% field names.
