Yellowbrick setup
Some core functionality may be limited.
- Maintained by: Community
- Authors: InfoCapital team
- GitHub repo: InfoCapital-AU/dbt-yellowbrick
- PyPI package:
dbt-yellowbrick
- Slack channel: n/a
- Supported dbt Core version: v1.7.0 and newer
- dbt support: Not Supported
- Minimum data platform version: Yellowbrick 5.2
Installing dbt-yellowbrick
Use pip
to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core
and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core
. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations.
Use the following command for installation:
python -m pip install dbt-core dbt-yellowbrick
Configuring dbt-yellowbrick
For Yellowbrick Data-specific configuration, please refer to Yellowbrick Data configs.
Profile configuration
Yellowbrick targets should be set up using the following configuration in your profiles.yml
file.
company-name:
target: dev
outputs:
dev:
type: yellowbrick
host: [hostname]
user: [username]
password: [password]
port: [port]
dbname: [database name]
schema: [dbt schema]
role: [optional, set the role dbt assumes when executing queries]
sslmode: [optional, set the sslmode used to connect to the database]
sslrootcert: [optional, set the sslrootcert config value to a new file path to customize the file location that contains root certificates]
Configuration notes
This adapter is based on the dbt-postgres adapter documented here Postgres profile setup
role
The role
config controls the user role that dbt assumes when opening new connections to the database.
sslmode / sslrootcert
The ssl config parameters control how dbt connects to Yellowbrick using SSL. Refer to the Yellowbrick documentation for details.
Was this page helpful?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.