dbt™️ Script checks
check-script-ref-and-source
check-script-ref-and-source
Arguments
--manifest
: location of manifest.json
file. Usually target/manifest.json
. This file contains a full representation of dbt project. Default: target/manifest.json
Example
Requirements
Model exists in manifest.json
1
Model exists in catalog.json
2
✅ Yes
❌ Not needed
1 It means that you need to run dbt parse
before run this hook (dbt >= 1.5).
2 It means that you need to run dbt docs generate
before run this hook.
check-script-semicolon
check-script-semicolon
Example
How it works
Hook takes all changed
SQL
files.It parses
SQL
and finds all sources and refs. If those objects do not exist inmanifest.json
, the hook fails.
Requirements
Model exists in manifest.json
1
Model exists in catalog.json
2
✅ Yes
❌ Not needed
1 It means that you need to run dbt parse
before run this hook (dbt >= 1.5).
2 It means that you need to run dbt docs generate
before run this hook.
How it works
Hook takes all changed
SQL
files.If the file contains a semicolon at the end of the file, the hook fails.
check-script-has-no-table-name
check-script-has-no-table-name
Arguments
--ignore-dotless-table
: consider all tables without dot in name as CTE
Example
Requirements
Model exists in manifest.json
1
Model exists in catalog.json
2
❌ Not needed
❌ Not needed
1 It means that you need to run dbt parse
before run this hook (dbt >= 1.5).
2 It means that you need to run dbt docs generate
before run this hook.
How it works
Hook takes all changed
SQL
files.SQL
is parsed and if it contains direct tables (not ref() or source()), the hook fails.
Last updated
Was this helpful?