Greenplum setup
Overview of dbt-greenplum
- Maintained by: Community
- Authors: Mark Poroshin, Dmitry Bevz
- GitHub repo: markporoshin/dbt-greenplum
- PyPI package:
dbt-greenplum
- Slack channel: n/a
- Supported dbt Core version: v1.0.0 and newer
- dbt Cloud support: Not Supported
- Minimum data platform version: Greenplum 6.0
Installing dbt-greenplum
pip is the easiest way to install the adapter:
pip install dbt-greenplum
Installing dbt-greenplum
will also install dbt-core
and any other dependencies.
Configuring dbt-greenplum
For Greenplum-specifc configuration please refer to Greenplum Configuration
For further info, refer to the GitHub repository: markporoshin/dbt-greenplum
For further (and more likely up-to-date) info, see the README
Profile Configuration
Greenplum targets should be set up using the following configuration in your profiles.yml
file.
~/.dbt/profiles.yml
company-name:
target: dev
outputs:
dev:
type: greenplum
host: [hostname]
user: [username]
password: [password]
port: [port]
dbname: [database name]
schema: [dbt schema]
threads: [1 or more]
keepalives_idle: 0 # default 0, indicating the system default. See below
connect_timeout: 10 # default 10 seconds
search_path: [optional, override the default postgres search_path]
role: [optional, set the role dbt assumes when executing queries]
sslmode: [optional, set the sslmode used to connect to the database]
Notes
This adapter strongly depends on dbt-postgres, so you can read more about configurations here Profile Setup
0