MENU
Showing posts with label Build and Optimize Data Warehouses with BigQuery Challenge Lab. Show all posts
Showing posts with label Build and Optimize Data Warehouses with BigQuery Challenge Lab. Show all posts

Challenge Lab

Qwiklabs [GSP340]



GSP340

Task 1:

Create a table partitioned by date

code (A):


Task 2: Add new columns to your table

code (B)


Task 3: Add country population data to the population column

code (C):


Task 4: Add country area data to the country_area column

code (D):


Task 5: Populate the mobility record data

code (E)


Task 6: Query missing data in population & country_area columns

code (F):