Uploading data to the Google BigQuery table
Google BigQuery is a petabyte scale, serverless, low cost data analytics service. The ability to use standard SQL is one of the great advantages from a developer standpoint. BigQuery uses columnar storage, massively parallel processing, and performance adjustments for the data processing of large datasets.
In this recipe, we'll learn to insert data into a BigQuery table continuously and later query it from the web interface.
Getting ready
The following steps are theĀ initial setup verification steps forĀ the creation of the network before the recipe can be executed:
- Create or select a GCP project
- Enable billing and enable the default APIs (some APIs like BigQuery, storage, monitoring, and a few others are enabled automatically)
How to do it...
In this recipe, we'll extract some data from Twitter using the Twitter API and load it into a BigQuery table. Once the data is loaded, we'll use the web interface to query the stored items:
- Navigate to the BigQuery...