Build a Data Warehouse with BigQuery: Challenge Lab Reviews

Bug report: The oxford_policy_tracker table has max(date) as 2021-09-10 so after September 10, 2022, creating a partitioned table with expiration of 360 days will return a table with no data, making the first check always fail. I had to inject some dummy data (by union all a dummy row) to make this check pass.

Tuấn Hải L. · Reviewed over 3 years ago

Yên Đ. · Reviewed over 3 years ago

Saju S. · Reviewed over 3 years ago

Quân C. · Reviewed over 3 years ago

Miriam R. · Reviewed over 3 years ago

Problems with Task 1

JUAN M. · Reviewed over 3 years ago

Said M. · Reviewed over 3 years ago

Lanka S. · Reviewed over 3 years ago

Matheus A. · Reviewed over 3 years ago

Tran T. · Reviewed over 3 years ago

Lanka S. · Reviewed over 3 years ago

Saju S. · Reviewed over 3 years ago

Tran D. · Reviewed over 3 years ago

Emily D. · Reviewed over 3 years ago

It cannot be resolved, since the oxford_policy_tracker dataset has information from 2021-09-10, so to the current date it would be more than 360 days. And the generated tables with partition_expiration_days=360 will be empty.

José Iván G. · Reviewed over 3 years ago

Venkata Sai Aditya G. · Reviewed over 3 years ago

Vignesh Reddy B. · Reviewed over 3 years ago

Couldn't figure out the requirements for Task 1. I have tried setting expiration at the dataset level, table level, partition level (although it doesn't make sense to expire the partition since the data inside is already older than 360 days) but nothing works

George G. · Reviewed over 3 years ago

horrible lab, I cannot delete and recreate my table because even when I try to load data in, it doesn't load the data into the table correctly. somethings wrong in the UI side of things

Alex B. · Reviewed over 3 years ago

The first task doesn't work

Oleksii N. · Reviewed over 3 years ago

Cannot complete task 1

Hoàng Tín T. · Reviewed over 3 years ago

Duc N. · Reviewed over 3 years ago

Đức Trung T. · Reviewed over 3 years ago

Federico B. · Reviewed over 3 years ago