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
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.