Skip to main content

The set of adapter protocols and base functionality that supports integration with dbt-core

Project description

dbt logo

CI Badge

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

The dbt-postgres package contains all of the code enabling dbt to work with a Postgres database. For more information on using dbt with Postgres, consult the docs.

Getting started

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.

Join the dbt Community

Reporting bugs and contributing code

Code of Conduct

Everyone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the dbt Code of Conduct.

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt_postgres-1.8.2.tar.gz (22.6 kB view details)

Uploaded Source

Built Distribution

dbt_postgres-1.8.2-py3-none-any.whl (33.1 kB view details)

Uploaded Python 3

File details

Details for the file dbt_postgres-1.8.2.tar.gz.

File metadata

  • Download URL: dbt_postgres-1.8.2.tar.gz
  • Upload date:
  • Size: 22.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/5.1.0 CPython/3.12.4

File hashes

Hashes for dbt_postgres-1.8.2.tar.gz
Algorithm Hash digest
SHA256 23b302626dd11e90594ccff0347148252c37af1a1e8c8710bc9c03b05337f3d3
MD5 0236998cb0dbd854225b77944aa899c3
BLAKE2b-256 9e5ab137c0c23217dd72cddfe7f48199ca206b4979224ef07b64984053ecf92a

See more details on using hashes here.

File details

Details for the file dbt_postgres-1.8.2-py3-none-any.whl.

File metadata

  • Download URL: dbt_postgres-1.8.2-py3-none-any.whl
  • Upload date:
  • Size: 33.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/5.1.0 CPython/3.12.4

File hashes

Hashes for dbt_postgres-1.8.2-py3-none-any.whl
Algorithm Hash digest
SHA256 b0d9f53b5927722cd22e8135e0b76181febf3cf89aef8caf039c59bfce78afc9
MD5 03744af13cae9703500379cf04e44214
BLAKE2b-256 21477c197563af138a39b226de5a14eec6edf98ea306e34040bcecee86cc2a17

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page