dbt Core

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

dbt Core is the open source data transformation framework that lets analytics engineers build, test and document data models in plain SQL, applying software engineering best practices to the transform step of your ELT pipeline. This image delivers dbt Core fully installed with the DuckDB adapter and a working sample project, so an engineer can SSH in and run a complete transform-test-document workflow immediately, with no external data warehouse and no setup.

Self-Contained Out Of The Box

The DuckDB adapter ships preconfigured to materialise models into a local DuckDB database file on a dedicated data disk, so the entire toolchain works with no Snowflake, BigQuery or Redshift account and no credentials. Run dbt seed, dbt run, dbt test, dbt build and dbt docs generate the moment you log in and watch real tables and views appear in the local warehouse. Confirm the toolchain end to end before pointing dbt at your own platform.

Working Sample Project

A complete sample project ships read only on the image: raw CSV seeds for customers, orders and payments flow through staging views into a customers and orders mart, with schema and data tests on the models. Copy it, study the structure and use it as the template for your own project, or replace it entirely.

Build, Test, Document

dbt compiles your SQL models into a DAG, runs them in dependency order, materialises them as views or tables, asserts your tests and generates a browsable documentation site with lineage graphs. Version your models in git, run them in CI and ship trustworthy, tested data.

Ready To Use

Connect over SSH and run dbt straight away. The virtual environment, the DuckDB adapter, the sample project and the profile are all in place, so the first dbt build populates the local warehouse on the data disk. Install additional adapters into the environment and point a new profile at your own data platform whenever you are ready.

cloudimg Support

24/7 technical support by email and chat. Help with project structure, model materializations, tests and snapshots, packages, macros, incremental models, documentation, connecting to your warehouse and CI integration.

Use Cases

A reproducible analytics engineering workstation with a pinned, ready-to-run dbt toolchain. A CI runner image for dbt build and test pipelines. A local development and prototyping environment using DuckDB before promoting models to a cloud warehouse. A training and evaluation sandbox for teams adopting dbt.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.