Skip to main content

overrides

models/<filename>.yml
version: 2
sources:  - name: <source_name>    overrides: <package name>
    database: ...    schema: ...

Definition#

Override a source defined in an included package. The properties defined in the overriding source will be applied on top of the base properties of the overridden source.

The following source properties can be overridden:

Examples#

Supply your database and schema name for a source defined in a package#

This example is based on the Fivetran GitHub Source package. Here, the database and schema is overridden in the parent dbt project which includes the github_source package.

models/src_github.yml
version: 2
sources:  - name: github    overrides: github_source
    database: RAW    schema: github_data

Configure your own source freshness for a source table in a package#

You can override configurations at both the source and the table level

models/src_github.yml
version: 2
sources:  - name: github    overrides: github_source
    freshness:      warn_after:        count: 1        period: day      error_after:        count: 2        period: day
    tables:      - name: issue_assignee        freshness:          warn_after:            count: 2            period: day          error_after:            count: 4            period: day