Alternative a: Using BigQuery + dbt cloud

  • Deployment: development environment vs production
  • dbt cloud: scheduler, sources and hosted documentation

Alternative b: Using Postgres + dbt core (locally)

  • Deployment: development environment vs production
  • dbt cloud: scheduler, sources and hosted documentation