BigQuery is the data warehouse on Google Cloud Platform. It is cost-effective, fully managed, and works at scale.
When to use:
If you want to make your data work in a way to find some business insights, using SQL; also you do not need any database admin. While your data can be stored in cloud storage as an object or in Cloud SQL as a database, you can run your queries on the top of GCP using BigQuery.
Special features:
- Serverless
- Scale at Petabyte level
- Standard SQL on batch or real-time data
- Storage and Compute are priced differently
Costing:
Storage and computing are charged differently.
Please refer to the following table for details about the costing of BigQuery Storage:
Item |
Price |
Storage |
$0.02 per GB, per month ... |