Working with JSON, Arrays, and Structs in BigQuery recensioni

Jaewoo S. · Recensione inserita 6 mesi fa

safouan e. · Recensione inserita 6 mesi fa

Bindu J. · Recensione inserita 6 mesi fa

sirvan b. · Recensione inserita 6 mesi fa

sirvan b. · Recensione inserita 6 mesi fa

Rene G. · Recensione inserita 6 mesi fa

ERIC N. · Recensione inserita 6 mesi fa

Anderson J. · Recensione inserita 6 mesi fa

Ninad M. · Recensione inserita 6 mesi fa

Akash D. · Recensione inserita 6 mesi fa

郷 三. · Recensione inserita 6 mesi fa

SaiShankar B. · Recensione inserita 6 mesi fa

Jan C. · Recensione inserita 6 mesi fa

gerardo g. · Recensione inserita 6 mesi fa

Temesgen F. · Recensione inserita 6 mesi fa

Swastika M. · Recensione inserita 6 mesi fa

Ninad M. · Recensione inserita 6 mesi fa

Rishav C. · Recensione inserita 6 mesi fa

Farheen F. · Recensione inserita 6 mesi fa

Ketan S. · Recensione inserita 6 mesi fa

Suvojeet P. · Recensione inserita 6 mesi fa

Yashpal Singh C. · Recensione inserita 6 mesi fa

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. · Recensione inserita 6 mesi fa

Biswanath P. · Recensione inserita 6 mesi fa

Diptesh C. · Recensione inserita 6 mesi fa