If you are a developer, data analyst, or a data scientist looking to run complex queries over thousands of records in seconds, this book will help you. No prior experience of working with BigQuery is assumed.
- 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
Who this book is for
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.