From the course: Learning BigQuery

Unlock this course with a free trial

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

Reading JSON data into a BigQuery table

Reading JSON data into a BigQuery table - BigQuery Tutorial

From the course: Learning BigQuery

Start my 1-month free trial Buy for my team

Reading JSON data into a BigQuery table

“

- [Instructor] We will now quickly explore how data can be loaded into BigQuery from a JSON file which is residing on Google Cloud Storage. For this demo, we continue using the loony_university data set, and here, we choose to create a new table. The source, in this case, will be the Google Cloud Storage. And, at this point, I presume you already have a GCS bucket set up since once this selection is made we will need to navigate to it when we hit Browse. In my project, there is just one GCS bucket called loony-bucket, and inside of this, I have already uploaded a JSON file called a laptops_info. I'll just make the selection here, and keep in mind that this file is also part of the course materials. Alternatively, it can be downloaded from this location. Once we make the selection, the file format has automatically been set to JSON. We move on then and set a name for this table. I'll just call this laptops_info. This can be set…

Contents