Using BigQuery as a data warehouse in B2B startup
summary
Chooses Google BigQuery as the data warehouse because it proves fast, cheap and reliable for a B2B startup: it consolidates Azure user tables, Google Analytics session and cost data, AdWords/Facebook spend, Chargebee subscriptions and Copper CRM. Starts with Stitch and a third‑party tool to pipe GA, then replaces Stitch with a homemade BigQuery manager (SQL + config + Python) to handle timestamp quirks, scheduling and incremental loads; the stack runs in production and costs about $115/month.
AI-written summary · about
chapters (5)
- 0:00Introduction and setup
- 3:22Why Google BigQuery
- 10:28Data integration and tools
- 17:20Custom BigQuery manager
- 20:35Resources and conclusion
related talks
46mSimple and Cheap Business Analytics with Google BigQuery
52mBuilding the World's Largest Enterprise Data Warehouse with BigQuery
45mBuilding a Data Warehouse
36mMigrating Our Data Warehouse to the Cloud
27mNotorious B.I.G. Data: Wins and fails when building a big data platform in the cloud
41mAnalyzing Terabytes of Data with Google BigQuery
37mBuilding a Data Platform from scratch
41mModular & Reusable: A Recipe to Scaling Data Across a Portfolio