GoogleBigQuery.upsert() fails if the columns are ordered differently in the database's table than in the Parsons table.
If the mismatched columns are the same data type, it will silently insert the data into the wrong columns. If the mismatched columns are different data types, then the upsert will fail with an error.
To Reproduce
This script will throw an error when it attempts the upsert because columns a and b have different types:
GoogleBigQuery.upsert()
fails if the columns are ordered differently in the database's table than in the Parsons table.If the mismatched columns are the same data type, it will silently insert the data into the wrong columns. If the mismatched columns are different data types, then the upsert will fail with an error.
To Reproduce
This script will throw an error when it attempts the upsert because columns
a
andb
have different types:Your Environment
main
branch as of 3/21/2024