Rocky
Rocky: An open-source SQL engine for tested models, lineage, and self-hosted pipelines. Ranked #21 of 36 in Data Transformation Tools by our editors (7.2/10); pricing: Free plan; best for teams building tested SQL models with lineage.
At a glance
- Editor score7.2 / 10
- PricingFree plan
- Best forTeams building tested SQL models with lineage
- Free planYes
- Paid fromFree
- Deployment modelSelf_hosted
- Facts checked25 Sep 2026
Where it wins
- Compile-time checks cover SQL, dependencies, and types
- Column-level lineage includes lineage diffs
- Schema contracts, declarative tests, and incremental strategies
Where it doesn't
- Self-hosted deployment requires teams to manage their environment
- Snowflake, BigQuery, and Trino adapters are in beta
- Warehouse adapter capabilities vary
Our verdict on Rocky
Rocky is an open-source SQL transformation engine for data platform engineers building production pipelines. Teams define SQL models with TOML configuration, then use compile-time SQL, dependency, and type checks alongside declarative tests and fixture-driven local tests. Its feature set suits small teams through enterprise groups that want model validation and lineage in their transformation workflow. Rocky is self-hosted and available as a command-line binary, with a Python SDK, VS Code extension, and Dagster integration.
Its strongest distinction is the breadth of checks and visibility around each model. Column-level lineage and lineage diffs help teams inspect how columns relate across transformations, while schema contracts and drift checks address changes in warehouse data. Incremental and merge materialization strategies support different model execution patterns; named branches and recorded-run replay extend the workflow around model changes. Per-model cost attribution and budget checks add a cost-focused view, and AI-assisted drafting includes compile validation. Local DuckDB is also supported for running models.
Warehouse fit is the main consideration when choosing Rocky. The vendor identifies Databricks as its primary production target, while Snowflake, BigQuery, and Trino adapters are in beta and adapter capabilities vary. Integrations also include Fivetran, Airbyte, and Dagster. Rocky is a strong candidate for teams whose warehouse setup matches its supported adapters and who want SQL-first modeling with explicit checks and lineage. Teams that require a production-ready adapter for a warehouse whose Rocky adapter is still in beta should evaluate an alternative or validate that fit before adopting it.
Your product? Our editors can test Rocky in depth and publish a review, labelled as paid · from $149/mo →
Rocky pricing
Rocky fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment model | Self_hosted |
| Transformation interface | Sql |
| Supported data formats | SQL; TOML; warehouse tables including Delta and Iceberg (adapter support varies) |
| Version control | Yes |
| Workflow orchestration | Yes |
| Data quality checks | Yes |
| Deployment | Self-hosted |
| Platforms | Windows, macOS, Linux |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 8 integrations: Databricks, Snowflake, BigQuery, Trino, DuckDB, Fivetran … |
| Pricing | Free plan |
| Website | rocky-data.dev |
| Facts checked | 25 Sep 2026 |
Rocky integrations
Rocky lists 8 integrations on its own site.
- Databricks
- Snowflake
- BigQuery
- Trino
- DuckDB
- Fivetran
- Airbyte
- Dagster
Alternatives to Rocky
- DataformA free, managed workflow service for SQL transformation and testing in BigQuery.9.2
- Alteryx DesignerA broad visual toolkit for enterprise analysts working across complex data environments.9.1
- Apache BeamA broad, portable framework for engineering teams building code-driven data pipelines.9.0
Used Rocky? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Rocky for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Rocky is listed in our Data Transformation Tools directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/rocky/"><img src="https://www.itechguides.com/best/badge/rocky.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update