From the course: Learning BigQuery

Unlock this course with a free trial

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

Querying a simple BigQuery table

Querying a simple BigQuery table - BigQuery Tutorial

From the course: Learning BigQuery

Start my 1-month free trial Buy for my team

Querying a simple BigQuery table

“

- [Instructor] Now that we have created a big query table, we can focus on working with it. For that, well, first, let's scroll down here, and take a look at the first schema for the table. At some point in its lifetime, it is possible you will need to edit the schema, which you can do by hitting this button, and then making the required changes. You could change the properties of existing fields or you could add new ones. I just leave things as they are, and exit out of this view, and then let's move on to the table details. And this is where we can take a look at some interesting information. Beyond the table id, we can also check out the size of the table, which will give us an indication of how much data will be processed, if we were to run queries against it. And this, of course, will influence the price we pay for querying the data. Long term storage size points to the data, that has not been accessed in the last 90…

Contents