Working with JSON, Arrays, and Structs in BigQuery Reviews

Jayanta P. · Reviewed больше 2 лет 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 больше 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