sources_have_loader

Rule: `sources_have_loader`

Manifest Rule

sources_have_loader details

This rule ensures that dbt sources have a loader property defined. The loader describes the tool that loads data into your warehouse (e.g., Fivetran, Stitch, Airflow) and functions only as documentation.

Configuration

type: Must be sources_have_loader.
applies_to: (optional) List of dbt object types to check.
- Default: ["sources"]
- Options: sources

Common Rule Config

name: Human-readable name of the rule.
severity: "error" (fail) or "warning" (warn only).
- (optional, defaults to "error" if not specified)
description: Human-readable explanation of the rule.
includes: List of patterns to explicitly include for this rule.
Paths are relative to the original_file_path from the manifest.
Pattern syntax:
- * matches any characters except / (within a single directory)
- ** matches any characters including / (across directories)
- ^ at the start anchors to the beginning of the path
- $ at the end anchors to the end of the path
- Without anchors, pattern matches if it appears anywhere in the path (contains)
  Examples: ^models/staging/ - paths starting with models/staging/ orders - paths containing orders anywhere .sql$ - paths ending with .sql ^models/*.sql$ - SQL files directly in models/ folder ^models/**/*.sql$ - SQL files in any subfolder of models/
excludes: List of patterns to explicitly exclude from this rule.
Uses the same pattern syntax as includes.
Examples: ^models/legacy/ - exclude legacy models folder _deprecated - exclude paths containing _deprecated ^tests/ - exclude test files
model_materializations: Filter models by materialization type. Only applies when applies_to includes models.
  (optional, if not specified all materializations are included)
  Built-in types: table, view, incremental, ephemeral, materialized_view. Custom materializations are also supported.
  Example: ["table", "incremental"]

Example Config

manifest_tests:
  - name: "sources_have_loader"
    type: "sources_have_loader"
    description: "All sources must specify their loader."

[[manifest_tests]]
name = "sources_have_loader"
type = "sources_have_loader"
description = "All sources must specify their loader."

[[tool.dbtective.manifest_tests]]
name = "sources_have_loader"
type = "sources_have_loader"
description = "All sources must specify their loader."

Relevant dbt code

sources:
  - name: jaffle_shop
    loader: fivetran
    tables:
      - name: orders
      - name: customers

  - name: stripe
    loader: stitch
    tables:
      - name: payments

Rules

sources_have_loader

Rule: sources_have_loader

Rule: `sources_have_loader`