BigQuery

• Architecture
• Queries
• Optimizations
• query-optimizations
• storage-optimizations
• Documentation
• modeling
• slots
• interview-questions

BigQuery is a serverless data analytics platform. You don't need to provision individual instances or virtual machines to use BigQuery. Instead, BigQuery automatically allocates computing resources as you need them. You can also reserve compute capacity ahead of time in the form of slots, which represent virtual CPUs.

Pricing

• Queries (on-demand) - $6.25 per TiB - The first 1 TiB per month is free.
• Pricing  |  BigQuery: Cloud Data Warehouse  |  Google Cloud
• Quotas and limits  |  BigQuery  |  Google Cloud
• Estimate and control costs  |  BigQuery  |  Google Cloud
• Pricing  |  BigQuery: Cloud Data Warehouse  |  Google Cloud
• Estimate and control costs  |  BigQuery  |  Google Cloud

Others

• BigQuery should not be used if you expect OLTP behavior or performance.
• Write data from Kafka to BigQuery with Dataflow  |  Google Cloud

References

• https://github.com/GoogleCloudPlatform/training-data-analyst/blob/master/courses/machine_learning/deepdive/02_generalization/repeatable_splitting.ipynb
• https://github.com/GoogleCloudPlatform/training-data-analyst
• php - Speed of inserting to BigQuery - should this be batched in background? - Stack Overflow