Build a Data Warehouse with BigQuery: Challenge Lab Reviews

Fabrizio E. · Reviewed حوالي 4 سنوات ago

Shasank D. · Reviewed حوالي 4 سنوات ago

Trần V. · Reviewed حوالي 4 سنوات ago

Alexandru H. · Reviewed حوالي 4 سنوات ago

error lab

Minh N. · Reviewed حوالي 4 سنوات ago

Jonathan B. · Reviewed حوالي 4 سنوات ago

Juan Jose G. · Reviewed حوالي 4 سنوات ago

Gino P. · Reviewed حوالي 4 سنوات ago

Stewart N. · Reviewed حوالي 4 سنوات ago

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. · Reviewed حوالي 4 سنوات ago

Oleksandr V. · Reviewed حوالي 4 سنوات ago

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. · Reviewed حوالي 4 سنوات ago

Nguyễn P. · Reviewed حوالي 4 سنوات ago

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. · Reviewed حوالي 4 سنوات ago

!!! 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. · Reviewed حوالي 4 سنوات ago

BUG in task 1. LAB not working.

Pol G. · Reviewed حوالي 4 سنوات ago

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

Gino P. · Reviewed حوالي 4 سنوات ago

Đằng Giang Q. · Reviewed حوالي 4 سنوات ago

Fix this lab

Raúl Eduardo V. · Reviewed حوالي 4 سنوات ago

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. · Reviewed حوالي 4 سنوات ago

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

Oussama B. · Reviewed حوالي 4 سنوات ago

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

Sofiia L. · Reviewed حوالي 4 سنوات ago

Data is not updated!

Paweł F. · Reviewed حوالي 4 سنوات ago