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

Alberto L. · Revisado há about 4 years

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

Công Sơn P. · Revisado há about 4 years

Unable to complete the lab

Mauricio M. · Revisado há about 4 years

Unable to complete the lab

Mauricio M. · Revisado há about 4 years

Review

Yesner S. · Revisado há about 4 years

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

Gogineni G. · Revisado há about 4 years

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

david c. · Revisado há about 4 years

Felipe C. · Revisado há about 4 years

Felipe C. · Revisado há about 4 years

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

Chris G. · Revisado há about 4 years

Lex K. · Revisado há about 4 years

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

Mirek C. · Revisado há about 4 years

Ana Katherine C. · Revisado há about 4 years

BENJAMIN A. · Revisado há about 4 years

Ken L. · Revisado há about 4 years

Please fix the bug in the first task

Oziel A. · Revisado há about 4 years

amada b. · Revisado há about 4 years

Immaculee A. · Revisado há about 4 years

I was informed through chat that there are issues with this lab and that I would notified when fixed. I would expect when this is the case that a notice would be placed on the lab so as not to waste our time.

Ryan P. · Revisado há about 4 years

Immaculee A. · Revisado há about 4 years

Trung Nghia H. · Revisado há about 4 years