Learning Google BigQuery

更新时间：2021-07-02 21:24:32

最新章节：Further reading

封面

版权信息

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Why subscribe?

Customer Feedback

Dedication

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

Google Cloud and Google BigQuery

Getting started with Google Cloud

Overviewing Google Cloud Platform services

Google Cloud storage and its features

Learning Google BigQuery

Working with the browser

Running your first query

BigQuery public datasets

Getting started with Cloud SQL

Cloud Datastore

Google App engine

App engine standard environment

App engine flexible environment

Google container engine

Google compute engine

Summary

Google Cloud SDK

Installing Google Cloud SDK

Installing Google Cloud SDK on Windows

Installing Google Cloud SDK on macOS

Installing Google Cloud SDK on Linux

gsutil for Google Cloud Storage

Using the bq utility for BigQuery

Using the gcloud utility

Connecting to Cloud SQL using gcloud

Authorizing the client machine via Google Cloud Console

Connecting using a proxy script

Exporting Cloud SQL databases and tables

Deploying to Google App Engine

Summary

Google BigQuery Data Types

Supported data types

Data type considerations

Converting data

Sanitizing data

When to transform your data? Before or after loading to BigQuery?

Arithmetic Operators

Comparison Operators

Date Time Functions

String Functions

Regular Expression Functions

Functions for transformation

Mastering transformation with User-Defined Functions

Some considerations when using UDFs

UDF format

Summary