dbt Core on Ubuntu 24.04 LTS by cloudimg

## dbt Core on Ubuntu 24.04 LTS by cloudimg

dbt Core (Apache-2.0) is the open-source data transformation framework that lets analytics engineers build, test and document data pipelines using SQL and Jinja. Write models as select statements and dbt handles dependency ordering, materialisation, schema tests, documentation and lineage. The cloudimg image installs dbt Core 1.9.4 in a Python virtualenv with the self-contained dbt-duckdb adapter and a worked example project, so the appliance runs end to end with no external data warehouse. Backed by 24/7 expert support.

Self-Contained

The bundled dbt-duckdb 1.9.3 adapter and a worked example project (seeds, staging views, a mart and schema tests) build, test and document a data mart against an embedded DuckDB database out of the box - no external warehouse required. Point the bundled profile at Snowflake, BigQuery, Redshift or Postgres for production.

Why Choose cloudimg?

* 24/7 Expert Support with guaranteed 24 hour response. Contact support@cloudimg.co.uk

* Production Ready from Launch Pre configured, security patched, and validated before publication

* Azure Native Integration Built with Azure Linux Agent, cloud init, and Gen2 Hyper V

What is Included

* dbt Core 1.9.4 in a virtualenv at /opt/dbt/venv, on PATH as /usr/local/bin/dbt

* The dbt-duckdb 1.9.3 adapter so the image runs end to end with no external data warehouse

* A worked example project (seeds, staging views, a mart and schema tests) at /opt/dbt/example

* A per-user writable copy at ~/dbt-example for every login user

* 24/7 cloudimg support

This is a command-line product - there is no web UI. Drive dbt over SSH.

Use Cases

SQL-based data transformation, analytics engineering, data testing and documentation, building data marts, and a self-hosted dbt runner for CI/CD against your warehouse.

Visit www.cloudimg.co.uk/guides/dbt-core-on-ubuntu-24-04-azure for the full user guide.

dbt and the dbt logo are trademarks of dbt Labs, Inc. This image is community-packaged by cloudimg and is not affiliated with or endorsed by dbt Labs, Inc. All trademarks are the property of their respective holders.