Using ARRAY_AGG(x LIMIT 1)[OFFSET(0)] will allow Big‐Query to drop all data that isn't the number 1 row, increasing query performance. 1. In the BigQuery UI ...
確定! 回上一頁