Loading Google Sheets into Big Query
<p>I have been able to follow the instructions listed here to load google sheets into big query.</p>

<p><a href="https://cloud.google.com/blog/big-data/2016/05/bigquery-integrates-with-google-drive" rel="nofollow noreferrer">https://cloud.google.com/blog/big-data/2016/05/bigquery-integrates-with-google-drive</a></p>

<p>The only thing that I'm stumped by is that I have to add fields to the schema.
So, lets suppose I have 100 columns in Google Sheets, all of which need to be loaded into BQ. Does that mean I have to manually type in 100 schema names one by one and select their field types? I've done one but I would think there's a way to load everything in Google Sheets into BQ automatically.</p>

<p>Could someone point me in the right direction?</p>

<p>Thanks!</p>