Opinie (Build a Data Warehouse with BigQuery: Challenge Lab)

Eugenio M. · Sprawdzono około 4 lata temu

Fabrizio E. · Sprawdzono około 4 lata temu

Shasank D. · Sprawdzono około 4 lata temu

Trần V. · Sprawdzono około 4 lata temu

Alexandru H. · Sprawdzono około 4 lata temu

error lab

Minh N. · Sprawdzono około 4 lata temu

Jonathan B. · Sprawdzono około 4 lata temu

Juan Jose G. · Sprawdzono około 4 lata temu

Gino P. · Sprawdzono około 4 lata temu

Stewart N. · Sprawdzono około 4 lata temu

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. · Sprawdzono około 4 lata temu

Oleksandr V. · Sprawdzono około 4 lata temu

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. · Sprawdzono około 4 lata temu

Nguyễn P. · Sprawdzono około 4 lata temu

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. · Sprawdzono około 4 lata temu

!!! 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. · Sprawdzono około 4 lata temu

BUG in task 1. LAB not working.

Pol G. · Sprawdzono około 4 lata temu

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

Gino P. · Sprawdzono około 4 lata temu

Đằng Giang Q. · Sprawdzono około 4 lata temu

Fix this lab

Raúl Eduardo V. · Sprawdzono około 4 lata temu

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. · Sprawdzono około 4 lata temu

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

Oussama B. · Sprawdzono około 4 lata temu

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

Sofiia L. · Sprawdzono około 4 lata temu