Pay attention to cardinality & grain when UNNESTING in BigQuery!
Share

Whenever you’re UNNESing an ARRAY, you’re getting a Cartesian product between the row and the array contents.

 

 Whenever you’re UNNESing an ARRAY, you’re getting a Cartesian product between the row and the array contents.Continue reading on Data Engineer’s Notes » Read More Sql on Medium 

#sql

By