From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Load data from Cloud Storage

Load data from Cloud Storage

From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Start my 1-month free trial

Load data from Cloud Storage

- [Instructor] Let's now load data from Google Cloud storage and that through the command line shell. This is useful for scripting continuous and automatic loads from cloud storage. We have a file called normal ranges dot csv as part of the exercise files. We have already loaded that into a bucket called exercise lil under that a folder called data, in the Google Cloud storage. We are going to now use the Google Cloud shell to load this data into Big Query. I have Google Cloud shell already opened for you and here is the command that you have to use to run this load. The command starts with bq as the command which stands for Big Query then you indicate the location of where the source bucket is. The command is load, the source format is set to csv. It says auto detect which means to auto detect the schema. The destination table is going to be patient data dot normal ranges. Patient data being the data set and then finally the source data from where it was loaded from that is a Google…

Contents