For this book all you would require is the Google Cloud SDK, the browser of your choice (Chrome is recommended), and an editor that supports PHP coding, and you're all set to begin. It is also recommended to learn SQL basics for writing advanced queries in Google BigQuery. This book uses Google BigQuery Public Dataset for demos.
- Preface
- Google Cloud and Google BigQuery
- Google Cloud SDK
- 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
- Summary
- Further Reading
- BigQuery SQL Basic
- BigQuery SQL Advanced
- Google BigQuery API
- Accessing Google BigQuery
- Programming with BigQuery API in C# .NET
- Authenticating the service account
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Loading data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Executing the query and saving the result in a new table
- Streaming insert of rows
- Programming with BigQuery API in Python
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Importing data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Execute query and copy results to a new table
- Streaming insert of rows
- Roles and permissions
- Summary
- Visualizing BigQuery Data
- Why is data visualization important?
- The danger of summary statistics
- Making data visualization work for you
- Three tools for visualizing BigQuery data
- Summary
- Google Cloud Pub/Sub
What you need for this book
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.