Generating BQ schema from google sheet header row
To generate a new schema:
-
Copy the ID header row from your google sheet
-
pbpaste | python make_schema.py
-
There's your BQ schema!
-
Add a new dataset to bigquery
-
Use your spreadsheet link as the file location