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.
dbt-postgres
dbt-postgres enables dbt to work with Postgres.
For more information on using dbt with Postgres, consult the docs.
Getting started
Review the repository README.md as most of that information pertains to dbt-postgres.
psycopg2-binary vs. psycopg2
By default, dbt-postgres 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 help us build
dbt-postgres? Check out the Contributing Guide.
1 maintainer
Release files for dbt-postgres 1.11.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbt_postgres-1.11.0.tar.gz | 162.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbt_postgres-1.11.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 199.1 kB
Release files / dbt_postgres-1.11.0.tar.gz
| Download URL | dbt_postgres-1.11.0.tar.gz |
|---|---|
| Size | 162.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
0a8558e03776231969a9614075eb31eb7daca03bcee1db7bc36f85f027826965
|
|
BLAKE2b-256 checksum How to use checksums |
2f540af71f917d47a03f244aad15510e5df7853676e88c82be5c6afcef5464be
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jul 16, 2026.
Transparency logRelease files / dbt_postgres-1.11.0-py3-none-any.whl
| Download URL | dbt_postgres-1.11.0-py3-none-any.whl |
|---|---|
| Size | 36.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
b88f994dc2f00150579d62f8ff91af715428a3cfe064e067945359ca4509872c
|
|
BLAKE2b-256 checksum How to use checksums |
ba61e92738b7bdc6e36de7f2450ded77b221fd2768f85a345e93ff412ac95c7c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jul 16, 2026.
Transparency log
