dbt Commands
You use dbt commands in the following cases:
- in your
deployment.yml
file when defining jobs in Scheduled in Code for dbt Core* transformations. - in your Fivetran dashboard when defining dbt jobs for Scheduled in Fivetran for dbt Core* transformations
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. |
* 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.