The dbt transformer uses SQL to transform data stored in your warehouse.

Getting Started #

Prerequisites #

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Installation and configuration #

Using the Command Line Interface #

  1. Add the dbt transformer to your project using meltano add : 

    meltano add transformer dbt
  2. Configure the settings below using meltano config .

Next steps #

Follow the remaining steps of the Getting Started guide:

  1. Transform loaded data for analysis

If you run into any issues, learn how to get help.

Settings #

Settings for dbt itself can be configured through dbt_project.yml as usual, which can be found at transform/dbt_project.yml in your Meltano project.

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

Project Directory (project_dir) #

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set project_dir <project_dir>

export DBT_PROJECT_DIR=<project_dir>

Profiles Directory (profiles_dir) #

  • Environment variable: DBT_PROFILES_DIR, alias: DBT_PROFILES_DIR
  • Default: $MELTANO_PROJECT_ROOT/transform/profile

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set profiles_dir <profiles_dir>

export DBT_PROFILES_DIR=<profiles_dir>

Target (target) #

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set target <target>

export DBT_TARGET=<target>

Source Schema (source_schema) #

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set source_schema <source_schema>

export DBT_SOURCE_SCHEMA=<source_schema>

Target Schema (target_schema) #

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set target_schema <target_schema>

export DBT_TARGET_SCHEMA=<target_schema>

Models (models) #

  • Environment variable: DBT_MODELS
  • Default: $MELTANO_TRANSFORM__PACKAGE_NAME $MELTANO_EXTRACTOR_NAMESPACE my_meltano_project

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config dbt set models <models>

export DBT_MODELS=<models>

Looking for help? #

If you're having trouble getting the dbt transformer to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page? #

This page is generated from a YAML file that you can contribute changes to. Edit it on GitHub!