Working with JSON and Array data in BigQuery Reviews

Manoj M. · Reviewed yaklaşık 5 yıl ago

Soumi G. · Reviewed yaklaşık 5 yıl ago

Aditya T. · Reviewed yaklaşık 5 yıl ago

Ashutosh R. · Reviewed yaklaşık 5 yıl ago

good

sudhanshu r. · Reviewed yaklaşık 5 yıl ago

Tom M. · Reviewed yaklaşık 5 yıl ago

SURESH K. · Reviewed yaklaşık 5 yıl ago

Abhijeet K. · Reviewed yaklaşık 5 yıl ago

Aditya S. · Reviewed yaklaşık 5 yıl ago

Zehra A. · Reviewed yaklaşık 5 yıl ago

SANJANA C. · Reviewed yaklaşık 5 yıl ago

Subhash M. · Reviewed yaklaşık 5 yıl ago

Shivansh P. · Reviewed yaklaşık 5 yıl ago

Namratha N. · Reviewed yaklaşık 5 yıl ago

Mithilesh P. · Reviewed yaklaşık 5 yıl ago

Sanket M. · Reviewed yaklaşık 5 yıl ago

I really liked the "solve-yourself" lab questions! However, I have something I can't get my head around. When experimenting with the lab questions, I came to the following conclusion: - UNNEST didn't seem to affect the queries at all. Compare the following queries: `SELECT p.name, split_time FROM racing.race_results r, r.participants p, p.splits split_time WHERE split_time = 23.2` with the suggested lab question solution. There doesn't seem to be a difference? - Furthermore, if I didn't add an alias to p.splits, the query didn't work no matter how much I unnested. It would be great if you could look into these things, because other than that, this is a great lab!

Damir B. · Reviewed yaklaşık 5 yıl ago

Sai K. · Reviewed yaklaşık 5 yıl ago

Subham S. · Reviewed yaklaşık 5 yıl ago

Muskaan G. · Reviewed yaklaşık 5 yıl ago

Rohan c. · Reviewed yaklaşık 5 yıl ago

Vijaya Bhaskar Reddy M. · Reviewed yaklaşık 5 yıl ago

Kevin L. · Reviewed yaklaşık 5 yıl ago

Great

Probhat M. · Reviewed yaklaşık 5 yıl ago

Eric B. · Reviewed yaklaşık 5 yıl ago