Criar um data warehouse com o BigQuery: laboratório com desafio avaliações

Eugenio M. · Revisado há about 4 years

Fabrizio E. · Revisado há about 4 years

Shasank D. · Revisado há about 4 years

Trần V. · Revisado há about 4 years

Alexandru H. · Revisado há about 4 years

error lab

Minh N. · Revisado há about 4 years

Jonathan B. · Revisado há about 4 years

Juan Jose G. · Revisado há about 4 years

Gino P. · Revisado há about 4 years

Stewart N. · Revisado há about 4 years

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. · Revisado há about 4 years

Oleksandr V. · Revisado há about 4 years

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. · Revisado há about 4 years

Nguyễn P. · Revisado há about 4 years

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. · Revisado há about 4 years

!!! 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. · Revisado há about 4 years

BUG in task 1. LAB not working.

Pol G. · Revisado há about 4 years

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

Gino P. · Revisado há about 4 years

Đằng Giang Q. · Revisado há about 4 years

Fix this lab

Raúl Eduardo V. · Revisado há about 4 years

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. · Revisado há about 4 years

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

Oussama B. · Revisado há about 4 years

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

Sofiia L. · Revisado há about 4 years