All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

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

Database Administration

Authors (3):

Thirukkumaran Haridass

Mikhail Berlyant

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

Summary

This chapter covered the practical use of partition tables, wildcard tables, nested and repeated records, and views. This chapter also covered how to define and use user-defined functions in JavaScript and SQL. Then we covered how to connect to external data sources and query them using the BigQuery engine. More and more federated data sources will be added to this list and you will learn how to connect to Bigtable and Google Drive files using the documents provided in the further reading section.

The rest of the chapter is locked

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.

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)

Thirukkumaran Haridass

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

Mikhail Berlyant

See other products by Mikhail Berlyant

Eric Brown

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

Other recommended products

Related to this chapter

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

Personalised recommendations for you

Based on your interests and search pattern

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