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