Best practices for optimizing storage
After preparing and setting up your data, a good area to begin optimizing BigQuery usage is at the storage layer. BigQuery storage is relatively low cost, starting at $0.02 per GB per month (comparable to Cloud Storage or Amazon S3 storage costs) with the first 10 GB of storage per month free. When getting started with BigQuery, the first 10 GB of storage at no cost is a great advantage and creates a frictionless entry point for cost-conscious individuals and businesses. As you begin to load more data, you will want to be aware of the best practices for optimizing storage to operate efficiently and cost-effectively. In this section, we will highlight some of the best practices for managing your data storage in BigQuery.
When you create a dataset, you can set the default table expiration (refer to Figure 10.1). This allows you to set the number of days after creation that the table will be automatically deleted. This is useful for temporary data...
