🆕 GSP340 Build and Optimize Data Warehouses with BigQuery: Challenge Lab | 🐱🏍 GCP learning tour
Step-by-step Guide 👉 https://chriskyfung.github.io/blog/qw...
⏱ Timestamps
00:00 Start Lab and Overview
00:22 Task 1: Create a table partitioned by date
01:29 Task 2: Add new columns to your table
01:55 Task 3: Add country population data to the population column
02:53 Task 4: Add country area data to the country_area column
03:22 Task 5: Populate the mobility record data
03:55 Task 6: Query missing data in population & country_area columns
Congratulations!
#Qwiklabs #BigQuery #ChallengeLab
Subscribe for more videos: / @chriskyfung-research
![ЛЕГИОНКА ДЕЛО ГОВОРИТ [DOTA2]](https://images.videosashka.com/watch/DHkwP_b-NiI)
