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
- Best practices for optimizing storage
- Best practices for optimizing compute
- Monitoring and controlling costs
This chapter will serve as a reference for best practices for data preparation as well as cost control...
