Creating Date-Partitioned Tables in BigQuery Reviews

The issue still in the second "check my progress"

Alberto Josué C. · Reviewed ما يقرب من 4 سنوات ago

Task number 2 will not show completed

Raisa J. · Reviewed ما يقرب من 4 سنوات ago

Task2 score not updated

Vetrivel D. · Reviewed ما يقرب من 4 سنوات ago

not good - table created but can't check progress

Rudolf E. · Reviewed ما يقرب من 4 سنوات ago

At "Create a new partitioned table based on date" the "Check my progress" button does not work.

Anna U. · Reviewed ما يقرب من 4 سنوات ago

The partitioned table was created by using the provided query but the system didn't recognize it and passed the checkpoint.

Olivia C. · Reviewed ما يقرب من 4 سنوات ago

Divya S. · Reviewed ما يقرب من 4 سنوات ago

lab could not confirm I created partition_by_day table.

Samantha L. · Reviewed ما يقرب من 4 سنوات ago

Task 2 error

Alvin Z. · Reviewed ما يقرب من 4 سنوات ago

JUAN M. · Reviewed ما يقرب من 4 سنوات ago

Alberto Josué C. · Reviewed ما يقرب من 4 سنوات ago

It is not possible to finish the lab, I have reported it 5 times and I have not received a response

GONZALO ANDRES M. · Reviewed ما يقرب من 4 سنوات ago

Alberto Josué C. · Reviewed ما يقرب من 4 سنوات ago

JUAN M. · Reviewed ما يقرب من 4 سنوات ago

Rajdeep S. · Reviewed ما يقرب من 4 سنوات ago

JYOTI RANJAN P. · Reviewed ما يقرب من 4 سنوات ago

Task2 score not updated

Vetrivel D. · Reviewed ما يقرب من 4 سنوات ago

Naafi M. · Reviewed ما يقرب من 4 سنوات ago

after completing the assessment , it still says that complete the assessment

Priya N. · Reviewed ما يقرب من 4 سنوات ago

Jaime N. · Reviewed ما يقرب من 4 سنوات ago

had to change query

Marc R. · Reviewed ما يقرب من 4 سنوات ago

There is problem in the below query its not creating any record #standardSQL CREATE OR REPLACE TABLE ecommerce.partition_by_day PARTITION BY date_formatted OPTIONS( description="a table partitioned by date" ) AS SELECT DISTINCT PARSE_DATE("%Y%m%d", date) AS date_formatted, fullvisitorId FROM `data-to-insights.ecommerce.all_sessions_raw`

Prosenjit R. · Reviewed ما يقرب من 4 سنوات ago

Sudhanshu S. · Reviewed ما يقرب من 4 سنوات ago

Clément B. · Reviewed ما يقرب من 4 سنوات ago

Error in task 2, but is working with --- SELECT DISTINCT DATE('2022-09-06') AS date_formatted ---

Pedro E. · Reviewed ما يقرب من 4 سنوات ago