Skip to content

Commands for dbt Core

Run dbt commands as part of an orchestration job.

For a how-to guide, please see this video.

Note

This component is generally available from version 1.70 of Matillion ETL for Snowflake, Delta Lake on Databricks, and Amazon Redshift.

Properties

Name = string

A human-readable name for the component.

External File Source = drop-down

Drop-down menu for an external file source. Users can set up external file source connections in the Manage External File Sources modal.

Command = string

A dbt command to execute. Currently, a single Commands for dbt Core component can run a single dbt command. To learn more about dbt commands, read dbt Command Reference.

The dbt Run command runs dbt models stored in the Git repository you have cloned and synced. The Run command will run all models stored in your repository unless you specify a particular model.

Specify a model by running dbt run --{name_of_dbt_model}.

Config = string

Add a configuration parameter of the profiles.yml file. Accepts grid variables. Users can also toggle Text Mode.

  • Key: The parameter name.
  • Value: The parameter value.
  • Data Type: String, number, or Boolean.

Map dbt Environment Variables = column editor

Specify any dbt environment variables and their values.

Folder Path = filepath

An exact folder path within the file source structure. Accepts job variables.

Profile Config = column editor

Assign additional output parameters or override existing parameters of the profiles.yml file. Accepts grid variables. Users can also toggle Text Mode.

  • Key: The parameter name.
  • Value: The parameter value.
  • Data Type: String, number, or Boolean.

Cloud data warehouse parameter documentation is available below:

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
✅ ✅ ✅ ❌ ❌