The set of adapter protocols and base functionality that supports integration with dbt-core
Project description
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.
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
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file dbt_postgres-1.10.0.tar.gz.
File metadata
- Download URL: dbt_postgres-1.10.0.tar.gz
- Upload date:
- Size: 160.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
74dc7e8b531ab785bca9d44f3d1ee9b38c4cbac967eafe7373242ed181eb0fa2
|
|
| MD5 |
f786666d90bb2ef30c33622061ee8f42
|
|
| BLAKE2b-256 |
53f26d101b917c9f4a6c09a15cc239dc360be5b1115e27d5bdac9c6c3bead5f1
|
Provenance
The following attestation bundles were made for dbt_postgres-1.10.0.tar.gz:
Publisher:
publish-oss.yml on dbt-labs/dbt-adapters
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dbt_postgres-1.10.0.tar.gz -
Subject digest:
74dc7e8b531ab785bca9d44f3d1ee9b38c4cbac967eafe7373242ed181eb0fa2 - Sigstore transparency entry: 775684508
- Sigstore integration time:
-
Permalink:
dbt-labs/dbt-adapters@1e7448f9b6c3440d28fefd5b34b6dcf86c36def1 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/dbt-labs
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-oss.yml@1e7448f9b6c3440d28fefd5b34b6dcf86c36def1 -
Trigger Event:
workflow_dispatch
-
Statement type:
File details
Details for the file dbt_postgres-1.10.0-py3-none-any.whl.
File metadata
- Download URL: dbt_postgres-1.10.0-py3-none-any.whl
- Upload date:
- Size: 35.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9bc9d07342edbc86c16e20b2ab02c211c30c09b03736f925d612d963cbbe4f94
|
|
| MD5 |
7a700d4727162568d0d37af10477b768
|
|
| BLAKE2b-256 |
2c704f8ab84353844e5c5b2961d18f8c3d171b539c2c0425f855c550d766c960
|
Provenance
The following attestation bundles were made for dbt_postgres-1.10.0-py3-none-any.whl:
Publisher:
publish-oss.yml on dbt-labs/dbt-adapters
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
dbt_postgres-1.10.0-py3-none-any.whl -
Subject digest:
9bc9d07342edbc86c16e20b2ab02c211c30c09b03736f925d612d963cbbe4f94 - Sigstore transparency entry: 775684509
- Sigstore integration time:
-
Permalink:
dbt-labs/dbt-adapters@1e7448f9b6c3440d28fefd5b34b6dcf86c36def1 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/dbt-labs
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-oss.yml@1e7448f9b6c3440d28fefd5b34b6dcf86c36def1 -
Trigger Event:
workflow_dispatch
-
Statement type: