← Back to home
Comparison · Analytics

dbt Core vs BigQuery

A side-by-side editorial comparison of dbt Core and BigQuery — release velocity, themes, recent moves, and the top alternatives to consider.

dbt Core vs BigQuery: at a glance

Featuredbt CoreBigQuery
SectorAnalyticsInfra & APIs, Analytics
Velocity score7.50.0
Sparks · 30d10
Top themesdata-transformation, lakehouse, iceberg, dual-enginedata-warehouse, mcp, managed-ai, governance
Last editorial update4d ago9h ago
WebsiteVisit →Visit →

What is dbt Core?

Two engines in one repo: the Python 1.x line tightens while Fusion 2.0 goes lakehouse-catalog native

dbt-core is releasing on two tracks at once. The Python line reached 1.12.0 on 16 July after three release candidates, and it is a tightening release: the experimental `dbt login` command and the bundled dbt-state plugin were removed outright, and flags introduced in 1.9 and 1.10 now default to true. The 2.0.0 alpha track is the Fusion engine, and its work is almost entirely about catalogs — read-write Horizon and Unity access over Iceberg REST via DuckDB, a catalogs.yml v2 covering DuckLake, Iceberg REST and local filesystem, plus catalog_database overrides and Redshift catalog generation through SHOW TABLES and SVV_REDSHIFT_COLUMNS.

Read the full dbt Core trajectory →

What is BigQuery?

BigQuery is making itself agent-callable and pulling inference inside the SQL boundary.

Two GA milestones define the current position: the BigQuery MCP server, and the managed AI functions AI.IF, AI.SCORE and AI.CLASSIFY that run Gemini from inside a query. Alongside them, BigQuery Graph entered preview, and a steady GA cadence continues across sharing listings, materialized views over CDC tables, Snowflake transfers, code-asset folders and Dataform's strict act-as enforcement.

Read the full BigQuery trajectory →

dbt Core vs BigQuery: editorial side-by-side

D
dbt Core
ANALYTICS
7.5

Two engines in one repo: the Python 1.x line tightens while Fusion 2.0 goes lakehouse-catalog native

◆ Current state

dbt-core is releasing on two tracks at once. The Python line reached 1.12.0 on 16 July after three release candidates, and it is a tightening release: the experimental `dbt login` command and the bundled dbt-state plugin were removed outright, and flags introduced in 1.9 and 1.10 now default to true. The 2.0.0 alpha track is the Fusion engine, and its work is almost entirely about catalogs — read-write Horizon and Unity access over Iceberg REST via DuckDB, a catalogs.yml v2 covering DuckLake, Iceberg REST and local filesystem, plus catalog_database overrides and Redshift catalog generation through SHOW TABLES and SVV_REDSHIFT_COLUMNS.

◆ Where it's heading

The division of labour between the two tracks is clear from the entries: 1.x is consolidating and removing experiments, while 2.0 is where the new surface area lands. The 2.0 surface is specifically the lakehouse catalog layer — dbt is moving from a tool that writes to a warehouse toward one that binds to open table catalogs directly, with materialization made catalog-aware. Notably 1.12.0rc1 also teaches the Python engine to tolerate Fusion-specific warn_error_options rather than erroring, so the two engines are being made to coexist in the same projects rather than fork.

◆ Prediction

The alphas are still expanding catalog coverage adapter by adapter, so expect further catalog integrations and continued catalogs.yml v2 work before 2.0 leaves alpha. On the Python side, with the deprecated flags now defaulted and the experimental commands removed, 1.12 looks like a stabilization point rather than a base for new features.

BigQuery logo
BigQuery
INFRA · APISANALYTICS
0.0

BigQuery is making itself agent-callable and pulling inference inside the SQL boundary.

◆ Current state

Two GA milestones define the current position: the BigQuery MCP server, and the managed AI functions AI.IF, AI.SCORE and AI.CLASSIFY that run Gemini from inside a query. Alongside them, BigQuery Graph entered preview, and a steady GA cadence continues across sharing listings, materialized views over CDC tables, Snowflake transfers, code-asset folders and Dataform's strict act-as enforcement.

◆ Where it's heading

The warehouse is being repositioned as something agents call and models run inside, not a destination that pipelines feed. MCP handles the calling side; the AI functions handle the execution side; strict act-as and folder-level access handle the governance the first two make urgent.

◆ Prediction

Expect the governance layer to develop fastest from here — finer control over what an agent can query and what inference it may run — since that is the constraint GA on both fronts now exposes.

dbt Core alternatives

Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Tap any card for the full editorial trajectory or compare directly with dbt Core.

See all dbt Core alternatives →

BigQuery alternatives

Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Tap any card for the full editorial trajectory or compare directly with BigQuery.

See all BigQuery alternatives →

Recent activity from dbt Core and BigQuery

Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.

  1. 16d agodbt CoreFusion alpha 5: Redshift datasharing catalogs and job-specific deferral
  2. 20d agodbt Coredbt-core 1.12.0 drops `dbt login` and the dbt-state plugin
  3. 21d agodbt Core1.12.0 release candidate 3
  4. 26d agodbt Core1.12.0 release candidate 2
  5. 29d agodbt Core1.12.0 release candidate 1
  6. 1mo agodbt CoreFusion gains read-write Iceberg REST catalogs and catalogs.yml v2
  7. 2mo agoBigQueryBigQuery May 2026 - Multi-region sharing listings GA and Data Transfer Service updates
  8. 3mo agoBigQueryMFA required for new Google Ads data transfers
  9. 3mo agoBigQueryGoogle Ads data retention policy change affecting BigQuery Data Transfer Service
  10. 3mo agoBigQueryBigQuery multi-region sharing listings go GA
  11. 3mo agoBigQueryBigQuery release notes — May 06, 2026 — Feature You can configure BigQuery sharing listings for multiple regions, which
  12. 3mo agoBigQueryBigQuery Data Transfer Service connectors Google Ads data retention policy change

Frequently asked questions

What is the difference between dbt Core and BigQuery?

They serve adjacent needs but don't currently overlap on shipped themes. dbt Core is currently shipping more aggressively (velocity 7.5 vs 0.0), with 1 editorial sparks in the last 30 days against 0. See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.

Is dbt Core better than BigQuery?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. dbt Core is currently shipping more aggressively (velocity 7.5 vs 0.0), with 1 editorial sparks in the last 30 days against 0. For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.

What are the best alternatives to dbt Core?

Top dbt Core alternatives in Analytics are ranked by recent ship velocity. Browse the "dbt Core alternatives" section above for the current picks, or visit /alternatives/dbt-core for the full list with editorial commentary on each.

What are the best alternatives to BigQuery?

Top BigQuery alternatives in Analytics are ranked by recent ship velocity. Browse the "BigQuery alternatives" section above for the current picks, or visit /alternatives/bigquery for the full list with editorial commentary on each.