Supported dbt Commands

You use dbt commands when defining jobs in either the deployment.yml file or in your Fivetran dashboard.

Fivetran supports the following dbt commands:

Command	Notes
`build`	Builds and tests all selected resources (models, seeds, snapshots, tests)
`clean`	Deletes artifacts present in the dbt project
`compile`	Compiles (but does not run) the models in a project
`deps`	Downloads dependencies for a project
`docs`	Generates documentation for a project. Note that we don't support the `docs serve` command.
`list`	Lists resources defined in a dbt project.
`run`	Runs the models in a project
`run-operation`	Invokes a macro, including running arbitrary maintenance SQL against the database
`seed`	Loads CSV files into the database
`snapshot`	Executes snapshot jobs defined in a project
`source`	Provides tools for working with source data (including validating that sources are fresh)
`test`	Executes tests defined in a project

Limitations

Fivetran does not support the following dbt commands:

Command	Notes
`cancel`	Cancels the most recent invocation. This is a dbt Cloud-specific command.
`debug`	Debugs dbt connections and projects. This is a dbt Cloud-specific command.
`docs serve`	Starts a webserver on port 8080 to serve documentation locally and opens the documentation site in the default browser.
`environment`	This is a dbt Cloud-specific command.
`help`	Enables you to interact with your dbt Cloud environment. This is a dbt Cloud-specific command.
`init`	Initializes a new dbt project
`reattach`	Reattaches to the most recent invocation to retrieve logs and artifacts. This is a dbt Cloud-specific command.

Fivetran does not support the following dbt command flags:

Flag	Notes
`--profiles-dir`	Path to `profiles.yml`. Overrides the default location (`~/.dbt`).
`--profile`	The profile name to use from the `profiles.yml` file. Overrides the default profile defined in `dbt_project.yml`.
`--target`	The target environment (e.g., `dev`, `prod`) as defined in `profiles.yml`. Overrides the default target defined in the profile.
`--write-json`	Determines whether dbt writes JSON artifacts, such as `manifest.json`, `run_results.json`, to the `target/` directory.
`--use-colors`	Enables colored terminal output.

If you specify any of these flags, they are silently overridden on job execution.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.