dbt-cratedb2 0.0.1.dev1

dbt adapter for CrateDB 5.x, derived from dbt-postgres

dbt-cratedb2

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

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

About dbt

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.

Getting started

• Install dbt
• Read the introduction and viewpoint

Installation

Install dbt-cratedb2.

pip install 'dbt-cratedb2 @ git+https://github.com/crate-workbench/dbt-cratedb2.git'

psycopg2-binary vs. psycopg2

By default, dbt-cratedb2 installs psycopg2-binary. This is great for development, and even testing, as it does not require any OS dependencies; it's a pre-built wheel. However, building psycopg2 from source will grant performance improvements that are desired in a production environment. In order to install psycopg2, use the following steps:

if [[ $(pip show psycopg2-binary) ]]; then
    PSYCOPG2_VERSION=$(pip show psycopg2-binary | grep Version | cut -d " " -f 2)
    pip uninstall -y psycopg2-binary
    pip install psycopg2==$PSYCOPG2_VERSION
fi

This ensures the version of psycopg2 will match that of psycopg2-binary.

Contribute

• 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

Code of Conduct

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