Hi, I'm having issues when running `dbt show` comm...
# community-support
l
Hi, I'm having issues when running
dbt show
command after I've added elementary profile to my dbt_project (now I have two profiles -
main
and
elementary
). It seems to be related to
on-run-end
hook, because running
show
in debug mode it shows that tries to run empty select statement that looks like this: select * from ( ) as model_limit_subq limit 5 and that it was invoked by
dbt_constraints.dbt_constraints-on-run-end-0
. I tried disabling the hooks in
dbt_project.yml
but it doesn't seem to affect
elementary
profile. In
target/compiled/elementary
directory two .sql files were generated
elementary-on-run-start-0
and
elementary-on-run-end-0
that just consist of couple empty lines. I know that this issue might be specific to my configuration, but maybe you know a way that would allow me to stop those hooks from being ran.
✅ 1
e
Hey there @Lukasz Wojcik! You can disable all the on run end hooks as per the docs.