Automate CSV File Bulk Upload With Google BigQuery API Using Python (Source Code In Description)

So this is a script I use whenever I need to bulk upload CSV files to Google BigQuery for myself and for my clients. In this video, I will share an automation script to automatically upload CSV files to Google BigQuery using BigQuery API in Python.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#bigquery #googlebigquery #gbq

[meetkothari]

Hello Sir You are doing great please continue uploading more videos regarding BigQuery python API.

[suridtheanalyst]

Hi man thanks for uploading great contents. Will buy you copy if I make money

[AliPaul-pbci]

Thanks alot for the informative video. Can we do the bulk uploading using R instead of Python? I already have an R code doing some other operations, and wanted to encorporate the bulk upload in that, instead of using python.

[sriselvi]

Hi sir,
How to move file from local to GCS using Data fusion pipeline(I have used upload option in wrangler in data fusion and connected to gcs sink but it throwed me a error saying NODES ARE NOT CONNECTED)
What source should I use before the wrangler box (source->wrangler->GCS(sink))

[AlvaroRodriguez-tizb]

Hi, nice video, but I have a question, when I try to do the loop, the kernel in jupyter launch me the next error 'str' object has no attribute 'project'.... Why is that?

[RVPaintDepartmentCalifornia]

can i have you contact i would like to hire you