Build a Data Warehouse with BigQuery: Challenge Lab avis

Eugenio M. · Examiné il y a environ 4 ans

Fabrizio E. · Examiné il y a environ 4 ans

Shasank D. · Examiné il y a environ 4 ans

Trần V. · Examiné il y a environ 4 ans

Alexandru H. · Examiné il y a environ 4 ans

error lab

Minh N. · Examiné il y a environ 4 ans

Jonathan B. · Examiné il y a environ 4 ans

Juan Jose G. · Examiné il y a environ 4 ans

Gino P. · Examiné il y a environ 4 ans

Stewart N. · Examiné il y a environ 4 ans

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. · Examiné il y a environ 4 ans

Oleksandr V. · Examiné il y a environ 4 ans

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. · Examiné il y a environ 4 ans

Nguyễn P. · Examiné il y a environ 4 ans

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. · Examiné il y a environ 4 ans

!!! 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. · Examiné il y a environ 4 ans

BUG in task 1. LAB not working.

Pol G. · Examiné il y a environ 4 ans

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

Gino P. · Examiné il y a environ 4 ans

Đằng Giang Q. · Examiné il y a environ 4 ans

Fix this lab

Raúl Eduardo V. · Examiné il y a environ 4 ans

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. · Examiné il y a environ 4 ans

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

Oussama B. · Examiné il y a environ 4 ans

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

Sofiia L. · Examiné il y a environ 4 ans