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 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.

~/.dbt/profiles.yml
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.

0