Working with JSON, Arrays, and Structs in BigQuery Reviews

OLADELE IDRIS M. · Reviewed أكثر من سنتين ago

Jayanta P. · Reviewed أكثر من سنتين ago

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 أكثر من سنتين ago

Nikolaos K. · Reviewed أكثر من سنتين ago

Edelmiro F. · Reviewed أكثر من سنتين ago

Pragati T. · Reviewed أكثر من سنتين ago

Joseph V. · Reviewed أكثر من سنتين ago

Fernando A. · Reviewed أكثر من سنتين ago

Omkar N. · Reviewed أكثر من سنتين ago

Saloni G. · Reviewed أكثر من سنتين ago

Luan Cristopher V. · Reviewed أكثر من سنتين ago

Anirban M. · Reviewed أكثر من سنتين ago

Ondra S. · Reviewed أكثر من سنتين ago

Georgios G. · Reviewed أكثر من سنتين ago

Renan R. · Reviewed أكثر من سنتين 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 أكثر من سنتين ago

Nyíri T. · Reviewed أكثر من سنتين ago

Omar N. · Reviewed أكثر من سنتين ago

Corentin C. · Reviewed أكثر من سنتين ago

丸山 拓也 T. · Reviewed أكثر من سنتين ago

Abhijit S. · Reviewed أكثر من سنتين ago

NICOLAS ESTEBAN M. · Reviewed أكثر من سنتين ago

Karthikeyan M. · Reviewed أكثر من سنتين 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 أكثر من سنتين ago

Terri T. · Reviewed أكثر من سنتين ago