Como trabalhar com dados JSON e de matriz no BigQuery 2.5 avaliações

Alessandro C. · Revisado há over 1 year

Albert X. · Revisado há over 1 year

Romain B. · Revisado há over 1 year

JONATHAN R. · Revisado há over 1 year

This lab should be reviewed. The first question is misleading, as the best answer is "all of the above". If you have a big table, a change in the email address of the customer would need to be reflected in the whole table. If it's an order table, maybe the customer bought a lot of stuff and thus has a lot of lines. We would need to change all those lines. So second answer is good. The third answer is quite valid too. There could be different granularities. Let's say we store "order lines", we could have data related to the "order header". So this would need to be taken into account in the reporting. The correct answer is then "All of the above". + Implicit join on arrays should be considered a bad practice.

SIMON R. · Revisado há over 1 year

ERIC C. · Revisado há over 1 year

JUAN JOSE M. · Revisado há over 1 year

Romain M. · Revisado há over 1 year

Adrianna R. · Revisado há over 1 year

Manimalaimurugan C. · Revisado há over 1 year

Gnana Prasanna K. · Revisado há over 1 year

good

Palak G. · Revisado há over 1 year

Sasikiran R. · Revisado há over 1 year

Srinivasa Rao V. · Revisado há over 1 year

Priyadarshini I. · Revisado há over 1 year

n

Palak G. · Revisado há over 1 year

Amita J. · Revisado há over 1 year

Santanu G. · Revisado há over 1 year

Manish P. · Revisado há over 1 year

MOISES ALFONSO G. · Revisado há over 1 year

Pradeep S. · Revisado há over 1 year

poco tiempo

Rafael N. · Revisado há over 1 year

Douglas Tassio Henrique D. · Revisado há over 1 year

Nicolas L. · Revisado há over 1 year

Elmar G. · Revisado há over 1 year