dbt-project-evaluator
dbt-project-evaluator copied to clipboard
dbt-labs
Store the compiled code from hooks, or statistics on it
Describe the feature
As a project admin, I want to be able to analyze the code written in hooks on dbt models. dbt hooks can execute arbitrary SQL statements. The goal of capturing this data is to be able to catch situations in which business logic is embedded in hooks instead of being coded in dbt models themselves.
Describe alternatives you've considered
-
Linters might be able to achieve something similar. Scanning SQL Fluff's dbt templater I didn't see any obvious controls for hooks.
-
If storing the SQL code itself is problematic because of practical, security reasons, it might be useful to compute summary statistics e.g. total number of lines
Additional context
By having additional tools to align the dbt codebase, dbt users can better leverage additional features like restarting jobs from the point of failure.
Who will this benefit?
Groups migrating from legacy SQL systems to dbt.
Are you interested in contributing this feature?
Yes
