The dbt-cratedb2 package contains all the code enabling dbt to work with a CrateDB database.

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.

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.

• Install dbt
• Read the introduction and viewpoint
• Read about how to use dbt with CrateDB

Install dbt-cratedb2.

pip install --upgrade 'dbt-cratedb2'

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

• Want to report a bug or request a feature? Let us know by opening an issue
• Want to help us build dbt-cratedb2? Check out the contributing guide
• Join the community on the CrateDB Community Discourse

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