Crea un data warehouse con BigQuery: Challenge Lab recensioni

Finally fixed the lab!

Ricardo Miguel N. · Recensione inserita circa 4 anni fa

Eugenio M. · Recensione inserita circa 4 anni fa

Fabrizio E. · Recensione inserita circa 4 anni fa

Shasank D. · Recensione inserita circa 4 anni fa

Trần V. · Recensione inserita circa 4 anni fa

Alexandru H. · Recensione inserita circa 4 anni fa

error lab

Minh N. · Recensione inserita circa 4 anni fa

Jonathan B. · Recensione inserita circa 4 anni fa

Juan Jose G. · Recensione inserita circa 4 anni fa

Gino P. · Recensione inserita circa 4 anni fa

Stewart N. · Recensione inserita circa 4 anni fa

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. · Recensione inserita circa 4 anni fa

Oleksandr V. · Recensione inserita circa 4 anni fa

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. · Recensione inserita circa 4 anni fa

Nguyễn P. · Recensione inserita circa 4 anni fa

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. · Recensione inserita circa 4 anni fa

!!! 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. · Recensione inserita circa 4 anni fa

BUG in task 1. LAB not working.

Pol G. · Recensione inserita circa 4 anni fa

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

Gino P. · Recensione inserita circa 4 anni fa

Đằng Giang Q. · Recensione inserita circa 4 anni fa

Fix this lab

Raúl Eduardo V. · Recensione inserita circa 4 anni fa

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. · Recensione inserita circa 4 anni fa

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

Oussama B. · Recensione inserita circa 4 anni fa