Build a Data Warehouse with BigQuery: Challenge Lab Reviews

360 days cause missing all data, have to change to wider window

Quân P. · Reviewed أكثر من 3 سنوات ago

John E. · Reviewed أكثر من 3 سنوات ago

Tran T. · Reviewed أكثر من 3 سنوات ago

Tran T. · Reviewed أكثر من 3 سنوات ago

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 أكثر من 3 سنوات ago

Yên Đ. · Reviewed أكثر من 3 سنوات ago

Saju S. · Reviewed أكثر من 3 سنوات ago

Quân C. · Reviewed أكثر من 3 سنوات ago

Miriam R. · Reviewed أكثر من 3 سنوات ago

Problems with Task 1

JUAN M. · Reviewed أكثر من 3 سنوات ago

Said M. · Reviewed أكثر من 3 سنوات ago

Lanka S. · Reviewed أكثر من 3 سنوات ago

Matheus A. · Reviewed أكثر من 3 سنوات ago

Tran T. · Reviewed أكثر من 3 سنوات ago

Lanka S. · Reviewed أكثر من 3 سنوات ago

Saju S. · Reviewed أكثر من 3 سنوات ago

Tran D. · Reviewed أكثر من 3 سنوات ago

Emily D. · Reviewed أكثر من 3 سنوات 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 أكثر من 3 سنوات ago

Venkata Sai Aditya G. · Reviewed أكثر من 3 سنوات ago

Vignesh Reddy B. · Reviewed أكثر من 3 سنوات 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 أكثر من 3 سنوات 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 أكثر من 3 سنوات ago

The first task doesn't work

Oleksii N. · Reviewed أكثر من 3 سنوات ago

Cannot complete task 1

Hoàng Tín T. · Reviewed أكثر من 3 سنوات ago