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

74137 avaliações

Ramy Samir K. · Revisado há almost 8 years

Amjad K. · Revisado há almost 8 years

There is a problem in lab. Article Open BigQuery console have weird text ![fragments/openbigquery-new-ui]

ALEXEY A. · Revisado há almost 8 years

Robert B. · Revisado há almost 8 years

Steve N. · Revisado há almost 8 years

rtuj

Jacki A. · Revisado há almost 8 years

Jordan W. · Revisado há almost 8 years

Juan Francisco M. · Revisado há almost 8 years

Meenal B. · Revisado há almost 8 years

Michael G. · Revisado há almost 8 years

Jeffrey N. · Revisado há almost 8 years

The ARRAY, STRUCT and UNNEST concepts were very new to me. I spent about 4 hours working through the above examples, and other examples from BQ help websites. Using the race_results table made it as simple as possible. I am now comfortable with how to use these functions.

Wayne B. · Revisado há almost 8 years

Jens E. · Revisado há almost 8 years

Paul M. · Revisado há almost 8 years

Well done!

Chen Z. · Revisado há almost 8 years

Satisfied

Murilo B. · Revisado há almost 8 years

Oystein J. · Revisado há almost 8 years

Oystein J. · Revisado há almost 8 years

Eshwar R. · Revisado há almost 8 years

Carlos C. · Revisado há almost 8 years

Vinaya Bhaskar B. · Revisado há almost 8 years

Renz Iver B. · Revisado há almost 8 years

Eric L. · Revisado há almost 8 years

Ubaidali S. · Revisado há almost 8 years

I really enjoyed this lab! I did not know about STRUCT or UNNEST, but have definitely struggled previously with nested data and trying to get it to play nice in SQL.

Sara H. · Revisado há almost 8 years

Não garantimos que as avaliações publicadas sejam de consumidores que compraram ou usaram os produtos. As avaliações não são verificadas pelo Google.