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.
Google Cloud Platform Blog on Patterns of World History Study
GDELT: World’s largest event dataset now publicly available in Google BigQuery