Felipe Hoffa wrote this great post on the Google Cloud Platform Blog with more technical detail on how BigQuery enabled GDELT to sift through the patterns of world history in just a single SQL query, executing 2.5 million correlations in just 2.5 minutes.