Skip to main content

Set operators


Providing multiple space-delineated arguments to the --select, --exclude, or --selector 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


If you separate multiple arguments for --select, --exclude, and --selector 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,tag:nightly