dbt-postgres

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

268 个版本 Python >=3.10.0

安装

pip install dbt-postgres

poetry add dbt-postgres

pipenv install dbt-postgres

conda install dbt-postgres

描述

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.

分类

Development Status :: 5 - Production/Stable License :: OSI Approved :: Apache Software License Operating System :: MacOS :: MacOS X Operating System :: Microsoft :: Windows Operating System :: POSIX :: Linux Programming Language :: Python :: 3.10 Programming Language :: Python :: 3.11 Programming Language :: Python :: 3.12 Programming Language :: Python :: 3.13

版本列表

1.11.0b2 2026-06-15

1.11.0b1 2026-05-22

1.10.1 2026-06-17

1.10.0 2025-12-22

1.10.0rc2 2025-12-10

1.10.0rc1 2025-11-19

1.10.0b2 2025-11-04

1.10.0b1 2025-10-07

1.9.1 2025-09-05

1.9.0 2024-12-09

1.9.0rc1 2024-12-02

1.9.0b1 2024-09-25

1.8.2 2024-06-21

1.8.1 2024-05-23

1.8.0 2024-05-09

1.8.0rc1 2024-05-01

1.8.0b5 2024-04-30

1.8.0b4 2024-04-16

1.8.0b2 2024-04-03

1.8.0b1 2024-03-01

1.7.19 2024-12-02

1.7.18 2024-08-07

1.7.17 2024-06-20

1.7.16 2024-06-05

1.7.15 2024-05-22

1.7.14 2024-05-02

1.7.13 2024-04-18

1.7.12 2024-04-16

1.7.11 2024-03-28

1.7.10 2024-03-14

1.7.9 2024-02-28

1.7.8 2024-02-14

1.7.7 2024-02-01

1.7.6 2024-01-25

1.7.5 2024-01-18

1.7.4 2023-12-14

1.7.3 2023-11-29

1.7.2 2023-11-16

1.7.1 2023-11-07

1.7.0 2023-11-02

1.7.0rc1 2023-10-12

1.7.0b2 2023-09-01

1.7.0b1 2023-08-17

1.6.18 2024-08-07

1.6.17 2024-06-20

1.6.16 2024-06-05

1.6.15 2024-05-22

1.6.14 2024-05-03

1.6.13 2024-04-18

1.6.12 2024-04-16

1.6.11 2024-03-28

1.6.10 2024-02-28

1.6.9 2023-11-16

1.6.8 2023-11-08

1.6.7 2023-11-01

1.6.6 2023-10-11

1.6.5 2023-10-02

1.6.4 2023-09-28

1.6.3 2023-09-19

1.6.2 2023-09-07

1.6.1 2023-08-23

1.6.0 2023-07-31

1.6.1rc1 2023-08-18

1.6.0rc2 2023-07-28

1.6.0rc1 2023-07-17

1.6.0b8 2023-06-30

1.6.0b7 2023-06-28

1.6.0b6 2023-06-23

1.6.0b5 2023-06-22

1.6.0b4 2023-06-13

1.6.0b3 2023-06-08

1.6.0b2 2023-05-25

1.6.0b1 2023-05-12

1.5.11 2024-03-28

1.5.10 2024-02-28

1.5.9 2023-10-31

1.5.8 2023-10-11

1.5.7 2023-09-28

1.5.6 2023-08-21

1.5.5 2023-08-17

1.5.4 2023-07-28

1.5.3 2023-07-17

1.5.2 2023-06-22

1.5.1 2023-05-30

1.5.0 2023-04-27

1.5.4rc1 2023-07-27

1.5.2rc2 2023-06-16

1.5.2rc1 2023-06-08

1.5.1rc2 2023-05-25

1.5.1rc1 2023-05-12

1.5.0rc2 2023-04-20

1.5.0rc1 2023-04-14

1.5.0b5 2023-03-30

1.5.0b4 2023-03-16

1.5.0b3 2023-03-02

1.5.0b2 2023-03-01

1.5.0b1 2023-02-17

1.4.9 2023-10-11

1.4.8 2023-09-20

1.4.7 2023-08-04

1.4.6 2023-04-19

1.4.5 2023-03-10

1.4.4 2023-02-28

1.4.3 2023-02-24

1.4.2 2023-02-23

1.4.1 2023-01-26

1.4.0 2023-01-25

1.4.2rc2 2023-02-22

1.4.2rc1 2023-02-15

1.4.0rc2 2023-01-19

1.4.0rc1 2023-01-11

1.4.0b1 2022-12-15

1.3.7 2023-10-11

1.3.6 2023-09-20

1.3.5 2023-08-04

1.3.4 2023-04-19

1.3.3 2023-02-28

1.3.2 2023-01-04

1.3.1 2022-11-16

1.3.0 2022-10-12

1.3.2rc1 2023-01-04

1.3.0rc2 2022-10-03

1.3.0rc1 2022-09-28

1.3.0b2 2022-08-29

1.3.0b1 2022-07-29

1.2.6 2023-04-19

1.2.5 2023-02-28

1.2.4 2023-01-05

1.2.3 2022-11-16

1.2.2 2022-10-03

1.2.1 2022-08-25

1.2.0 2022-07-26

1.2.1rc2 2022-08-18

1.2.1rc1 2022-08-11

1.2.0rc2 2022-07-20

1.2.0rc1 2022-07-11

1.2.0b1 2022-06-24

1.1.5 2023-04-19

1.1.4 2023-02-28

1.1.3 2023-01-05

1.1.2 2022-07-29

1.1.1 2022-06-15

1.1.0 2022-04-28

1.1.2rc1 2022-07-20

1.1.1rc2 2022-06-07

1.1.1rc1 2022-05-20

1.1.0rc3 2022-04-26

1.1.0rc2 2022-04-21

1.1.0rc1 2022-04-12

1.1.0b1 2022-03-23

1.0.9 2023-01-05

1.0.8 2022-06-15

1.0.7 2022-05-20

1.0.6 2022-04-27

1.0.5 2022-04-20

1.0.4 2022-03-18

1.0.3 2022-02-21

1.0.2 2022-02-18

1.0.1 2022-01-03

1.0.0 2021-12-03

1.0.6rc1 2022-04-26

1.0.5rc3 2022-04-12

1.0.5rc2 2022-04-08

1.0.5rc1 2022-03-21

1.0.2rc1 2022-02-04

1.0.1rc1 2021-12-20

1.0.0rc3 2021-11-30

1.0.0rc2 2021-11-22

1.0.0rc1 2021-11-10

1.0.0b2 2021-10-25

1.0.0b1 2021-10-11

0.21.1 2021-11-29

0.21.0 2021-10-04

0.21.1rc2 2021-11-15

0.21.1rc1 2021-11-03

0.21.0rc2 2021-09-27

0.21.0rc1 2021-09-20

0.21.0b2 2021-08-19

0.21.0b1 2021-08-03

0.20.2 2021-09-07

0.20.1 2021-08-11

0.20.0 2021-07-12

0.20.2rc2 2021-08-27

0.20.2rc1 2021-08-16

0.20.1rc1 2021-08-02

0.20.0rc2 2021-06-30

0.20.0rc1 2021-06-04

0.20.0b1 2021-05-03

0.19.2 2021-06-28

0.19.1 2021-03-31

0.19.0 2021-01-27

0.19.2rc2 2021-06-03

0.19.2rc1 2021-04-28

0.19.1rc2 2021-03-25

0.19.1rc1 2021-03-15

0.19.1b2 2021-02-15

0.19.0rc3 2021-01-27

0.19.0rc2 2021-01-14

0.19.0rc1 2020-12-29

0.19.0b1 2020-10-21

0.18.2 2021-03-22

0.18.1 2020-10-13

0.18.0 2020-09-03

0.18.2rc1 2021-03-12

0.18.1rc1 2020-10-01

0.18.1b3 2020-09-25

0.18.1b2 2020-09-22

0.18.1b1 2020-09-17

0.18.0rc2 2020-09-03

0.18.0rc1 2020-08-19

0.18.0b2 2020-07-30

0.18.0b1 2020-06-08

0.17.2 2020-07-29

0.17.1 2020-07-20

0.17.0 2020-06-08

0.17.2rc1 2020-07-28

0.17.2b1 2020-07-21

0.17.1rc4 2020-07-08

0.17.1rc3 2020-07-01

0.17.1rc2 2020-06-25

0.17.1rc1 2020-06-19

0.17.0rc4 2020-06-02

0.17.0rc3 2020-05-26

0.17.0rc2 2020-05-22

0.17.0rc1 2020-05-12

0.17.0b2 2020-05-08

0.17.0b1 2020-05-04

0.16.1 2020-04-14

0.16.0 2020-03-23

0.16.1rc1 2020-04-03

0.16.0rc4 2020-03-20

0.16.0rc3 2020-03-11

0.16.0rc2 2020-03-04

0.16.0rc1 2020-03-04

0.16.0b3 2020-02-26

0.16.0b2 2020-02-26

0.16.0b1 2020-02-10

0.15.3 2020-03-17

0.15.2 2020-02-02

0.15.1 2020-01-16

0.15.0 2019-11-25

0.15.3rc1 2020-02-19

0.15.1rc2 2019-12-30

0.15.1rc1 2019-12-18

0.15.0rc2 2019-11-19

0.15.0rc1 2019-11-08

0.15.0b3 2019-10-26

0.15.0b2 2019-10-22

0.15.0b1 2019-10-18

0.14.4 2019-11-08

0.14.3 2019-10-10

0.14.2 2019-09-13

0.14.1 2019-09-03

0.14.0 2019-07-10

0.14.3rc1 2019-10-01

0.14.1rc2 2019-08-28

0.14.1rc1 2019-08-22

0.14.1a1 2019-08-13

0.14.0rc1 2019-07-01

0.14.0a2 2019-06-25

0.14.0a1 2019-06-13

0.13.1 2019-05-13

0.13.0 2019-03-21

0.13.1a2 2019-05-09

0.13.1a1 2019-05-03

0.13.0rc1 2019-03-06

0.13.0a2 2019-02-18

0.13.0a1 2019-02-14