Lesson 06
BigQuery Table vs View vs Materialized View Explained
In BigQuery, a table stores actual data physically in rows and columns. A view is a virtual table created from a SQL query and does not store data itself—it runs the query each time you access it. A materialized view stores the precomputed query results physically, which improves query performance and reduces processing cost for frequently used aggregations or summaries.
Get the full lesson
Sign in to unlock everything beyond the preview — it's free.
- Take timestamped notes as you watch
- Read the full transcript and download resources
- Join the discussion and track your progress