You're reading from Data Engineering with Google Cloud Platform A guide to leveling up as a data engineer by building a scalable data platform with Google Cloud

Product type Paperback

Published in Apr 2024

Publisher Packt

ISBN-13 9781835080115

Length 476 pages

Edition 2nd Edition

Languages

SQL

Tools

Google Cloud Platform

Concepts

Data Engineering

Author (1):

Adi Wijaya

View More author details

Table of Contents (19) Chapters

Preface

1. Part 1: Getting Started with Data Engineering with GCP FREE CHAPTER

2. Chapter 1: Fundamentals of Data Engineering

3. Chapter 2: Big Data Capabilities on GCP

4. Part 2: Build Solutions with GCP Components

5. Chapter 3: Building a Data Warehouse in BigQuery

6. Chapter 4: Building Workflows for Batch Data Loading Using Cloud Composer

7. Chapter 5: Building a Data Lake Using Dataproc

8. Chapter 6: Processing Streaming Data with Pub/Sub and Dataflow

9. Chapter 7: Visualizing Data to Make Data-Driven Decisions with Looker Studio

10. Chapter 8: Building Machine Learning Solutions on GCP

11. Part 3: Key Strategies for Architecting Top-Notch Solutions

12. Chapter 9: User and Project Management in GCP

13. Chapter 10: Data Governance in GCP

14. Chapter 11: Cost Strategy in GCP

15. Chapter 12: CI/CD on GCP for Data Engineers

16. Chapter 13: Boosting Your Confidence as a Data Engineer

17. Index

Why subscribe?

18. Other Books You May Enjoy

Tips to optimize BigQuery using partitioned and clustered tables

BigQuery tables can store data from zero bytes to petabytes of data. There is no difference between creating a small-sized table or a large-sized table. To simplify the context and for illustration purposes only, let’s say a small-sized table ranges from KBs to 100 GB. The large-sized tables range from 100 GB to PB of data. Technically, both tables are the same, but if you think about optimizing performance and compute cost, you can configure the tables using two features called BigQuery partitioned tables and BigQuery clustered tables.

These features are helpful for both on-demand and flat-rate pricing. In on-demand pricing, the features will cut the billed bytes and will reduce the overall cost that is calculated from the billed bytes. With flat-rate pricing, it doesn’t affect the cost directly. Remember that the cost of flat-rate pricing is flat per period. However, when you’re using features...