How to upload local csv to bigquery

Question

I am referring tylertreat-BigQuery-Python library to upload csv to BigQuery. To upload data to GBQ it needs Google Cloud Storage path but I want to upload my local csv. Is there a way to upload local csv instead of GS.

Answer 1

You will need to use media upload mechanism.

• API documentation: https://cloud.google.com/bigquery/loading-data-post-request

• Python API: https://github.com/google/google-api-python-client/blob/master/googleapiclient/http.py#L381