Data Exploration and Preparation with BigQuery

10

Best Practices for Data Preparation, Optimization, and Cost Control

At a time when compute and storage access is abundant and organizational budgets are slim, knowledge of optimization and cost control practices is critical. In this chapter, we will review best practices for data preparation by focusing on optimizing for data efficiency and performance. We will review best practices and optimization techniques for BigQuery storage and compute analysis, as well as monitoring and controlling costs. We will introduce the many unique cost control and optimization features of BigQuery. The goal of this chapter is to teach you how to use BigQuery cost-effectively.

In this chapter, we will go over the following topics:

• Data preparation best practices ...