From the course: Learning BigQuery
Join today to access over 25,300 courses taught by industry experts.
Configuring and using BigQuery caches - BigQuery Tutorial
From the course: Learning BigQuery
Configuring and using BigQuery caches
- [Narrator] We are now in a position to query the public table we just accessed, and while doing so, we will also explore how BigQuery caches query results so that the data can be retrieved faster the next time the query is run. First, take a look at the query which I have just pasted in a Query Editor. I'll first draw your attention to the front clause where we reference the population by country table, by specifying its full part, starting with the project name, BigQuery Public Data. Then the dataset name, World Bank Global Population, and only then do we specify the table name. The fields we project in the query results will include the country, country code, along with the populations in 1960 and 2018. We also project the difference in populations between these two years as an absolute change. We will also order the results in the descending order of this absolute change value. When you go on and execute this query,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.