关于“使用 BigQuery 构建数据仓库：实验室挑战赛”的评价

Fabrizio E. · 已于 about 4 years前审核

Shasank D. · 已于 about 4 years前审核

Trần V. · 已于 about 4 years前审核

Alexandru H. · 已于 about 4 years前审核

error lab

Minh N. · 已于 about 4 years前审核

Jonathan B. · 已于 about 4 years前审核

Juan Jose G. · 已于 about 4 years前审核

Gino P. · 已于 about 4 years前审核

Stewart N. · 已于 about 4 years前审核

It is not possible to pass Task 1. Date expiration of 360 days for partition will remove all data from final table. See this query to check, it will return 0 rows: SELECT count(1) FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` where alpha_3_code not in( "GBR", "BRA", "CAN", "USA") and date > current_date() - 360; To finish this Lab I have to add 1 year to date column. insert into `covid_462.oxford_policy_tracker_647` SELECT country_name , alpha_3_code , region_name , region_code , date + 360 as date , school_closing , school_closing_flag , school_closing_notes , workplace_closing , workplace_closing_flag , workplace_closing_notes , cancel_public_events , cancel_public_events_flag , cancel_public_events_notes , restrictions_on_gatherings , restrictions_on_gatherings_flag , restrictions_on_gatherings_notes , close_public_transit , close_public_transit_flag , close_public_transit_notes , stay_at_home_requirements , stay_at_home_requirements_flag , stay_at_home_requirements_notes , restrictions_on_internal_movement , restrictions_on_internal_movement_flag , restrictions_on_internal_movement_notes , international_travel_controls , international_travel_controls_notes , income_support , income_support_flag , income_support_notes , debt_contract_relief , debt_contract_relief_notes , fiscal_measures , fiscal_measures_notes , international_support , international_support_notes , public_information_campaigns , public_information_campaigns_flag , public_information_campaigns_notes , testing_policy , testing_policy_notes , contact_tracing , contact_tracing_notes , emergency_healthcare_investment , emergency_healthcare_investment_notes , vaccine_investment , vaccine_investment_notes , misc_wildcard , misc_wildcard_notes , confirmed_cases , deaths , stringency_index FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` where alpha_3_code not in ("GBR","BRA", "CAN","USA");

Viktor F. · 已于 about 4 years前审核

Oleksandr V. · 已于 about 4 years前审核

It is not possible to pass Task 1. Date expiration of 360 days for partition will remove all data from final table. See this query to check, it will return 0 rows: SELECT count(1) FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` where alpha_3_code not in( "GBR", "BRA", "CAN", "USA") and date > current_date() - 360;

Viktor F. · 已于 about 4 years前审核

Nguyễn P. · 已于 about 4 years前审核

Please ensure you've copied all columns from the oxford_policy_tracker table. There is no data to display. Records read: 193128 Records written: 131847

Oussama B. · 已于 about 4 years前审核

!!! DATE_DIFF(MAX(date), CURRENT_DATE(), DAY) on the table [covid19_govt_response.oxford_policy_tracker] returns -388 days_ago So at the very 1st step I created empty table & the 1st check FAILS (not pass the checks) Please refresh the src dataset or Lab expiration checks (360 days)!

OLEKSANDR S. · 已于 about 4 years前审核

BUG in task 1. LAB not working.

Pol G. · 已于 about 4 years前审核

the expiration for partition table is wrong, the number need to be for more days

Gino P. · 已于 about 4 years前审核

Đằng Giang Q. · 已于 about 4 years前审核

Fix this lab

Raúl Eduardo V. · 已于 about 4 years前审核

Please ensure you've copied all columns from the oxford_policy_tracker table. There is no data to display. Records read: 193128 Records written: 131847

Oussama B. · 已于 about 4 years前审核

Please ensure you've copied all columns from the oxford_policy_tracker table.

Oussama B. · 已于 about 4 years前审核

Can't go through 1 task - there is no data. Just wasted time. So dissapointed.

Sofiia L. · 已于 about 4 years前审核

Data is not updated!

Paweł F. · 已于 about 4 years前审核