Kickstarter Campaign Analytics Pipeline
Kickstarter campaign analytics pipeline that answers which factors (category, goal, country, staff pick, duration) best predict Kickstarter success. It ingests ~203k campaigns from Hugging Face (Parquet), lands data in Google Cloud Storage, loads and models it in BigQuery (raw → staging → analytics marts), and feeds a Looker Studio dashboard. Infrastructure (GCS, BigQuery) is provisioned with Terraform. Bruin orchestrates the workflow: GCP connection and environments in .bruin.yml, pipeline definition in pipeline.yml (variables), Python assets for download/load to GCS and BigQuery, BigQuery SQL assets with dependencies (depends), materialization (views/tables), column metadata and data quality checks in asset headers, and Jinja variables (var.*) in SQL.