snow dbt execute commands¶

The snow dbt execute command executes one of the following dbt commands on Snowflake:

• build
• compile
• list
• parse
• run
• run-operation
• seed
• show
• snapshot
• test

For more information about using dbt commands, see the dbt Command reference.

Examples¶

The following examples show how to invoke snow dbt execute. The NAME argument identifies the dbt project object you want to run.

• Execute the build dbt command using a fully qualified object name:

  Copy code

  snow dbt execute uche_db.public.my_dbt_project build
  

• Execute the run dbt command using a short name and project variables (relies on the default database and schema set in your config.toml connection profile):

  Copy code

  snow dbt execute my_dbt_project run --vars "{'SCAN_DATE': '1997-01-01', 'environment': 'prod'}"
  

• Execute the test dbt command and select a specific model subset:

  Copy code

  snow dbt execute my_dbt_project test --select my_model
  

For more examples and workflow guidance, see Managing dbt Projects on Snowflake using Snowflake CLI.