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:

• description
• meta
• database
• schema
• loader
• quoting
• freshness
• loaded_at_field
• tags

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