Working with JSON, Arrays, and Structs in BigQuery avis

Rishav C. · Examiné il y a environ un mois

Farheen F. · Examiné il y a environ un mois

Ketan S. · Examiné il y a environ un mois

Suvojeet P. · Examiné il y a environ un mois

Yashpal Singh C. · Examiné il y a environ un mois

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. · Examiné il y a environ un mois

Biswanath P. · Examiné il y a environ un mois

Diptesh C. · Examiné il y a environ un mois

Umair A. · Examiné il y a environ un mois

Eitaro T. · Examiné il y a environ un mois

Anjali K. · Examiné il y a environ un mois

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

秀人 Hideto Shibao 芝. · Examiné il y a environ un mois

Marko P. · Examiné il y a environ un mois

Martina C. · Examiné il y a environ un mois

Ronald Alejandro R. · Examiné il y a environ un mois

poornima S. · Examiné il y a environ un mois

Chakka Chenna J. · Examiné il y a environ un mois

Abdul Mazeed S. · Examiné il y a environ un mois

Kaori S. · Examiné il y a environ un mois

Aline A. · Examiné il y a environ un mois

Dmitrii D. · Examiné il y a environ un mois

Swastika M. · Examiné il y a environ un mois

Devendra V. · Examiné il y a environ un mois

Peng T. · Examiné il y a environ un mois

david b. · Examiné il y a environ un mois