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

Syed Ghayur Abbas N. · Revisado há 12 months

Some parts might be checked because of old Bigquery Interface (grey area not longer grey for nested fields). But really helpful and good for own thinking :)

Luise W. · Revisado há 12 months

Cristobal V. · Revisado há 12 months

Renato R. · Revisado há 12 months

Jorge A. · Revisado há 12 months

Mauricio H. · Revisado há 12 months

Bien

Víctor C. · Revisado há 12 months

Nassim B. · Revisado há 12 months

Nicolas S. · Revisado há 12 months

Nassim B. · Revisado há 12 months

Marco Q. · Revisado há 12 months

Kalaiselvi S. · Revisado há 12 months

Damindu V. · Revisado há 12 months

good

Palak G. · Revisado há 12 months

Rohit R. · Revisado há 12 months

Too more tasks for an hour, so we cannot go deep for each task.

Katawut W. · Revisado há 12 months

Paula B. · Revisado há 12 months

Sumit P. · Revisado há 12 months

Alessandro C. · Revisado há 12 months

Albert X. · Revisado há 12 months

Romain B. · Revisado há 12 months

JONATHAN R. · Revisado há 12 months

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á 12 months

ERIC C. · Revisado há 12 months

JUAN JOSE M. · Revisado há 12 months