Search Results for: bigquery
Announcing Partitioned GDELT BigQuery Tables
As GDELT has grown to truly extraordinary scale, the sheer magnitude of all of that data has made it increasingly…
Making NGrams At BigQuery Scale
Ever since 2010's Culturomics paper and with the rise of ever-more powerful linguistic modeling systems, ngrams have surged back into…
Using BigQuery Table Decorators To Lower Query Cost
As GDELT has grown at an exponential rate, the size and complexity of its data archives means it takes ever…
GDELT Part Of Inaugural Google BigQuery Public Datasets
We're tremendously excited that GDELT is part of the inaugural set of Google BigQuery Public Datasets unveiled earlier this month!…
Exploring GDELT Using Tableau + BigQuery
Tableau put together a great video showcasing how easy it is to use Tableau and Google BigQuery to interactively explore…
Google BigQuery + Visual GKG: Sample Queries
Now that the new Visual Global Knowledge Graph, powered by Google Cloud Vision API, is available in Google's BigQuery platform,…
GDELT Featured In BigQuery Documentation Example
We're excited that GDELT was used as an example dataset to illustrate the new BigQuery Query Plan Explanation feature! See the Documentation.
A Compilation Of GDELT BigQuery Demos
With the debut of GDELT 2.0 earlier this year and the general availability of the GDELT Global Knowledge Graph (GKG) in…
Terascale Sentiment Analysis: BigQuery + Tone Coding Books
As we continue to add new sentiment dictionaries to GDELT on a regular basis, a common request has been the ability…
Using BigQuery To Explore Large Log Files: Exploring the Wayback Machine
Kalev's latest Forbes piece explores what is really in the Internet Archive's Wayback Machine and the nuance and biases of…
One-Click Network Visualization With BigQuery+Gephi
For his latest Forbes piece, Kalev took a network visualization developed by the BBVA Research Emerging Markets Unit of how…
Mapping at Infinite Scale: Terascale and Petascale Cartography and Big Data in the BigQuery Era
This past Saturday, on Halloween, the GDELT 2.0 Global Knowledge Graph reached 150 million articles in 65 languages from just…
New One Minute Maps: BigQuery UDF + CartoDB
We're incredibly excited to announce today the ability to generate rich interactive geographic maps in less than 60 seconds from…
Google BigQuery + 3.5M Books: Sample Queries
To help you get started with the latest GDELT collection of 3.5 million digitized historical English language books published from…
3.5 Million Books 1800-2015: GDELT Processes Internet Archive and HathiTrust Book Archives and Available In Google BigQuery
Today we are enormously excited to announce that more than 3.5 million digitized books stretching back two centuries, encompassing the…
Advanced Mapping with the GDELT API + BigQuery
Today we feature the second half of the announcement of our incredible new collaboration with online mapping platform CartoDB to make…
Understanding Global Conflict And Disasters Through BigQuery: Advanced Examples
BigQuery makes it possible to explore data at scales limited really only by your imagination and to help get you…
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…