Search Results for: bigquery
The Top Daily Terms By Station On American Television 2009-2019 Using BigQuery And TV Ngrams
Converting piles of unstructured text into structured tables like ngrams opens the door to all kinds of powerful new analyses…
Computing TF-IDF Scores From The TV Ngram Dataset In BigQuery
The ever-amazing Felipe Hoffa came up with the following BigQuery query that computes the TF-IDF scores for the new Television…
Google's AutoML And BigQuery ML: The Rise Of One-Click Hyperscale Machine Learning
The cloud is no longer just a place where AI experts go to pioneer the future or scarce deep learning…
Using BigQuery As A Lens To Explore Large Datasets
One of the most incredible aspects of the modern cloud is the way in which it accelerates massive adhoc data…
Google's BigQuery Brings GIS Into The Petascale Era
BigQuery’s unique ability to couple petascale query infrastructure with thousands or even tens of thousands of cores and apply it…
Merging Billions of URLS Using BigQuery
One of the most amazing things about Google's BigQuery service is its nearly infinite scalability and the sheer speed at…
Using BigQuery To Make A 38 Year Timeline Of World Conflict From Half A Billion Records In 3 Seconds
Three years ago we showed off the results of a singularly incredible BigQuery query, courtesy of the one and only…
A First Look At Three Weeks Of The Global Frontpage Graph (GFG) Through BigQuery
The newest addition to the GDELT family, the GDELT 3.0 Global Frontpage Graph (GFG) has been running every hour for…
Building dictionaries for Word Encodings using BigQuery SQL
Google's Sergei Sokolenko demonstrates how to convert the GKG's themes, names and locations fields into a numeric BOW vector suitable…
Big Data at BBVA Research using GDELT+BigQuery
Tomasa Rodrigo Lopez from BBVA Research presented at Google Next Madrid this past June 8th on how they are using…
VGKG 2.0 Now Available In Partitioned BigQuery Table
As the GDELT Visual Global Knowledge Graph (VGKG) has grown to just over 287 million images totaling 3.2TB of JSON…
GDELT 3.0 And Using BigQuery And Streaming Google Cloud Storage For Logging
One of the most incredible aspects of working in Google's cloud environment is that no matter what you need, chances are…
GDELT Featured In BigQuery + Excel Documentation Example
GDELT was used as an example in a tutorial on how to connect Bigquery to Excel on Google's Big Data…
Connecting BigQuery To Microsoft Excel Using The New ODBC Driver
A new post by Tim Swast on the cloud big data and machine learning blog showcases a number of fascinating…
Analysing World Events Using the GDELT dataset and Google BigQuery
Ali Niknejad of the Centre for Transport Studies at Imperial College London will be speaking at the Research Software Engineers…
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…