Working with JSON and Array data in BigQuery Reviews

This was a challenging and fun lab, I wish the previous ones were this interactive !

Philipp S. · Reviewed about 6 years ago

flavio A. · Reviewed about 6 years ago

Ricardo Salviano S. · Reviewed about 6 years ago

Rodrigo G. · Reviewed about 6 years ago

Carlos Eduardo J. · Reviewed about 6 years ago

Rodrigo M. · Reviewed about 6 years ago

ok.................

fernando p. · Reviewed about 6 years ago

Marcelo D. · Reviewed about 6 years ago

Swastik K. · Reviewed about 6 years ago

Very cool

Federico P. · Reviewed about 6 years ago

Peeter B. · Reviewed about 6 years ago

Krzysztof W. · Reviewed about 6 years ago

Derek M. · Reviewed about 6 years ago

Nitheesh P. · Reviewed about 6 years ago

Gabriel O. · Reviewed about 6 years ago

Mark K. · Reviewed about 6 years ago

Satisfied

Abdul Wahab S. · Reviewed about 6 years ago

Shivnath S. · Reviewed about 6 years ago

Vaishnavi M. · Reviewed about 6 years ago

Luke A. · Reviewed about 6 years ago

Sebastian B. · Reviewed about 6 years ago

Output of this: SELECT visitId, totals.*, device.* FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE visitId = 1501570398 LIMIT 10 is a single line with lots of columns containing: "not available in demo dataset"

Andrei P. · Reviewed about 6 years ago

Shrikant R. · Reviewed about 6 years ago

Rohit T. · Reviewed about 6 years ago