Como trabalhar com dados dos tipos JSON, matriz e struct no BigQuery avaliações

Rishav C. · Revisado há about 1 month

Farheen F. · Revisado há about 1 month

Ketan S. · Revisado há about 1 month

Suvojeet P. · Revisado há about 1 month

Yashpal Singh C. · Revisado há about 1 month

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. · Revisado há about 1 month

Biswanath P. · Revisado há about 1 month

Diptesh C. · Revisado há about 1 month

Umair A. · Revisado há about 1 month

Eitaro T. · Revisado há about 1 month

Anjali K. · Revisado há about 1 month

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

秀人 Hideto Shibao 芝. · Revisado há about 1 month

Marko P. · Revisado há about 1 month

Martina C. · Revisado há about 1 month

Ronald Alejandro R. · Revisado há about 1 month

poornima S. · Revisado há about 1 month

Chakka Chenna J. · Revisado há about 1 month

Abdul Mazeed S. · Revisado há about 1 month

Kaori S. · Revisado há about 1 month

Aline A. · Revisado há about 1 month

Dmitrii D. · Revisado há about 1 month

Swastika M. · Revisado há about 1 month

Devendra V. · Revisado há about 1 month

Peng T. · Revisado há about 1 month

david b. · Revisado há about 1 month