From the course: Learning BigQuery

Unlock this course with a free trial

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

Materialized views in BigQuery

Materialized views in BigQuery - BigQuery Tutorial

From the course: Learning BigQuery

Start my 1-month free trial Buy for my team

Materialized views in BigQuery

“

- [Instructor] It's now time for us to explore materialized views in BigQuery which can not only hide away the complexity of an underlying query, but can also reduce the amount of data to be processed when running queries against the view. We will continue working with the fdic_banks dataset, which of course contains the institutions and locations tables. And we will once again, create a view by joining the data in these tables. For a materialized view however, the source tables need to be in the same dataset as the view itself, at least if you would like to make use of one of the cool features of materialized views which is smart tuning. In that regard, let's now choose to copy this dataset, which will in fact create copies of the tables it contains in the specified destination. The destination needs to be a dataset. And in this case I'm going to point us to the loony_university dataset. So the locations and…

Contents