title: How to upload .gz files into Google Big Query?
body: <p>I have an idea of a 90 GB <code>.csv</code> file that I want to make on my local computer and then upload into Google BigQuery for analysis. I create this file by combining thousands of smaller <code>.csv</code> files into 10 medium-sized files and then combining those medium-sized files into the 90 GB file, which I then want to move to GBQ. I am struggling with this project because my computer keeps crashing from memory issues. From <a href="https://www.youtube.com/watch?v=v9bGNHqyA6M" rel="nofollow noreferrer">this</a> video I understood that I should first transform the medium-sized <code>.csv</code> files (about 9 GB each) into <code>.gz</code> files (about 500MB each), and then upload those <code>.gz</code> files into Google Cloud Storage. Next, I would create an empty Table (in Google BigQuery / Datasets) and then append all of those files to the created Table. The issue I am having is finding some kind of tutorial about how to do this or and documentation of how to do this. I am new to the Google Platform so maybe this is a very easy job that can be done with 1 click somewhere, but all I was able to find was from the video that I linked above. Where can I find some help or documentation or tutorials or videos on how people do this? Do I have the correct idea on the workflow? Is there some better way (like using some downloadable GUI to upload stuff)?</p>