You're reading from Data Exploration and Preparation with BigQuery

Product type Book

Published in Nov 2023

Publisher Packt

ISBN-13 9781805125266

Pages 264 pages

Edition 1st Edition

Languages

Concepts

Data Analysis

Author (1):

Mike Kahn

Table of Contents (21) Chapters

Preface

1. Part 1: Introduction to BigQuery

2. Chapter 1: Introducing BigQuery and Its Components

3. Chapter 2: BigQuery Organization and Design

4. Part 2: Data Exploration with BigQuery

5. Chapter 3: Exploring Data in BigQuery

6. Chapter 4: Loading and Transforming Data

7. Chapter 5: Querying BigQuery Data

8. Chapter 6: Exploring Data with Notebooks

9. Chapter 7: Further Exploring and Visualizing Data

10. Part 3: Data Preparation with BigQuery

11. Chapter 8: An Overview of Data Preparation Tools

12. Chapter 9: Cleansing and Transforming Data

13. Chapter 10: Best Practices for Data Preparation, Optimization, and Cost Control

14. Part 4: Hands-On and Conclusion

15. Chapter 11: Hands-On Exercise – Analyzing Advertising Data

16. Chapter 12: Hands-On Exercise – Analyzing Transportation Data

17. Chapter 13: Hands-On Exercise – Analyzing Customer Support Data

18. Chapter 14: Summary and Future Directions

19. Index

Why subscribe?

20. Other Books You May Enjoy

BigQuery administration and access

In this section, we will discuss how to administer and secure resources in BigQuery. We will describe access methods for users and services to access data. By the end of the section, you will have a basic understanding of the different approaches to securely allocate resources in BigQuery and how to enable access to users.

Tools for administration

BigQuery has several access methods for administration tasks. Most users and roles can do the same function, with multiple tools enabling point-and-click as well as automated task flows.

The Google Cloud console is the main user interface for the centralized management of data and compute resources. Users access the Google Cloud console to run SQL queries and create and manage BigQuery resources. In the BigQuery navigation menu, you can access options for analysis, migration, and administration.

When you access the SQL workspace in the BigQuery section of the Cloud console, you will be presented...