I have a huge number of CSV’s that I’d like to create BigQuery tables for. They are all going to have distinct schema so for starters I’d like to just create a new table for each CSV but eventually I’d like to be able to overwrite the table with a new CSV that is an updated version of the original. Put differently, three csvs (a.csv, b.csv, c.csv) become three tables and a future dump of tables (a1.csv, b1.csv, c1.csv) all overwrite their respective tables.
I can use the watch Google Shared Drive Folder to grab new csv files and name the table based on the file name. But I’m not sure how to set the schema for the table creation. Is there a way to do this with Parse CSV?