Skip to content

crate/dbt-cratedb2

Repository files navigation

dbt logo

dbt logo

CI Badge » Unit Tests CI Badge » Integration Tests

dbt-cratedb2

Bluesky Release Notes Downloads per month

Package version License Status Supported Python versions

» Documentation | Changelog | PyPI | Issues | Source code | License | CrateDB | Community Forum

The dbt-cratedb2 package contains all the code enabling dbt to work with CrateDB Self-Managed or CrateDB Cloud.

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. dbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and pre-aggregate the raw data in your warehouse so that it's ready for analysis.

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

Installation

Install the most recent version of dbt-cratedb2.

pip install --upgrade dbt-cratedb2

Getting started

What's Inside

CrateDB is PostgreSQL-compatible, that's why dbt-cratedb2 heavily builds upon the canonical dbt-postgres adapter. For more information on using dbt with CrateDB, consult the docs.

psycopg2

By default, dbt-cratedb2 installs psycopg2-binary. For more information, please visit psycopg2 notes.

Project Information

Acknowledgements

Kudos to the authors of all the many software components this library is inheriting from and building upon, most notably the dbt-postgres package, and dbt itself.

Contributing

The dbt-cratedb2 package is an open source project, and is managed on GitHub. We appreciate contributions of any kind.

License

The project uses the Apache Software License, like the dbt-postgres project it is deriving from.

Code of Conduct

Everyone interacting with Crate.io's codebases, issue trackers, chat rooms, and mailing lists, please follow the CrateDB Code of Conduct.