From the course: Learning BigQuery

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Uploading data to create a BigQuery table

Uploading data to create a BigQuery table - BigQuery Tutorial

From the course: Learning BigQuery

Start my 1-month free trial Buy for my team

Uploading data to create a BigQuery table

“

- [Instructor] While we previously saw how we can create an empty table and then populate it with data with INSERT statements, we will now explore a more common use case for BigQuery users where a table is created out of existing data. For this, we will head over to the loony_university dataset and choose to create a new table. And this time, the source will not be an empty table, but instead, we will upload a CSV file from our own file system for which the Upload option can be selected. There are some restrictions with the size of the file which we can upload. So this needs to remain within 100 MB. However, for larger files, we can still bring them into BigQuery as long as we move them into the Google Cloud Storage first. Let's proceed then to browse our file systems for the file to upload. And then navigate over to movies_info.csv. This file is included in the course materials. Alternatively, it may also be…

Contents