Currently Fivetran is limited to only executing 'dbt run' commands for dbt transformations.
When executing a 'dbt run' command, anyone who's data models have seed or snapshot dependancies, or requires tests to be included on each run, must add those separate commands in addition to 'dbt run'.
The 'dbt build' command solves the issue of needing to always execute these different commands. From to the dbt docs:
dbt buildcommand will:
- run models
- test tests
- snapshot snapshots
- seed seeds
In DAG order, for selected resources or an entire project.
One of Fivetran's selling points for us was 'integrated scheduling', specifically the ability to orchestrate model updates in dbt in sync with Fivetran tasks. But we need to be able to execute our model updates with snapshots, seeds, and tests. Without being able to customize the commands, or not being able to at least just execute 'dbt build', then the integrated scheduling feature will not be useful for our team.