Working with JSON, Arrays, and Structs in BigQuery Reviews

Ninad M. · Reviewed בערך חודש אחד ago

Rishav C. · Reviewed בערך חודש אחד ago

Farheen F. · Reviewed בערך חודש אחד ago

Ketan S. · Reviewed בערך חודש אחד ago

Suvojeet P. · Reviewed בערך חודש אחד ago

Yashpal Singh C. · Reviewed בערך חודש אחד ago

There was a typo in one of the bullet points in the STRUCTS section where it says "It's own alias" but since it is being used as a possessive pronoun, there should not be a comma and the correct typing would be "Its own alias". Also, the control+F nor the schema filters were working to find the correct count of structs or arrays in the schema within the lab. Not sure if this was an incognito window issue, something do do with the way Chrome loads the data in the page on a MacBook or something else. Either way, I couldn't seem to find the right numbers without guessing. Even my manual scrolling and counting didn't seem to match what the lab questions expected. And one of the last questions/challenges involved finding the racer with a 23.2 split_time. The solution required me to use UNNEST() but it worked without this. Gemini says that's because the comma implicitly UNNESTS but I don't recall seeing that explanation in the lab. I remember seeing that on implicitly cross joining, but not for unnesting.

Andrew F. · Reviewed בערך חודש אחד ago

Biswanath P. · Reviewed בערך חודש אחד ago

Diptesh C. · Reviewed בערך חודש אחד ago

Umair A. · Reviewed בערך חודש אחד ago

Eitaro T. · Reviewed בערך חודש אחד ago

Anjali K. · Reviewed בערך חודש אחד ago

Cloud Storage バケットがなく、ファイルを参照できないためファイル構造を指定できなかったため、進行できないで終了した

秀人 Hideto Shibao 芝. · Reviewed בערך חודש אחד ago

Marko P. · Reviewed בערך חודש אחד ago

Martina C. · Reviewed בערך חודש אחד ago

Ronald Alejandro R. · Reviewed בערך חודש אחד ago

poornima S. · Reviewed בערך חודש אחד ago

Chakka Chenna J. · Reviewed בערך חודש אחד ago

Abdul Mazeed S. · Reviewed בערך חודש אחד ago

Kaori S. · Reviewed בערך חודש אחד ago

Aline A. · Reviewed בערך חודש אחד ago

Dmitrii D. · Reviewed בערך חודש אחד ago

Swastika M. · Reviewed בערך חודש אחד ago

Devendra V. · Reviewed בערך חודש אחד ago

Peng T. · Reviewed בערך חודש אחד ago