Introduction to BigQuery
Introduction to BigQuery
Matt Forrest
Field CTO
What is BigQuery?
Compute and storage
1 https://cloud.google.com/bigquery/docs/storage_overview
Snowflake and BigQuery
Snowflake
- Popular amongst developers
- Runs on any cloud
- Specific tiers of compute resources (small, medium, etc.)
BigQuery
- Popular for analytical queries (reports)
- Only run on Google Cloud
- Completely serverless, no tiers
Redshift and BigQuery
Redshift
- Constant computation or serverless
- Suited for live dashboarding
BigQuery
- Only serverless
- Point in time analysis (once a day or hour)
Traditional SQL databases and BigQuery
SQL databases
- Online transactional processing (OTAP)
- Compute and storage are linked
- Non-distributed
BigQuery
- Online analytical processing (OLAP)
- Compute and storage are separate
- Distributed query engine
How is BigQuery used?
- Reports that run at a specific time period or day (daily ecommerce reports, quarterly reports)
- Ad-hoc discovery (marketing campaign analysis)
