Build a Data Warehouse with BigQuery: Challenge Lab Reviews

There's a bug on the challenge, when it's fixed i'll try again.

Nicholas L. · Reviewed over 3 years ago

Łukasz B. · Reviewed over 3 years ago

It has an errorin Task 1. I tried using create table with DDL (create and replace table partition by ... as select * from table) but it didn't copy any records.

Mỹ Tiên B. · Reviewed over 3 years ago

Alberto L. · Reviewed over 3 years ago

It has an errorin Task 1. I tried using create table with DDL (create and replace table partition by ... as select * from table) but it didn't copy any records.

Mỹ Tiên B. · Reviewed over 3 years ago

Công Sơn P. · Reviewed over 3 years ago

Unable to complete the lab

Mauricio M. · Reviewed over 3 years ago

Unable to complete the lab

Mauricio M. · Reviewed over 3 years ago

Review

Yesner S. · Reviewed over 3 years ago

when i create the partition table, dont fill with information with this query CREATE OR REPLACE TABLE covid_279.oxford_policy_tracker_986 PARTITION BY date OPTIONS( partition_expiration_days=360, description="oxford_policy_tracker table" ) AS SELECT * FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` WHERE alpha_3_code NOT IN ('GBR', 'BRA', 'CAN','USA')

Gino P. · Reviewed over 3 years ago

Gogineni G. · Reviewed over 3 years ago

I created a table based on the schema, but the data did not import correctly, and then the second step said that I didn't even have a table, though it was obviously there.

Rachel R. · Reviewed over 3 years ago

david c. · Reviewed over 3 years ago

Felipe C. · Reviewed over 3 years ago

Felipe C. · Reviewed over 3 years ago

The lab isn't working. Try it and see for yourself.

Chris G. · Reviewed over 3 years ago

Lex K. · Reviewed over 3 years ago

You can't create a table with partition_expiration_days=360, because all records are older than that and the table is empty

Monika S. · Reviewed over 3 years ago

Mirek C. · Reviewed over 3 years ago

Ana Katherine C. · Reviewed over 3 years ago

BENJAMIN A. · Reviewed over 3 years ago

Ken L. · Reviewed over 3 years ago

Please fix the bug in the first task

Oziel A. · Reviewed over 3 years ago

amada b. · Reviewed over 3 years ago

Immaculee A. · Reviewed over 3 years ago