I have a bigquery table that is connected to a google sheet link. I am going to add an additional column to this google sheet and wanted to know if the bigquery table schema will change to match? If not, do I have to completely recreate and link to the google sheet again?
The new column will not add automatically.
Instead of recreating the table though, if you open the table, navigate to the Schema Page, there will be a Edit Schema button which will allow you to add the new column with the desired data type. The Edit Schema Button
Typically you only need to recreate the link if you change the order of column headers or remove a column.
