Why The Following Bigquery Insertion Is Failing?

Hello I am trying to insert one row into a table, I succesfully created the table as follows: schema = [{'name': 'foo', 'type': 'STRING', 'mode': 'nullable'},{'name': 'bar', 'type'

Solution 1:

Your row field names don't match your schema field names. Try this instead:

rows =  [{'id': 'NzAzYmRiY', 'foo': 'uno', 'bar': 'dos'}]