One of the great things I'm going to demo now, is how you can actually ingest a JSON file, which has a parent child relationship of fields directly into BigQuery. So, let's take a look at how you can do that. So here's the end result. You're going to need a lot more experience querying nested and repeated data structures in our advanced BigQuery course, but first let's see you can actually ingest a JSON file. So, the file that we're going to be working with is in traditional relational database world, would be to separate tables. It is a person's table which has first name, last name, date of birth, and the addresses table of all the different addresses that that person has lived. You can see these blank rows here, that means this particular person Jane is associated with those two addresses. One in New York and one in New Jersey and John has these two addresses here. What that actually looks like inside of the JSON file is like this. So you've got a JSON file and it has two different objects here and we have the fields and the field values you just set your JSON file up in the correct format, I'll link more examples and best practices on formatting your JSON files. Once you got that all set up, all you have to do when you create a new dataset and we'll just call this demo. In here I'm going to create a new table as you saw before. I'm going to call it json_example and instead of specifying all the different fields that are available, we're going to actually have an audit detector. But the key thing is, the file format instead of CSV, we're going to actually have it be newline delimited JSON. So click on that, let's find our JSON file, and create the table. After that's been created, boom you'll see the structure of your JSON, as you might expect it right here. So we have addresses, which is the data field type as we're going to cover more advanced BigQuery course is actually called a struct, which allows it to have child fields inside of it so flexible container. Other just regular fields like dates and strings for the date of birth, first_name, last_name. Previewing out, what you'll notice is that, if you select the JSON view, this is pretty much exactly as you would expect it. So JSON much like what we had here is now inside of BigQuery. So, to wrap up, you can just JSON just like any other normal filed time just through the web UI ingesting it like a CSV file. If you're curious, if you want to know more about how you can actually query these nested and repeated fields, stick around for the next course on advanced BigQuery concepts. Back to the lectures.
