Working with JSON, Arrays, and Structs in BigQuery Reviews

Some referenced fields in the ga_sessions_20170801 table have different letter cases, than as written in lab instructions. Also in the task before the last one, you can ommit the UNNEST commands, and BigQuery still displays correct result. Only the lab will not accept it, even when it is correct.

Zbyněk Š. · Reviewed מעל 2 שנים ago

Nikolaos K. · Reviewed מעל 2 שנים ago

Edelmiro F. · Reviewed מעל 2 שנים ago

Pragati T. · Reviewed מעל 2 שנים ago

Joseph V. · Reviewed מעל 2 שנים ago

Fernando A. · Reviewed מעל 2 שנים ago

Omkar N. · Reviewed מעל 2 שנים ago

Saloni G. · Reviewed מעל 2 שנים ago

Luan Cristopher V. · Reviewed מעל 2 שנים ago

Anirban M. · Reviewed מעל 2 שנים ago

Ondra S. · Reviewed מעל 2 שנים ago

Georgios G. · Reviewed מעל 2 שנים ago

Renan R. · Reviewed מעל 2 שנים ago

I like that there are summary after each section to recap what was learnt. However, for the last few queries, it seems like UNNEST was unnecessary and the same result will still be returned without using UNNEST.

Cherie P. · Reviewed מעל 2 שנים ago

Nyíri T. · Reviewed מעל 2 שנים ago

Omar N. · Reviewed מעל 2 שנים ago

Corentin C. · Reviewed מעל 2 שנים ago

丸山 拓也 T. · Reviewed מעל 2 שנים ago

Abhijit S. · Reviewed מעל 2 שנים ago

NICOLAS ESTEBAN M. · Reviewed מעל 2 שנים ago

Karthikeyan M. · Reviewed מעל 2 שנים ago

The queries with cross joins or commas and unnest can be run without the unnest part. They will work and yield the same result (I think its unnesting under the hood) but they won't count as the right answer in the progress check. Maybe you'd like to add those too

Valeria S. · Reviewed מעל 2 שנים ago

Terri T. · Reviewed מעל 2 שנים ago

Inamul H. · Reviewed מעל 2 שנים ago

Elangovan K. · Reviewed מעל 2 שנים ago