What is BigQuery ?
- Fully Managed Data warehousing
- Near real time analysis of petabyte scale databases
- Serverless(no ops)
- Auto scaling
- Both storage and analysis
- Interact with SQL
How BigQuery works
- Columnar data store
- It does not update exciting records
- No transactional
Structure
- Dataset: contains tables/views
- Table: collections of columns
- Job: long running action/query
IAM
- can control by project, dataset, view
- cannot control at table level