Utilizzo dei tipi di dati JSON e array in BigQuery 2.5 recensioni

Syed Ghayur Abbas N. · Recensione inserita 12 mesi fa

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. · Recensione inserita 12 mesi fa

Cristobal V. · Recensione inserita 12 mesi fa

Renato R. · Recensione inserita 12 mesi fa

Jorge A. · Recensione inserita 12 mesi fa

Mauricio H. · Recensione inserita 12 mesi fa

Bien

Víctor C. · Recensione inserita 12 mesi fa

Nassim B. · Recensione inserita 12 mesi fa

Nicolas S. · Recensione inserita 12 mesi fa

Nassim B. · Recensione inserita 12 mesi fa

Marco Q. · Recensione inserita 12 mesi fa

Kalaiselvi S. · Recensione inserita 12 mesi fa

Damindu V. · Recensione inserita 12 mesi fa

good

Palak G. · Recensione inserita 12 mesi fa

Rohit R. · Recensione inserita 12 mesi fa

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

Katawut W. · Recensione inserita 12 mesi fa

Paula B. · Recensione inserita 12 mesi fa

Sumit P. · Recensione inserita 12 mesi fa

Alessandro C. · Recensione inserita 12 mesi fa

Albert X. · Recensione inserita 12 mesi fa

Romain B. · Recensione inserita 12 mesi fa

JONATHAN R. · Recensione inserita 12 mesi fa

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. · Recensione inserita 12 mesi fa

ERIC C. · Recensione inserita 12 mesi fa

JUAN JOSE M. · Recensione inserita 12 mesi fa