Build a Data Warehouse with BigQuery: Challenge Lab Reviews

can't check point `

Thinh T. · Reviewed over 3 years ago

Thinh T. · Reviewed over 3 years ago

I execute this query and cant verify my progress first step#standardSQL CREATE OR REPLACE TABLE covid_598.oxford_policy_tracker_527 PARTITION BY date OPTIONS ( partition_expiration_days=360 ) AS ( SELECT oxford.* FROM bigquery-public-data.covid19_govt_response AS oxford WHERE alpha_3_code NOT IN ("GBR", "BRA", "CAN", "USA") )

Ricardo Miguel N. · Reviewed over 3 years ago

Sử Thanh T. · Reviewed over 3 years ago

Nhan N. · Reviewed over 3 years ago

Lê V. · Reviewed over 3 years ago

Quân L. · Reviewed over 3 years ago

Lăng T. · Reviewed over 3 years ago

Kamil P. · Reviewed over 3 years ago

Nhật T. · Reviewed over 3 years ago

Bug in task 1, I have report it to support online (Zoyeb Sayed)

Z L. · Reviewed over 3 years ago

the partition expiry date makes the target table empty

Vu L. · Reviewed over 3 years ago

Saju S. · Reviewed over 3 years ago

No have data to do the task 1

Châu T. · Reviewed over 3 years ago

Quyên T. · Reviewed over 3 years ago

Cannot pass task 1 even correct columns. Think it is a bug.

Phú L. · Reviewed over 3 years ago

Nguyen S. · Reviewed over 3 years ago

Andrea Yadira M. · Reviewed over 3 years ago

Andrea Yadira M. · Reviewed over 3 years ago

Mario R. · Reviewed over 3 years ago

partition date is beyond 360 days (10-Sep-2021 or 14-Sep-2021 from memory) so when you partition by date with partition_expiration_days=360, you end up with an empty dataset (i.e., today is 24-Sep-2022, so there will be no data for the last 365 days).

Andrew P. · Reviewed over 3 years ago

João Vitor B. · Reviewed over 3 years ago

Andrew P. · Reviewed over 3 years ago

Lăng T. · Reviewed over 3 years ago

Hoàng Gia T. · Reviewed over 3 years ago