You're reading from Learning Google BigQuery

Product typeBook

Published inDec 2017

Reading LevelBeginner

PublisherPackt

ISBN-139781787288591

Edition1st Edition

Languages

Python

Concepts

Database Administration

Authors (3):

Thirukkumaran Haridass

Mikhail Berlyant

Eric Brown

View More author details

What this book covers

Chapter 1, Google Cloud and Google BigQuery, is a hands-on demo of App Engine, Cloud SQL, BigQuery, Cloud datastore, compute engine, and Google Cloud Storage.

Chapter 2, Google Cloud SDK, covers how to install and configure the Google Cloud SDK and use various utilities provided in the SDK to interact with App Engine, Cloud SQL, BigQuery, and Google Cloud Storage.

Chapter 3, BigQuery Data Types, illustrates various data types supported in Google BigQuery and how to migrate your data to BigQuery.

Chapter 4, BigQuery SQL Basic, covers how to query the data using both legacy SQL and standard SQL, and how to merge data from various tables using queries.

Chapter 5, BigQuery SQL Advanced, shows how to use partition tables in your project and query an external data source on Google Cloud (such as Google Cloud Storage) from within BigQuery. We cover querying of wild card tables, user-defined functions, views, and using nested and repeated types in our tables to support importing JSON data.

Chapter 6, Google BigQuery API, teaches you how to use BigQuery API to create tables and datasets dynamically. You learn to load data into BigQuery and perform streaming insert of records for real-time analytics using Python and C#. Permissions, users, and roles are covered in this chapter.

Chapter 7, Visualizing BigQuery Data, shows you how to visualize your data by connecting it to various frontend tools, such as Tableau and Google Data Studio. We write custom programs in R.

Chapter 8, Google Cloud Pub/Sub, covers the use of the Cloud Pub/Sub messaging system to log messages from various applications and its use to implement real-time reporting and analytics. This chapter also covers Cloud Dataprep, which helps prepare the data for loading into BigQuery.

The rest of the page is locked

You have been reading a chapter from

Learning Google BigQuery

Published in: Dec 2017Publisher: PacktISBN-13: 9781787288591

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 about Thirukkumaran Haridass

Mikhail Berlyant

Other recommended products

Related to this chapter

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.

BookJun 2018372 pages

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.

BookJun 2021344 pages

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.

BookJul 2018506 pages

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.

BookApr 2018280 pages

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.

BookApr 2018282 pages

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.

BookSep 2018230 pages

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.

BookOct 2019520 pages

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.

BookJul 2018350 pages

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.

BookMar 2020350 pages

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.

BookApr 2018500 pages

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.

BookApr 2021472 pages

Personalised recommendations for you

Based on your interests and search pattern

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.

BookAug 2023230 pages5

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.

BookDec 2023360 pages4

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.

BookDec 2023360 pages5

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.

BookDec 2023360 pages1

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.

BookDec 2023360 pages5

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.

BookAug 2023684 pages

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.

BookSep 2023258 pages5

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.

BookSep 2023258 pages2

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.

BookOct 2023636 pages5

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.

BookAug 2023420 pages5

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.

BookDec 2023240 pages

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.

BookNov 2023664 pages

You're reading from Learning Google BigQuery

Unlock this book and the full library FREE for 7 days

Authors (3)

Google Cloud Platform for Architects

Machine Learning with BigQuery ML

Google Cloud Platform for Developers

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.

Cloud Analytics with Google Cloud Platform

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.

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.

Hands-On Serverless Computing

Hands-On Artificial Intelligence on Google Cloud Platform

Hands-On Machine Learning on Google Cloud Platform

Architecting Google Cloud Solutions

Et al.

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.

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.

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.

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.

Mastering Tableau 2023

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

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.

Modern Data Architecture on AWS

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.

TinyML Cookbook