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 |
|---|---|---|---|---|
| ✅ | ✅ | ✅ | ❌ | ❌ |