Season 2 · Episode 1505
BigQuery & GDELT: Mining Global News with AI
Discover how Google BigQuery and the GDELT project allow researchers to analyze billions of global news records using real-time AI and SQL.
My Weird Prompts · Daniel Rosehill
March 24, 202616m 23s
Audio is streamed directly from the publisher (dts.podtrac.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Dive into the world of massive-scale data analysis as we explore Google BigQuery’s role in processing GDELT—a real-time mirror of global society containing over 2.5 billion records. Learn the critical differences between row-based production databases and columnar analytical engines, and why offloading heavy lifting to a data warehouse is essential for maintaining application performance. This episode also covers the latest AI-native updates, including vector embeddings and Gemini 3.1 integration, which are transforming the modern data warehouse into a "brain" capable of querying semantic meaning rather than just raw text.