Working with JSON, Arrays, and Structs in BigQuery Reviews

Rishav C. · Reviewed около 1 месяца ago

Farheen F. · Reviewed около 1 месяца ago

Ketan S. · Reviewed около 1 месяца ago

Suvojeet P. · Reviewed около 1 месяца ago

Yashpal Singh C. · Reviewed около 1 месяца 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 около 1 месяца ago

Biswanath P. · Reviewed около 1 месяца ago

Diptesh C. · Reviewed около 1 месяца ago

Umair A. · Reviewed около 1 месяца ago

Eitaro T. · Reviewed около 1 месяца ago

Anjali K. · Reviewed около 1 месяца ago

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

秀人 Hideto Shibao 芝. · Reviewed около 1 месяца ago

Marko P. · Reviewed около 1 месяца ago

Martina C. · Reviewed около 1 месяца ago

Ronald Alejandro R. · Reviewed около 1 месяца ago

poornima S. · Reviewed около 1 месяца ago

Chakka Chenna J. · Reviewed около 1 месяца ago

Abdul Mazeed S. · Reviewed около 1 месяца ago

Kaori S. · Reviewed около 1 месяца ago

Aline A. · Reviewed около 1 месяца ago

Dmitrii D. · Reviewed около 1 месяца ago

Swastika M. · Reviewed около 1 месяца ago

Devendra V. · Reviewed около 1 месяца ago

Peng T. · Reviewed около 1 месяца ago

david b. · Reviewed около 1 месяца ago