Video demo on how to connect and query Google Sheets data from Google BigQuery.
This is generally called an external table because the data is stored in google sheets and we just use BigQuery to query the data.
Read more about BigQuery external tables here - cloud.google.com/bigquery/doc...