BigQuery でデータ ウェアハウスを構築する: チャレンジラボ のレビュー

Montoro Mateos Eugenio · 約4年前にレビュー済み

Eyzaguirre Fabrizio · 約4年前にレビュー済み

Dave Shasank · 約4年前にレビュー済み

Văn Cường Trần · 約4年前にレビュー済み

Huc Alexandru · 約4年前にレビュー済み

error lab

Nguyễn Minh · 約4年前にレビュー済み

Bonnaud Jonathan · 約4年前にレビュー済み

Gutierrez Terraza Juan Jose · 約4年前にレビュー済み

Padilla Gino · 約4年前にレビュー済み

Nolan Stewart · 約4年前にレビュー済み

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");

Fedinchuk Viktor · 約4年前にレビュー済み

Vashchuk Oleksandr · 約4年前にレビュー済み

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;

Fedinchuk Viktor · 約4年前にレビュー済み

Phú Khang Nguyễn · 約4年前にレビュー済み

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

Ben Nasr Oussama · 約4年前にレビュー済み

!!! 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)!

SILIVIN OLEKSANDR · 約4年前にレビュー済み

BUG in task 1. LAB not working.

Gelabert Pol · 約4年前にレビュー済み

Gelabert Pol · 約4年前にレビュー済み

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

Padilla Gino · 約4年前にレビュー済み

Quách Đằng Giang · 約4年前にレビュー済み

Fix this lab

Villegas Leiva Raúl Eduardo · 約4年前にレビュー済み

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

Ben Nasr Oussama · 約4年前にレビュー済み

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

Ben Nasr Oussama · 約4年前にレビュー済み

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

Levchenko Sofiia · 約4年前にレビュー済み