Search icon Close icon
Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Learning Google BigQuery

You're reading from  Learning Google BigQuery

Product type Book
Published in Dec 2017
Publisher Packt
ISBN-13 9781787288591
Pages 264 pages
Edition 1st Edition
Languages
Concepts
Authors (3):
Thirukkumaran Haridass Thirukkumaran Haridass
Profile icon Thirukkumaran Haridass
LinkedIn
Thirukkumaran Haridass currently works as a lead software engineer at Builder Homesite Inc. in Austin, Texas, USA. He has over 15 years of experience in the IT industry. He has been working on the Google Cloud Platform for more than 3 years. Haridass is responsible for the big data initiatives in his organization that help the company and its customers realize the value of their data. He has played various roles in the IT industry and worked for Fortune 500 companies in various verticals, such as retail, e-commerce, banking, automotive, and presently, real estate online marketing.
See other products by Thirukkumaran Haridass
Mikhail Berlyant Mikhail Berlyant
Profile icon Mikhail Berlyant
LinkedIn
See other products by Mikhail Berlyant
Eric Brown Eric Brown
Profile icon Eric Brown
LinkedIn
Eric Brown currently works as an analytics manager for PMG advertising in Austin, Texas. Eric has over 11 years of experience in the data analytics field. He has been working on the Google Cloud Platform for over 3 years. He oversees client web analytics implementations and implements big data integrations in both Google BigQuery and Amazon Redshift. Eric has a passion for analytics, and especially for visualization and data manipulation through open source tools such as R. He has worked in various roles in various verticals, such as web analytics service providers, media companies, real-estate online marketing, and advertising.
See other products by Eric Brown
View More author details

Table of Contents (9) Chapters

Preface 1. Google Cloud and Google BigQuery 2. Google Cloud SDK 3. Google BigQuery Data Types 4. BigQuery SQL Basic 5. BigQuery SQL Advanced 6. Google BigQuery API 7. Visualizing BigQuery Data 8. Google Cloud Pub/Sub

Programming with BigQuery API in Python

The following section covers the interaction with BigQuery API using the Python programming language. The code samples cover how to create a new dataset and new table in BigQuery, load data from Google Cloud Storage to the table, execute a query, and return the results or copy the data to a new table.

To get started in Python, make sure the Google Cloud SDK is installed and configured as mentioned in Chapter 2, Google Cloud SDK. Python version 3.6.1 was used in coding these samples. To install the BigQuery API client library for Python, run the following command from the command prompt:

pip install --upgrade google-cloud-bigquery

If the project is going to have other services as well, then it is also better to install client libraries for other services by running the command given here:

pip install --upgrade google-cloud
...
lock icon The rest of the chapter is locked
arrow left Previous Chapter
Chapter 1 of 9
Next Chapter arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $15.99/month. Cancel anytime}

Authors (3)

Left arrow icon
Profile icon Thirukkumaran Haridass
LinkedIn
Thirukkumaran Haridass currently works as a lead software engineer at Builder Homesite Inc. in Austin, Texas, USA. He has over 15 years of experience in the IT industry. He has been working on the Google Cloud Platform for more than 3 years. Haridass is responsible for the big data initiatives in his organization that help the company and its customers realize the value of their data. He has played various roles in the IT industry and worked for Fortune 500 companies in various verticals, such as retail, e-commerce, banking, automotive, and presently, real estate online marketing.
Read more
See other products by Thirukkumaran Haridass
Profile icon Mikhail Berlyant
LinkedIn
See other products by Mikhail Berlyant
Profile icon Eric Brown
LinkedIn
Eric Brown currently works as an analytics manager for PMG advertising in Austin, Texas. Eric has over 11 years of experience in the data analytics field. He has been working on the Google Cloud Platform for over 3 years. He oversees client web analytics implementations and implements big data integrations in both Google BigQuery and Amazon Redshift. Eric has a passion for analytics, and especially for visualization and data manipulation through open source tools such as R. He has worked in various roles in various verticals, such as web analytics service providers, media companies, real-estate online marketing, and advertising.
Read more
See other products by Eric Brown
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
Google Cloud Platform for Architects
Google Cloud Platform for Architects
The Google Cloud Platform is fast emerging as a leading public cloud provider. The GCP, as it is popularly known, is backed by Google’s awe-inspiring engineering expertise and infrastructure and is able to draw upon the goodwill and respect that Google has come to enjoy. The GCP is one of a handful of public cloud providers to offer the full range of cloud computing services, ranging from IaaS (Infrastructure-as-a-Service) to PaaS (Platform-as-a-Service). There is another reason the GCP is fast gaining popularity; genre-defining technologies such as TensorFlow and Kubernetes originated at Google before being open-sourced, and the GCP is a natural choice of cloud on which to run them. If you are a cloud professional today, time spent on mastering the GCP is likely to be an excellent investment.
Jun 2018 12 hours 24 minutes
Machine Learning with BigQuery ML
Machine Learning with BigQuery ML
This book helps you accelerate machine learning model development with BigQuery ML. Throughout the book, you'll use various ML models to learn about BigQuery ML features and discover how to apply them to different business scenarios. This book will help you to extend existing SQL capabilities to leverage the full potential of machine learning.
Jun 2021 11 hours 28 minutes
Google Cloud Platform for Developers
Google Cloud Platform for Developers
The Google Cloud Platform provides auto-scaling compute power and distributed in-memory cache, task queues and data stores to write, build, and deploy Cloud-hosted applications. This book will help you to learn how to integrate the various services to build optimal solutions for your unique business needs using Google Cloud Platform.
Jul 2018 16 hours 52 minutes
Google Cloud Platform Cookbook
Google Cloud Platform Cookbook
Google Cloud Platform is a cloud computing service that offers hosting on the same supporting technology internally used by Google for its end users. This book follows a recipe-based approach, giving you hands-on experience to make the most out of Google Cloud services.
Apr 2018 9 hours 20 minutes
Cloud Analytics with Google Cloud Platform
Cloud Analytics with Google Cloud Platform
This book will deep-dive into the concept of analytics on the cloud with the design and business considerations. You will build an end-to-end analytics engine to perform smart analytics using machine learning and deep learning concepts. From ingestion to processing your data, this book contains the best practices using Google Cloud Platform.
Apr 2018 9 hours 24 minutes
Google Cloud Platform Administration
Google Cloud Platform Administration
With Google Cloud Platform, you can build, test and deploy applications on Google’s highly reliable and scalable infrastructure. This book will help you explore a list of different developer tools available to manage and interact with the GCP platform.
Sep 2018 7 hours 40 minutes
Professional Cloud Architect – Google Cloud Certification Guide
Professional Cloud Architect – Google Cloud Certification Guide
This book will help you prepare for Google’s popular Professional Cloud Architect certification from the ground up. You will learn the necessary skills to design, develop, and manage enterprise-grade cloud solutions, and thereby achieve your organization’s business objectives.
Oct 2019 17 hours 20 minutes
Hands-On Serverless Computing
Hands-On Serverless Computing
Serverless applications and architectures are gaining momentum and are increasingly being used by companies of all sizes to solve the problems of developers. This book teaches you how to quickly and securely develop applications without the hassle of configuring and maintaining infrastructure on three public cloud platforms.
Jul 2018 11 hours 40 minutes
Hands-On Artificial Intelligence on Google Cloud Platform
Hands-On Artificial Intelligence on Google Cloud Platform
This book focuses on the use of powerful AI tools offered by Google Cloud Platform to develop and design intelligent applications on the cloud. You will start with topics that set the foundation for using GCP with various powerful libraries, and then move on to building end to end AI applications using them.
Mar 2020 11 hours 40 minutes
Hands-On Machine Learning on Google Cloud Platform
Hands-On Machine Learning on Google Cloud Platform
In this book, you will learn how to create powerful machine learning based applications for a wide variety of problems leveraging different data services from the Google Cloud Platform. Finally, you will know the main difficulties that you may encounter and get appropriate strategies to overcome these difficulties and build efficient systems.
Apr 2018 16 hours 40 minutes
Architecting Google Cloud Solutions
Architecting Google Cloud Solutions
Google Cloud is a powerful and highly scalable cloud platform that has seen rising demand and interest from enterprises seeking digital transformation and looking to modernize their workloads. This book is a comprehensive introduction to solution architecture with Google Cloud that will have you up to speed in no time.
Apr 2021 15 hours 44 minutes
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Et al.
Et al.
Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.
Aug 2023 7 hours 40 minutes
Generative AI with LangChain
Generative AI with LangChain
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Dec 2023 12 hours 0 minutes
Mastering Tableau 2023
Mastering Tableau 2023
This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.
Aug 2023 22 hours 48 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Sep 2023 8 hours 36 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Sep 2023 8 hours 36 minutes
Data Engineering with AWS
Data Engineering with AWS
Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.
Oct 2023 21 hours 12 minutes
Modern Data Architecture on AWS
Modern Data Architecture on AWS
Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.
Aug 2023 14 hours 0 minutes
Practical Guide to Applied Conformal Prediction in Python
Practical Guide to Applied Conformal Prediction in Python
Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.
Dec 2023 8 hours 0 minutes
TinyML Cookbook
TinyML Cookbook
With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.
Nov 2023 22 hours 8 minutes
Right arrow icon