If you’re importing from Google Sheets from Google Drive with BigQuery and using an automatic schema, is there any process where you can have the schema automatically update, or even get updated at all manually?
We were using a Google Sheet as a source, and business shuffled columns around and added some new ones, which broke all of the reports. Of course, we can lock this down and use a new sheet, but then all of the reports would have to be updated. It’d be ideal if you could reorder columns or add new ones without disruptions as long as the header names stayed the same, but it seems like the schema is locked after you create the table. Is that right?
One possibility might be to create a view that can just be updated, acting like a symlink. Then all reports can use that view, so we can update in one place.