Membangun Data Warehouse dengan BigQuery: Challenge Lab Ulasan

Fabrizio E. · Diulas sekitar 4 tahun lalu

Shasank D. · Diulas sekitar 4 tahun lalu

Trần V. · Diulas sekitar 4 tahun lalu

Alexandru H. · Diulas sekitar 4 tahun lalu

error lab

Minh N. · Diulas sekitar 4 tahun lalu

Jonathan B. · Diulas sekitar 4 tahun lalu

Juan Jose G. · Diulas sekitar 4 tahun lalu

Gino P. · Diulas sekitar 4 tahun lalu

Stewart N. · Diulas sekitar 4 tahun lalu

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. · Diulas sekitar 4 tahun lalu

Oleksandr V. · Diulas sekitar 4 tahun lalu

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. · Diulas sekitar 4 tahun lalu

Nguyễn P. · Diulas sekitar 4 tahun lalu

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. · Diulas sekitar 4 tahun lalu

!!! 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. · Diulas sekitar 4 tahun lalu

BUG in task 1. LAB not working.

Pol G. · Diulas sekitar 4 tahun lalu

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

Gino P. · Diulas sekitar 4 tahun lalu

Đằng Giang Q. · Diulas sekitar 4 tahun lalu

Fix this lab

Raúl Eduardo V. · Diulas sekitar 4 tahun lalu

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. · Diulas sekitar 4 tahun lalu

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

Oussama B. · Diulas sekitar 4 tahun lalu

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

Sofiia L. · Diulas sekitar 4 tahun lalu

Data is not updated!

Paweł F. · Diulas sekitar 4 tahun lalu