Jan 02, 2022 Rahul Sharma

<aside> 💡 These are my notes from BigQuery for Data Engineers course on Udemy.

</aside>

I. Introduction

BQ is a fully managed, serverless, highly scalable, and cost-effective cloud data warehouse solution designed for business agility.

Features at a glance

  1. Both batch and streaming data ingestion, up to 100k rows/s
  2. ML with BQML, integrates with VertexAI
  3. Fully managed, no maintenance required
  4. Pay separately for storage and compute
  5. Results are cached, no extra charge for repeated queries
  6. Fully-managed data transfers
  7. Transfer data from Teradata and S3
  8. Uses IAM to control access
  9. Assign permissions by projects
  10. Supports GIS (PostGIS, WKB, WKT)