Constantin Lungudatawise.dev·Apr 19, 2024Pay attention to cardinality & grain when UNNESTING in BigQuery!Whenever you're UNNESing an ARRAY, you're getting a Cartesian product between the row and the array contents. If you were to unnest another array, you'll get another Cartesian product between the output of the previous unnest and the elements in the ...Practical BigQuerySQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.