Adding csv with lesser columns than schema to BigQuery

[tanushreeshenvi]

I have a table in BigQuery with 100 columns. Now I want to append more rows to it via Transfer but the new CSV has only 99 columns. How should I proceed with this?

I tried creating a schema and adding that column as NULLABLE but it didn't work

[kolban]

I'll make a guess 🙂 ... What if you created a new table that matches the schema for the data you have (99 columns and not 100) and load your CSV into that table.  Assuming that succeeds, you now have two tables.  You can then use DML statements to update/insert the new table into the original table.  Once done, we can delete the new table.  If your need a one-time story or do you see this being needed to be done multiple times?