Best software · Developer & data
9 Best Data Transformation Tools of 2026
This list is for analytics engineers who turn raw tables in Snowflake, BigQuery, Databricks or Redshift into tested, documented models that BI tools and stakeholders can trust. It covers SQL modeling frameworks (dbt, SQLMesh, Dataform), visual and low-code builders (Coalesce, Matillion), dbt workspaces and platforms (Paradime, Datacoves), a declarative lakehouse framework (Databricks Lakeflow Spark Declarative Pipelines) and a Python-friendly pipeline tool (Mage). We compared documented features and published prices for 9 tools, checked in November 2026. Scores weigh features at 40%, ease of use at 30% and value at 30%.
By the Mojolin research desk · Updated November 12, 2026 · 9 tools compared · Prices checked on vendor pages, latest November 12, 2026
Questions or corrections: editorial@mojolin.com
Mojolin is self-funded How we score
dbt is our top pick: it remains the standard way to write SQL models with tests and docs, and its hosted platform includes the IDE, scheduler and CI checks even on the free plan, with Starter at $100 per user per month. SQLMesh is the strongest alternative for teams that want to cut warehouse spend, since it rebuilds only changed models and creates dev environments from views, and it is free open source. Coalesce suits small teams that want visual modeling plus catalog and quality checks at $150 per user per month, and Dataform is the free default inside BigQuery. Paradime, Mage, Matillion, Datacoves and Databricks fill narrower needs: an AI dbt IDE, Python-heavy pipelines, low-code ingestion plus modeling, private cloud deployment and lakehouse streaming.
Top picks
Best overall
dbt
8.8 / 10
analytics engineering teams that want the most widely used modeling standard
Read the review →Runner-up
SQLMesh
8.7 / 10
teams that want state-aware builds and free virtual dev environments
Read the review →Also great
Coalesce
8.5 / 10
Snowflake and Databricks teams that want column-aware visual modeling
Read the review →Comparison table
| # | Tool | Pricing | Score | |
|---|---|---|---|---|
| 1 | dbt | analytics engineering teams that want the most widely used modeling standard | Free Developer plan with one seat; Starter is $100 per user per month with five developer seats | 8.8 |
| 2 | SQLMesh | teams that want state-aware builds and free virtual dev environments | SQLMesh is free open source; Tobiko Cloud pricing is quoted by sales | 8.7 |
| 3 | Coalesce | Snowflake and Databricks teams that want column-aware visual modeling | Free Developer plan for 1 user; Starter is $150 per user per month billed annually for up to 4 Transform users | 8.5 |
| 4 |  Dataform | BigQuery teams that want a free, built-in transformation layer | Free service; you pay for the BigQuery queries it runs and Cloud Logging | 8.5 |
| 5 |  Paradime | dbt teams that want an AI IDE and scheduler without buying a full platform | Code IDE from $20 per user per month with 1M DinoAI credits; Bolt scheduler from $180 per user per month | 8.2 |
| 6 |  Databricks Lakeflow Spark Declarative Pipelines | lakehouse teams that mix batch, streaming and Python in one pipeline | See vendor pricing (USD check pending) | 8.1 |
| 7 |  Mage | small teams that want Python, SQL and dbt in one orchestrated tool | Starter $29 per month plus $0.0167 per execution minute; Team $100 per month | 8.0 |
| 8 |  Matillion | teams that want low-code pipelines with ingestion and transformation together | See vendor pricing (USD check pending) | 7.9 |
| 9 |  Datacoves | regulated enterprises that need dbt and Airflow inside their own cloud | See vendor pricing (USD check pending) | 7.6 |
Scoring weights
Every tool gets three editorial scores out of 10, from vendor documentation, product pages and the published price. The overall score is the weighted average below, the same method on every list. Full method
The full ranking
Rank 1 · Best overall
dbt
SQL-first transformation framework from dbt Labs, sold as the hosted dbt platform with an IDE, scheduler, catalog and semantic layer.
getdbt.com8.8
out of 10
Best for: analytics engineering teams that want the most widely used modeling standard
dbt is the reference point for this category: models are SELECT statements in SQL, tests and documentation sit next to the code in YAML, and every build follows the dependency graph. The hosted dbt platform wraps that framework with a browser Studio IDE, a VS Code extension, job scheduling, CI checks on GitHub and GitLab, and source freshness reporting, all available on the free Developer plan for one seat.
Starter costs $100 per user per month and adds dbt Catalog lineage, the dbt Semantic Layer with 5,000 queried metrics a month and API access, for up to five developer seats and 15,000 successful model builds a month. Enterprise unlocks column-level lineage, dbt Mesh for multi-project setups, SSO, RBAC and SCIM. Two usage add-ons sit on top: dbt State, which skips unchanged models at $0.094 per daily active target table, and the dbt Wizard agent, billed by AI tokens. The main drawbacks are the single-project cap on Starter and the per-seat price as a team grows.
Standout feature
dbt is the best choice for teams standardizing on SQL modeling because its free Developer plan includes the browser IDE, job scheduling and CI checks on GitHub and GitLab.
Use cases
Analytics engineers
Model raw Snowflake tables into tested staging and mart layers
Outcome: Documented tables with tests that run on every scheduled job
Data leads
Define revenue and churn metrics once in the Semantic Layer
Outcome: BI tools query the same metric definitions
Solo analysts
Run a single dbt project on the free Developer plan
Outcome: Scheduled builds and CI checks without paying for seats
Key features
- Free Developer plan with one developer seat, 3,000 successful models built per month and 1 project
- Starter plan at $100 per user per month with five developer seats and 15,000 successful models built per month
- Git version control, testing, job scheduling, source freshness reporting and job alerts on every plan
- dbt Catalog lineage and the dbt Semantic Layer from Starter; column-level lineage and dbt Mesh multi-project architecture on Enterprise
- dbt CLI, VS Code extension, browser-based Studio IDE and a dbt MCP server
Pros
- Free plan includes the browser IDE, job scheduling and CI checks on GitHub and GitLab
- Starter adds the Semantic Layer with 5,000 queried metrics per month
- Optional dbt State add-on builds only what changed, billed at $0.094 per daily active target table
Cons
- Starter is capped at 1 project; multi-project dbt Mesh needs Enterprise
- SSO, RBAC and SCIM are Enterprise features with custom pricing
- Seat price of $100 per user per month adds up quickly for larger teams
Rank 2 · Runner-up
SQLMesh
Open-source data transformation framework from Tobiko Data, now part of Fivetran, with a hosted Tobiko Cloud edition.
tobikodata.com8.7
out of 10
Best for: teams that want state-aware builds and free virtual dev environments
SQLMesh approaches transformation as a state problem. It records which intervals and code versions each model has already processed, so a change rebuilds only the tables it actually affects. Virtual Data Environments give every developer an isolated copy of production built from views, which Tobiko says avoids extra warehouse processing, and a Terraform-style plan and apply step shows breaking and non-breaking impact before anything runs.
SQLMesh parses SQL with SQLGlot, so it can catch compile errors before the warehouse sees the query and transpile between dialects. Unit tests can be generated from a live query, and audits such as UNIQUE_VALUES and NOT_NULL sit in the model definition. The framework is open source and free to run; Tobiko Cloud adds a scheduler, alerts, a data catalog, a debugger and SSO, but its price is not published. Tobiko Data is now part of Fivetran. The learning curve is steeper than dbt for teams used to full rebuilds.
Standout feature
SQLMesh is the best choice for teams fighting warehouse bills because its Virtual Data Environments create isolated development copies without data warehouse costs.
Use cases
Analytics engineers
Test a column change in a virtual dev environment before promoting it
Outcome: Review downstream impact without copying production tables
Platform teams
Move a dbt project to state-aware incremental builds
Outcome: Fewer full rebuilds on large fact tables
Multi-warehouse teams
Write models once and transpile them to each target dialect
Outcome: One codebase across engines
Key features
- Virtual Data Environments create isolated development environments without data warehouse costs
- Plan and apply workflow, similar to Terraform, that shows the impact of a change before it runs
- Writes SQL in any dialect and transpiles it to the target warehouse dialect, with compile-time error checks across 10+ dialects
- Unit tests generated from live queries plus automated audits such as unique and not-null checks
- Runs SQL or Python models and can read existing dbt projects
Pros
- Open-source framework with no license fee
- Incremental models track processed intervals so a table is never built twice for the same data
- CI/CD bot supports blue-green deployments
Cons
- No published price for Tobiko Cloud, the hosted edition with scheduler, alerts and catalog
- Smaller community and fewer hosted IDE options than dbt
- Concepts such as plans and virtual environments take time for dbt users to learn
Rank 3 · Also great
Coalesce
Visual and code-based transformation platform that bundles Transform, Catalog and Quality modules on one account.
coalesce.io8.5
out of 10
Best for: Snowflake and Databricks teams that want column-aware visual modeling
Coalesce combines a visual node graph with SQL, so analysts can build staging, dimension and fact layers from templates while engineers still see and edit the generated code. Pricing is based on users plus actions, where an action is a successful production node run, a Catalog asset refresh or a monitor refresh. Runs in development are free and unmetered, which suits teams that iterate heavily before deploying.
The free Developer plan covers 1 user, Transform and Quality, and 2,000 capped monthly actions in 1 project. Starter costs $150 per user per month billed annually and allows up to 4 Transform users, 15,000 actions a month, full Catalog and Quality access with 3 catalog integrations, onboarding workshops and 24x5 support. Going over the action allowance does not break pipelines. The trade-offs are the single project and environment on Starter, the annual commitment and the jump to custom-priced Enterprise once a fifth builder joins.
Standout feature
Coalesce is the best choice for teams that iterate a lot before deploying because development runs are free and unmetered on every plan.
Use cases
Snowflake data teams
Build dimension and fact tables from reusable node templates
Outcome: Consistent modeling patterns across the warehouse
Analytics leads
Monitor production tables with Coalesce Quality
Outcome: Failed checks surface next to the pipeline that produced them
Small teams
Prototype on the free Developer plan
Outcome: Working models before committing to an annual plan
Key features
- Free Developer plan with 1 user, Transform and Quality, and 2,000 capped monthly actions
- Starter plan with up to 4 Transform users, 15,000 actions per month and full access to Transform, Catalog and Quality
- Development runs are free and unmetered; only production actions count
- Starter includes onboarding workshops and 24x5 support
- Enterprise adds unlimited projects and environments, SSO and priority support with SLAs
Pros
- Development is always free, so building and testing does not consume actions
- Overage does not stop pipelines; extra actions bill at a flat per-action rate
- Catalog and Quality are included with Transform on paid plans
Cons
- Starter is billed annually and limited to 1 project and 1 environment
- Teams of 5 or more Transform users must move to custom-priced Enterprise
- SSO is not available below Enterprise
Rank 4
Dataform
Google Cloud's free SQLX-based service for building, testing and scheduling transformations in BigQuery.
cloud.google.com8.5
out of 10
Best for: BigQuery teams that want a free, built-in transformation layer
Dataform is Google Cloud's answer to dbt for teams that live in BigQuery. Google describes its purpose plainly: after raw data is loaded into BigQuery, Dataform helps transform it into a well-defined, tested and documented suite of tables. Models are written in SQLX, an extension of SQL, with JavaScript available for reusable logic, and each repository can link to GitHub, GitLab or another Git provider.
Developers work in isolated workspaces, compile to standard SQL and inspect the result as an interactive dependency graph. Dataform resolves missing or circular dependencies at compile time, runs the graph in order in BigQuery, executes assertions to check data correctness and updates metadata in Knowledge Catalog. The service itself is free; the cost is the BigQuery compute for each run plus Cloud Logging. The main limit is scope: it targets BigQuery only, so multi-warehouse teams should look elsewhere.
Standout feature
Dataform is the best choice for BigQuery-only teams because the service is free and runs assertions on source and output tables inside BigQuery.
Use cases
BigQuery analysts
Turn raw GA4 and ad exports into documented reporting tables
Outcome: Tested tables without adding a paid tool
Google Cloud data teams
Version SQLX models in a linked GitHub repository
Outcome: Reviewed changes before they reach production
Startups
Schedule daily transformations with Cloud Scheduler or Workflows
Outcome: Automated builds paid only through BigQuery usage
Key features
- Dataform core, an extension of SQL, defines tables, dependencies and documentation in SQLX files
- Repositories with Git version control and links to third-party Git providers
- Development workspaces to compile, test and push changes
- Assertion queries test data correctness on source and output tables
- Interactive dependency graph of the compiled workflow
Pros
- No charge for Dataform itself
- Runs inside the BigQuery console with no extra vendor to approve
- Hermetic compilation produces the same SQL from the same code every time
Cons
- Works only with BigQuery
- Query costs land on your BigQuery bill, and Cloud Logging is required for every workflow invocation
- Smaller package ecosystem than dbt
Rank 5
Paradime
AI-assisted workspace for dbt that sells a Code IDE, the Bolt scheduler and Radar cost analytics as separate products.
paradime.io8.2
out of 10
Best for: dbt teams that want an AI IDE and scheduler without buying a full platform
Paradime is built around dbt rather than replacing it. Instead of plan tiers, it sells three products: a Code IDE, the Bolt scheduler and Radar for cost and performance analytics, with DinoAI usage metered on top. The Code IDE runs in the browser with real-time compiled SQL, data preview and column-level lineage, and bundles utilities such as SQLFluff, DuckDB, Lightdash and Elementary.
The IDE price depends on the DinoAI allowance: SPARK at $20 per user per month includes 1M credits, FLOW is $44 with 5M and VIBE is $84 with 10M. Bolt, which deploys dbt pipelines with Turbo CI and lineage diffs on pull requests, starts at $180 per user per month, and Radar Lite costs $300 a month. Read-only users are free. The modular model is flexible, but a team that wants IDE plus scheduler plus SSO through the Security Pack ends up with several line items to price.
Standout feature
Paradime is the best choice for teams that only want a better dbt editor because the Code IDE is sold on its own from $20 per user per month.
Use cases
Analytics engineers
Write and refactor dbt models with the DinoAI co-pilot
Outcome: Faster model changes with compiled SQL and lineage in view
Data platform leads
Run dbt jobs on Bolt with Turbo CI
Outcome: Pull requests show column-level lineage diffs before merge
FinOps owners
Track dbt model and warehouse costs in Radar
Outcome: Expensive models identified for tuning
Key features
- Browser Code IDE for dbt with column-level lineage, compiled SQL and data preview on every model
- Bolt scheduler with Turbo CI and column-level lineage diff on each pull request
- DinoAI agents and co-pilot metered in credits, from 1M credits on the SPARK tier
- Radar analytics with 60+ built-in metrics for dbt schedules, models, tests and source freshness
- Cross-platform lineage between dbt models and Looker, Tableau or ThoughtSpot
Pros
- Products are bought separately, so teams pay only for the IDE, scheduler or analytics they use
- Read-only users are free; only developer and admin seats are charged
- Includes dbt Core, SQLFluff, DuckDB, Lightdash and Elementary in the IDE
Cons
- Bolt starts at $180 per user per month, well above the IDE price
- DinoAI usage beyond plan credits is billed on top
- SSO, RBAC and audit logs need the Security Pack add-on
Rank 6
Databricks Lakeflow Spark Declarative Pipelines
Declarative batch and streaming pipeline framework on Databricks, built on Apache Spark Declarative Pipelines and Unity Catalog.
databricks.com8.1
out of 10
Best for: lakehouse teams that mix batch, streaming and Python in one pipeline
Lakeflow Spark Declarative Pipelines is Databricks' managed framework for declaring tables and materialized views and letting the engine handle ordering, state, retries and incremental processing. It unifies batch, micro-batch and low-latency real-time modes on Spark, in either SQL or Python, so the same pipeline can ingest streams and build analytics tables.
Expectations are the testing layer: rules on each table guarantee incoming data meets quality requirements and report results on every update. Development happens in the Lakeflow pipeline editor, which shows the DAG, previews data and flags errors inline, and Unity Catalog supplies governance and lineage. Pipelines run on serverless or classic compute, priced pay as you go with a 14-day free trial or committed-use discounts. For analytics engineers the drawbacks are lock-in to Databricks and a cost model tied to compute that is harder to predict than a seat price.
Standout feature
Lakeflow Spark Declarative Pipelines is the best choice for streaming-heavy lakehouse teams because one declarative pipeline runs batch, micro-batch and real-time modes.
Use cases
Lakehouse engineers
Build bronze, silver and gold tables from streaming sources
Outcome: Incremental tables with quality expectations on each layer
Analytics engineers on Databricks
Replace hand-built Spark jobs with declared materialized views
Outcome: Dependencies and refresh order handled by the framework
Data platform teams
Apply CDC feeds with Auto CDC
Outcome: Up-to-date tables without custom merge logic
Key features
- Declare tables and materialized views and let the framework resolve dependencies and incremental processing
- Expectations enforce data quality rules and report quality with each pipeline update
- Batch, micro-batch and real-time modes in one framework, in SQL or Python
- Lakeflow pipeline editor with DAG view, data preview, autocomplete and in-line errors
- Unity Catalog governance plus built-in lineage, update history and data quality reporting
Pros
- Handles streaming and CDC patterns such as Auto CDC without manual backfill logic
- Serverless option removes cluster management
- Built on the open Apache Spark Declarative Pipelines standard
Cons
- Runs only on Databricks
- Price depends on compute usage and is not shown on the pricing page as fetched
- Less natural for SQL-only analytics engineers than dbt-style tools
Rank 7
Mage
Pipeline platform with Python, SQL, R and dbt blocks, sold as managed Mage with per-minute execution billing.
mage.ai8.0
out of 10
Best for: small teams that want Python, SQL and dbt in one orchestrated tool
Mage is closer to an orchestrator with transformation built in than to a pure modeling framework. Pipelines are made of blocks written in Python, SQL, R or dbt, edited visually or as code, and the platform adds schedules, webhook triggers, sensors, backfills and cross-pipeline dependencies. Data quality features include validations, block and pipeline tests, freshness checks and schema checks with alerts by email, Slack or webhook.
Managed Mage starts at $29 a month for one developer seat plus $0.0167 per execution minute, where a standard minute includes 1 CPU and 4 GB RAM. Team costs $100 a month for up to 10 developer seats, with lineage, deployment workflows and 250 shared AI credits. Plans can be billed monthly or annually after a 7-day trial. The per-minute charge makes cost depend on workload, and SQL-first analytics engineers may prefer a dedicated modeling tool, with Mage used to run dbt alongside Python steps.
Standout feature
Mage is the best choice for budget teams because its Team plan covers up to 10 developer seats for $100 a month plus execution minutes.
Use cases
Small data teams
Run dbt models next to Python cleanup steps in one pipeline
Outcome: One scheduler and one set of alerts
Data engineers
Backfill a model after a logic change
Outcome: Historical partitions rebuilt from the UI
Startups
Add freshness and schema checks to warehouse tables
Outcome: Alerts in Slack when a source goes stale
Key features
- Python, SQL, R and dbt blocks in a visual pipeline editor and code editor
- Data validations, block and pipeline tests, freshness checks and schema checks
- Schedules, webhook and API triggers, sensors, backfills and cross-pipeline dependencies
- Lineage graph with impact analysis and upstream and downstream intelligence
- Branch-based dev, staging and production workflows with rollback
Pros
- Lowest paid entry price in this list at $29 a month
- Team plan covers up to 10 developer seats for $100 a month
- 7-day free trial with no credit card required
Cons
- Execution minutes are billed on top of the plan fee
- Starter has 1 developer seat and 1 development environment
- Not a dedicated SQL modeling framework; dbt runs inside Mage as a block
Rank 8
Matillion
Data Productivity Cloud with a low-code canvas plus SQL and Python components for loading and transforming data, and the Maia AI agent.
matillion.com7.9
out of 10
Best for: teams that want low-code pipelines with ingestion and transformation together
Matillion's Data Productivity Cloud is a low-code alternative for teams that would rather draw pipelines than write YAML. Transformations are designed on a visual canvas, with SQL and Python components for custom logic, real-time validation and data sampling, and a built-in Git repository. The same product also loads data through pre-built and custom connectors, so one tool can cover extraction and modeling.
Pricing is consumption-based: credits are spent on task hours while pipelines run, and validation or sampling is not billed. Developer includes 1 developer user and unlimited projects, Teams adds 5 developer users, an audit log and an SLA, and Scale adds custom SSO, hybrid deployment, lineage tracking, streaming CDC and 180-day log retention. Maia, Matillion's AI agent, works across all plans. The credit rate was not visible on the page we fetched, so cost planning needs a trial or a sales call.
Standout feature
Matillion is the best choice for low-code teams because one canvas covers connectors, SQL and Python transformations and Git version control.
Use cases
BI teams
Design warehouse transformations on a visual canvas
Outcome: Pipelines that non-specialists can read and maintain
Data engineers
Load SaaS data and transform it in the same pipeline
Outcome: One tool for ingestion and modeling
Enterprises
Run Matillion agents in their own cloud with hybrid deployment
Outcome: Data stays in their network on the Scale plan
Key features
- Low-code canvas with SQL and Python components to customize transformations
- Built-in Git repository on every plan, with bring-your-own Git on Scale
- Real-time validation and sampling components during development
- Pre-built connectors and custom connectors without coding
- Maia agentic AI that builds, manages and orchestrates pipelines
Pros
- Covers ingestion and transformation in one product
- Developer plan includes unlimited projects
- Validation and sampling are not billed; only pipeline runs consume credits
Cons
- Credit prices are not shown on the pricing page as fetched
- Data lineage, hybrid deployment and custom SSO are limited to the Scale plan
- Developer plan includes only 1 developer user
Rank 9
Datacoves
Managed dbt and Airflow platform with VS Code in the browser that can run in your own cloud account.
datacoves.com7.6
out of 10
Best for: regulated enterprises that need dbt and Airflow inside their own cloud
Datacoves positions itself as a dbt Cloud alternative for teams that cannot use hosted SaaS. It packages managed dbt, managed Airflow, VS Code in the browser, pre-built CI/CD and secrets management, and can install on Kubernetes inside the customer's own AWS, Azure or GCP account without VPC peering, or run as multi-tenant SaaS.
The workflow follows standard dbt practice: features are built on a branch, tested in Git, merged, and the main branch is picked up by Airflow on a schedule. Datacoves says most teams reach a production-ready environment within days and private deployments take weeks. Support is hands-on, with onboarding, architecture guidance and a shared channel covering dbt modeling and Airflow DAG design. The SaaS trial runs 14 days. Prices are not published, private deployment may add a setup charge, and teams must still understand both dbt and Airflow.
Standout feature
Datacoves is the best choice for teams with data residency rules because it deploys managed dbt and Airflow into the customer's own cloud account.
Use cases
Pharma and healthcare data teams
Run dbt and Airflow inside their own cloud account
Outcome: Pass security reviews that rule out hosted tooling
Analytics engineering managers
Onboard dozens of engineers to a preconfigured VS Code environment
Outcome: Developers productive in minutes
Data platform teams
Orchestrate dbt runs with Airflow DAGs
Outcome: One platform for transformation and scheduling
Key features
- Managed dbt and managed Airflow in one platform
- VS Code in the browser with a preconfigured developer environment
- Pre-built CI/CD pipelines, secrets management and governance guardrails
- Runs on Kubernetes in your AWS, Azure or GCP account, or as multi-tenant SaaS
- Query previews limited to 500 lines by default and not stored
Pros
- Private deployment for data residency and strict security reviews
- 14-day SaaS free trial with components chosen by the customer
- Every customer gets onboarding and a shared success channel instead of a ticket queue
Cons
- No published prices
- Private deployments may carry a setup charge
- Built on dbt and Airflow, so teams still need to know both tools
Frequently asked questions
+What is the best data transformation tool in 2026?
dbt is our top pick for analytics engineers. Its free Developer plan includes a browser IDE, testing, job scheduling and CI checks, and Starter costs $100 per user per month for up to five developer seats.
+Is dbt free to use?
Yes, in two ways. dbt Labs offers a free Developer plan with one developer seat and 3,000 successful models built per month, and the dbt framework itself can be run from the command line on your own infrastructure.
+What is the best free alternative to dbt Cloud?
SQLMesh is the strongest free alternative, an open-source framework from Tobiko Data that adds virtual development environments and state-aware incremental builds. BigQuery teams can also use Dataform, which Google lists as a free service billed only through BigQuery usage.
+What is the difference between dbt and SQLMesh?
SQLMesh tracks state, so it rebuilds only models affected by a change and creates development environments from views instead of copying tables. dbt has the larger ecosystem and a hosted platform with a free plan, while SQLMesh's hosted Tobiko Cloud is priced by sales.
+How much does Coalesce cost?
Coalesce has a free Developer plan for 1 user with 2,000 capped monthly actions. Starter costs $150 per user per month billed annually for up to 4 Transform users and 15,000 actions per month, and Enterprise pricing is custom.
+Which data transformation tool is best for BigQuery?
Dataform is the simplest choice for BigQuery because it is built into Google Cloud and free apart from BigQuery and Cloud Logging charges. dbt and SQLMesh also support BigQuery if you need a tool that works across warehouses.
+Do I need a separate tool for data transformation if I use Databricks?
Not necessarily. Databricks Lakeflow Spark Declarative Pipelines lets you declare tables and materialized views in SQL or Python with data quality expectations, and it handles batch and streaming in one framework. Many Databricks teams still use dbt when they want warehouse-portable SQL models.
About this list
Updated November 12, 2026 by the Mojolin research desk. Mojolin is self-funded
Questions or corrections: editorial@mojolin.com
More best software lists