From the course: Learning BigQuery

Unlock this course with a free trial

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

Saving query results using views

Saving query results using views - BigQuery Tutorial

From the course: Learning BigQuery

Start my 1-month free trial Buy for my team

Saving query results using views

“

- [Instructor] It's now time for us to take a look at views when using BigQuery. And we will start off by creating a view into publicly accessible tables. Let's first take a look at the tables themselves. These are present in the BigQuery public data project which is made accessible to us by Google. I'm just going to scroll along in here, more specifically to the data set, FDIC banks. On expanding this, you'll note that there are two different tables here. One points to different banking institutions and then there is a locations table which contains information about branches of the banking institutions. Our goal is to create a view which combines the contents of these two tables. Before we get to that, let's take a look at the institution's table. Under table schema, you will note that there is a certificate number. This is a field which uniquely identifies an institution. Moving along then to the details of this…

Contents