Book Image

Google Cloud Platform Cookbook

By : Legorie Rajan PS
Book Image

Google Cloud Platform Cookbook

By: Legorie Rajan PS

Overview of this book

Google Cloud Platform is a cloud computing platform that offers products and services to host applications using state-of-the art infrastructure and technology. You can build and host applications and websites, store data, and analyze data on Google's scalable infrastructure. This book follows a recipe-based approach, giving you hands-on experience to make the most of Google Cloud services. This book starts with practical recipes that explain how to utilize Google Cloud's common services. Then, you'll see how to make full use of Google Cloud components such as networking, security, management, and developer tools. Next, we'll deep dive into implementing core Google Cloud services into your organization, with practical recipes on App Engine, Compute Engine, Cloud Functions, virtual networks, and Cloud Storage. Later, we'll provide recipes on implementing authentication and security, Cloud APIs, command-line management, deployment management, and the Cloud SDK. Finally, we'll cover administration and troubleshooting tasks on applications with Compute services and we'll show how to monitor your organization's efficiency with best practices. By the end of this book, you'll have an overall understanding and hands-on implementation of Google Cloud services in your organization with ease.
Table of Contents (14 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

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:

  1. Create or select a GCP project
  2. 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:

  1. Navigate to the BigQuery...