Skip to main content

Yellowbrick setup

Community plugin

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 Cloud 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:

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.

target: 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


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.