Set operators

Unions

Providing multiple space-delineated arguments to the --select or --exclude flags selects the union of them all. If a resource is included in at least one selector, it will be included in the final set.

Run snowplow_sessions, all ancestors of snowplow_sessions, fct_orders, and all ancestors of fct_orders:

dbt run --select "+snowplow_sessions +fct_orders"

Intersections

If you separate multiple arguments for --select and --exclude with commas and no whitespace in between, dbt will select only resources that satisfy all arguments.

Run all the common ancestors of snowplow_sessions and fct_orders:

dbt run --select "+snowplow_sessions,+fct_orders"

Run all the common descendents of stg_invoices and stg_accounts:

dbt run --select "stg_invoices+,stg_accounts+"

Run models that are in the marts/finance subdirectory and tagged nightly:

dbt run --select "marts.finance,tag:nightly"