Search Results for: bigquery
Google BigQuery + GKG 2.0: Sample Queries
Making the GDELT Global Knowledge Graph available in Google BigQuery has been one of the most-requested features since the debut…
GDELT+BigQuery: Understanding the World with SQL
Check out this amazing video created by Felipe Hoffa, Developer Advocate on big data at Google, that showcases how GDELT is…
GDELT and Google BigQuery: Understanding the World
Take a look at this incredible teaser video Google put together showcasing how GDELT makes use of the enormous power…
Exploring GDELT Using Tableau and BigQuery
The latest version of Tableau offers direct integration with Google BigQuery, meaning you can leverage Tableau's incredibly powerful point-and-click visual analytics…
Towards Psychohistory: Uncovering the Patterns of World History with Google BigQuery
Two months ago we unveiled in Google BigQuery access to the entire quarter-billion-record GDELT Event Database, which monitors the world’s…
Visualizing GDELT In Tableau Using BigQuery
Julius Concepion shows off a screen capture visualizing the entire quarter-billion-record GDELT event database in realtime using Tableau and Google's…
GDELT: World's largest event dataset now publicly available in Google BigQuery
We are phenomenally excited to announce that the entire quarter-billion-record GDELT Event Database is now available as a public dataset…
Our Journey Towards User-Facing Vector Search: Evaluating Elasticsearch's ANN Vector Search RAM Costs
As we continue our journey towards offering realtime user-facing semantic search over our growing collection of embedding datasets, we are…
GCP Tips & Tricks: Observations On A Decade Of Running Elasticsearch On GCP: Part 3 – Future Storage Options
We've run Elasticsearch clusters on GCP for almost a decade across many different iterations of hardware and cluster configurations. Earlier…
The Hidden Dangers Of Generative Coding (CodeGen) Guardrails
One of the most intriguing findings from our generative code modernization (codegen) experiment earlier today was the degree to which…
A Look Back At Mapping 2013's "The Global Conversation" And Ahead To The Future
One decade ago we mapped "The Global Conversation" for the December 2013 print edition of Foreign Policy Magazine that coincided…
Experiments In Summarizing Global Media Tenor: Views Towards China – Part 1
How might we use LLMs to summarize at-scale media tone and portrayals of countries? Let's look at a few different…
Tracing Global Media Tone & Anxiety Towards China & Ukraine 2020-Present
Using the GKG, what might we be able to learn about global media tone towards China and Ukraine? Let's first…
The Perils Of LLMs For Translation Tasks On Lower-Resource Languages: Estonian Noun Declension
One of the great promises of large language models (LLMs) is their ability to revolutionize translation and linguistic tasks. A…
The Erdogan Heart Attack Rumor On Social Vs Mainstream Media: The Perils Of Prioritizing Speed Over Verification
One of the most-touted aspects of social media when it comes to realtime global warning is its claimed ability to…
GEN4: GCE Networking: VPC Networks, Firewalls, IAP Tunneling & PGA
Earlier this year we explored how Google Compute Engine (GCE)'s VPC networks and especially GCP's "Private Google Access" (PGA) allows…
GEN4: Building A Complete Near-Realtime Live Stream Video Analytics Platform In The Cloud In Just A Few Lines Of Code
Given the growing use of live streaming video across the world, from speeches by heads of state to news programming,…
GDELT Opening Keynotes: Watching, Visualizing And Forecasting The World In Realtime
For organizations and conferences looking for aspirational "grand challenge" opening keynotes and workshops to inspire their audiences, the next in…
Web Archives As Digital History: Methodologies, Workflows And Technological Needs
Within GDELT's vast archives lie decades of global human history. A library of open datasets spanning more than 8 trillion…
GDELT Keynotes & Workshops: In-Person & Virtual
For organizations interested in everything from inspirational opening keynotes on the incredible new insights we gain into the functioning of…
Using The Global Similarity Graph To Bootstrap Categorization Models Using Web NGrams 3.0
A common question from organizations building document classifiers on top of the Web NGrams 3.0 dataset is how to accelerate…
Using Chyrons To Understand Diversity In Television News
When television news channels turn to outside experts to interview on the major stories of the moment, who do they…
Mapping News: The Hidden Geography Of The World's News Media
Ever since Culturomics 2.0 showcased the immense insights and hidden predictive power of the geography of the world's news media,…
"You Are Here": Helping The Public Navigate Their Informational Choices
Over the years we've explored how the GKG's outlink graph can be used to construct "you are here" maps of…