Can I build my models in a schema other than my target schema or split my models across multiple schemas?

Yes! Use the schema configuration in your dbt_project.yml file, or using a config block:

dbt_project.yml

name: jaffle_shop
...

models:
  jaffle_shop:
    marketing:
      +schema: marketing # models in the `models/marketing/` subdirectory will use the marketing schema

models/customers.sql

{{
  config(
    schema='core'
  )
}}

Was this page helpful?

Privacy policyCreate a GitHub issue

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.