snow dbt execute commands¶

The snow dbt execute command executes one of the following dbt commands (https://docs.getdbt.com/reference/dbt-commands) on Snowflake:

• build (https://docs.getdbt.com/reference/commands/build)
• compile (https://docs.getdbt.com/reference/commands/compile)
• list (https://docs.getdbt.com/reference/commands/list)
• parse (https://docs.getdbt.com/reference/commands/parse)
• run (https://docs.getdbt.com/reference/commands/run)
• run-operation (https://docs.getdbt.com/reference/commands/run-operation)
• seed (https://docs.getdbt.com/reference/commands/seed)
• show (https://docs.getdbt.com/reference/commands/show)
• snapshot (https://docs.getdbt.com/reference/commands/snapshot)
• test (https://docs.getdbt.com/reference/commands/test)

For more information about using dbt commands, see the dbt Command reference (https://docs.getdbt.com/reference/dbt-commands).

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.